SQL Query : List all Windows Store Apps

The following query returns all Windows Store Apps, but you could also configure it to return all machines complete with all Store Apps.  This will return lots of data for each device though.

SELECT distinct
 A.ApplicationName0
 FROM v_GS_WINDOWS8_APPLICATION A
 JOIN v_GS_WINDOWS8_APPLICATION_USER_INFO AU ON A.FullName0 = AU.FullName0
 JOIN v_R_System RS ON A.ResourceID = RS.ResourceID
 order by ApplicationName0

SELECT distinct
 RS.Name0,
 A.ApplicationName0
 FROM v_GS_WINDOWS8_APPLICATION A
 JOIN v_GS_WINDOWS8_APPLICATION_USER_INFO AU ON A.FullName0 = AU.FullName0
 JOIN v_R_System RS ON A.ResourceID = RS.ResourceID
 order by Name0

Sample Output

Related posts

Leave a Comment