Thursday, May 28, 2015

SCCM Report for all the installed versions of Microsoft Project Professional

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

No comments:

Post a Comment