SCCM: Full Operating System Build - not available in ServiceNow

[eddy42]

We are trying to identify devices on our estate with a particular OS build due to an issue we are seeing and want to track.

The CI shows the OS Version but doesn't appear to be all of the information held in SCCM
e.g.

OS Version: 10.0.26100

in SCCM (see screenshot):

Operating system build: 10.0.26100

Full Operating system build: 10.0.26100.3194

It is this 3194 number that I want to bring through.  It doesn't exist on the table and I've checked the transform map and the import tables and can't see any reference to it.
Has anyone else come across this - is it something ServiceNow have missed or is it something I can add?

[Kieran Anson]

Hi,

SCCM stores information across a number of tables and views, and SN's OOB integration(s) will cater to the majority of customers.

If you require additional data, you'd need to review the existing data sources and modify, or create a new one. Your SCCM administrator can advise whether the 'Full Operating System Build' table is a field value available to you on a table you're already querying.

As an example, using SCCM Service Graph Connector, the SG-SCCM Computer Identity data source joins the following tables:

• v_GS_COMPUTER_SYSTEM
• V_GS_WORKSTATION_STATUS
• v_GS_SYSTEM
• v_GS_PC_BIOS
• v_GS_OPERATING_SYSTEM
• v_GS_COMPUTER_SYSTEM_PRODUCT
• v_GS_SYSTEM_ENCLOSURE
• v_GS_BASEBOARD
• v_GS_SYSTEM_CONSOLE_USAGE
• v_R_System

I believe v_GS_OPERATING_SYSTEM might hold the value you want in BuildNumber0 

[eddy42]

Thanks - I've checked buildnumber0 that comes through but only holds the 26100 bit.
According to the transform it is bringing back all rows from that tables but doesn't include that number - very strange as I assume it would be in tghe v_GS_OPERATING_SYSTEM table too.

[Kieran Anson]

The computer identity data source only pulls the following fields from v_GS_OPERATING_SYSTEM by default:

• Caption
• Version
• TimeStamp