SCCM report for Operating System

Below report will provide you

-          Machine Netbios name

-          User Domain

-          Username

-          Operating System (Windows 7)

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

SELECT Distinct

 sys.Netbios_Name0,

 sys.User_Domain0,

 sys.User_Name0,

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

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

The os.caption0 can be changed any operating system (%Windows XP% or %Windows 7% ) or all the windows operating systems by %Windows%.

More SCCM custom reports can be found here

 Venu Singireddy