SQL Query - All Software Installed on Specific Device Collection
Change the collection ID,
FROM dbo.v_R_System INNER JOIN
dbo.v_GS_ADD_REMOVE_PROGRAMS ON dbo.v_R_System.ResourceID = dbo.v_GS_ADD_REMOVE_PROGRAMS.ResourceID INNER JOIN
dbo.v_GS_OPERATING_SYSTEM ON dbo.v_R_System.ResourceID = dbo.v_GS_OPERATING_SYSTEM.ResourceID
Join _RES_COLL_collectionID as coll on S.Name0=coll.name
The multi-part identifier "S.Name0" could not be bound.
ReplyDeleteSELECT DISTINCT
ReplyDeletev_R_System.Name0 AS 'Device Name',
v_Add_Remove_Programs.DisplayName0 AS 'Software Name',
v_Add_Remove_Programs.Version0 AS 'Version'
FROM
v_R_System
INNER JOIN v_FullCollectionMembership ON v_R_System.ResourceID = v_FullCollectionMembership.ResourceID
INNER JOIN v_Add_Remove_Programs ON v_R_System.ResourceID = v_Add_Remove_Programs.ResourceID
WHERE
v_FullCollectionMembership.CollectionID = 'YOUR_COLLECTION_ID'
ORDER BY
'Device Name',
'Software Name'