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

Read More