SCCM report for Machine and Operating System version

The following SQL query will give all the machines (Workstations and Servers) in the environment with their OS versions.

****************************************************************************

Select sys.name0,

cs.manufacturer0,
os.caption0
from v_R_System sys
INNER JOIN v_GS_COMPUTER_SYSTEM cs on sys.resourceID = cs.resourceID
INNER JOIN V_GS_Operating_system os on sys.resourceID = os.resourceID
Where os.caption0 like '%windows%'

****************************************************************************

More SCCM custom reports can be found here