SCCM SQL query to get the full OS version with build number

 Today, again we are going to create one SQL query..... 

Today we are going to pull the Operating System version with the build number. from SCCM SQL database.

For a single machine, you can run the command "Winver" from the run and you will get the below information

and you will get the OS Build version information as mentioned below.

Now we have to get this data from SCCM SQL database.

We are assuming that your machine is healthy CCM Client and inventory data has been sent to your SMS provider.

ok, login into the SQL DB server and create a new query. 

use the below sql query and get the desired report.

select Name0 as "Computer Name",AD_Site_Name0 as "AD Site",

User_Name0 as "User Name",CPUType0 as "CPU Type",

Client_Version0 as "SCCM Client Version",

Operating_System_Name_and0 as "Operatng System",

BuildExt as " Build Number" 

from vSMS_R_System

Hope this is helping you 😊. awaiting for your comments.