Saturday, August 24, 2013

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

2 comments: