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
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