Monday, February 6, 2012

SCCM SQL Query: List all systems by 'Computer Description'

Upper management made the decision to create a standardized convention for computers on our network based on the Computer Description field in Windows. They wanted a quick report to show what was already there for everything on the network. This query did the trick :

SELECT DISTINCT CS.Name0 AS 'Computer Name', CS.UserName0, OS.Description0 AS 'Computer Description' FROM v_GS_OPERATING_SYSTEM OS, v_GS_COMPUTER_SYSTEM CS WHERE CS.ResourceID = OS.ResourceID ORDER BY CS.Name0
Hope you find it useful.

No comments:

Post a Comment