Sunday, February 26, 2017

SCCM report for Windows 10 versions

The following report provide you the machine name, logged on user name, Operating System build number and Operating system version.
This report is useful when performing Windows 10 servicing.
*****************************************************************************
SELECT v_R_System.Name0 AS [Machine name], v_R_System.User_Name0 AS [User name], v_GS_OPERATING_SYSTEM.BuildNumber0 AS [OS Build Number], v_GS_OPERATING_SYSTEM.Caption0 AS [OS version]
FROM v_GS_OPERATING_SYSTEM INNER JOIN v_R_System ON v_GS_OPERATING_SYSTEM.ResourceID = v_R_System.ResourceID INNER JOIN
 v_FullCollectionMembership ON v_R_System.ResourceID = v_FullCollectionMembership.ResourceID
WHERE (v_FullCollectionMembership.CollectionID = N'SCB00018')
*****************************************************************************
More SCCM custom reports can be found here

No comments:

Post a Comment