This report will provide all the installed versions of Microsoft Project Professional including Machine names and user names.
The user name is addition to the SCCM out of box report
***********************************************************************************
SELECT DISTINCT sys.Netbios_Name0 AS [Machine Name], sys.User_Name0 AS [User Name],arp.DisplayName0 AS [MS Project version]
FROM v_R_System AS sys
INNER JOIN v_Add_Remove_Programs AS arp ON sys.ResourceID = arp.ResourceID
WHERE arp.DisplayName0 LIKE '%Microsoft Project Professional%')
************************************************************************************
More SCCM custom reports can be found here
The user name is addition to the SCCM out of box report
***********************************************************************************
SELECT DISTINCT sys.Netbios_Name0 AS [Machine Name], sys.User_Name0 AS [User Name],arp.DisplayName0 AS [MS Project version]
FROM v_R_System AS sys
INNER JOIN v_Add_Remove_Programs AS arp ON sys.ResourceID = arp.ResourceID
WHERE arp.DisplayName0 LIKE '%Microsoft Project Professional%')
************************************************************************************
More SCCM custom reports can be found here
No comments:
Post a Comment