SCCM report for Server name and Operating System version

This simple and easy report provides all the server names in the organization and provides the Operating System details.

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

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 '%server%'

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

 More SCCM custom reports can be found here