ITMS Administrator Group

Expand all | Collapse all

OS Version and OS Build data needed

Jump to Best Answer
  • 1.  OS Version and OS Build data needed

    Posted 10-11-2016 11:42 AM
      |   view attached

    Hello all,

    I've been trying to locate a table that specifically references the Windows Version and OS Build information (see attached).  This is not the OS name and edition; but version and OS Build.

    I've been unsuccessful so far.

    Does anyone know which table/tables has that information?

    Thanks for any assistance.

    -David



  • 2.  RE: OS Version and OS Build data needed
    Best Answer

    Trusted Advisor
    Posted 10-12-2016 03:37 AM

    Does Inv_AeX_AC_Identification not contain what you need?

     

    SELECT 
    	--*
    	Name
    	,[System Type]
    	,[OS Name]
    	,[OS Type]
    	,[OS Version]
    	,[OS Revision]
    	,[OS Major Version]
    	,[OS Minor Version]
    	,[OS Build Number]
    FROM Inv_AeX_AC_Identification

     



  • 3.  RE: OS Version and OS Build data needed

    Posted 10-12-2016 02:18 PM

    Hi DHeinz57,

    The requested information is not in the database because inventory solution or basic inventory does not collect the exact build number.
    If you want to get the buildnumber you have to create a custom inventory. Hopefully Symantec will extend inventoy or basic inventory to collect the exact build number...

    To create the Custom Inventory create a customdataclass with the follwinging information:custominv_osbuild.png

    After creation of the custom dataclass create a new Task (Powershell) and paste in the following Powershell script:

    #************************DO NOT EDIT********************************
    $nse = new-object -comobject Altiris.AeXNSEvent
    $nse.priority = 1
    $nse.To = "{1592B913-72F3-4C36-91D2-D4EDA21D2F96}"
    #************************DO NOT EDIT********************************
    
    #Modify this varaible with the custom data class guid
    $objDCInstance = $nse.AddDataClass("Windows Version")
    
    $objDataClass = $nse.AddDataBlock($objDCInstance)
    
    $Build = $(Get-ItemProperty -Path 'Registry::HKEY_LOCAL_MACHINE\Software\Microsoft\Windows NT\CurrentVersion' CurrentBuild).CurrentBuild
    $Revision = $(Get-ItemProperty -Path 'Registry::HKEY_LOCAL_MACHINE\Software\Microsoft\Windows NT\CurrentVersion' UBR).UBR
    $WinVer = $Build + "." + $Revision
    
    ####Add new row of data
    $objDataRow = $objDataClass.AddRow()
    
    $objDataRow.SetField(0, $WinVer)
    
    #Send the data
    $nse.sendqueued()
    

    It should look like....
    customInventory.png

    You could create a Report based on the data in the table...

    Network23



  • 4.  RE: OS Version and OS Build data needed

    Posted 10-13-2016 11:59 AM

    Thanks guys for the quick response!

    I used AlexHedley's suggestion as the Inv_AeX_AC_Identification.[OS Build Number] was close to what I needed; not the full build number, but enough for me to write a SQL CASE statement in a report similiar to below:

            CASE
                WHEN os.[OS Build Number] LIKE '9600%' THEN 'Possible Win8 or Win8 Upgrade'
                WHEN os.[OS Build Number] LIKE '10240%' THEN 'Initial Release'
                WHEN os.[OS Build Number] LIKE '10586%' THEN '1511'
                WHEN os.[OS Build Number] LIKE '14393%' THEN '1607'
                ELSE 'Not Win10'
                END AS 'OS Version',

    I will look into the custom inventory option to pull the OS version as well as this will be very helpful especially with the "Anniversary Update".  I'm sure this is just the first of many version changing updates.

    -David