Monday, July 28, 2014

SCCM report for Machine name and OS deployed date

This report provides the Machine Name and when OS deployed to that machine.
*********************************************************************
SELECT v_R_System.Name0 AS [Machine Name], v_GS_OPERATING_SYSTEM.InstallDate0 AS [OS Deployed On]
FROM   v_GS_OPERATING_SYSTEM
INNER JOIN
v_R_System ON v_GS_OPERATING_SYSTEM.ResourceID = v_R_System.ResourceID



**********************************************************************
More SCCM custom reports can be found here

No comments:

Post a Comment