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 :
CS.Name0 AS 'Computer Name',
OS.Description0 AS 'Computer Description'
CS.ResourceID = OS.ResourceID
Hope you find it useful.