Wednesday, March 11, 2015

SCCM report for workstation architecture

Previously I have created this report to list all the devices and architecture.
However, the following report will list only workstations (excludes servers) with hostname and device OS architecture type.
********************************************************************************************

SELECT     Name AS [Machine Name], SystemType AS [System Architecture]
FROM         vWorkstationStatus
WHERE     (SystemRole = 'Workstation')

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

No comments:

Post a Comment