Symantec Management Platform (Notification Server)

Expand all | Collapse all

Does anyone have a good report to show Windows build number?

  • 1.  Does anyone have a good report to show Windows build number?

    Posted 09-13-2020 11:48 PM
    I know it is in the database somewhere because when I click on a client from manage computers I see it in ()'s but I haven't been able to track down where in the database it is stored.  Does anyone have an existing report they can share or even a link to where in the database certain info can be located?​


  • 2.  RE: Does anyone have a good report to show Windows build number?

    Posted 09-14-2020 04:15 AM

    I know it is in the database somewhere because when I click on a client from manage computers I see it in ()'s but I haven't been able to track down where in the database it is stored. Does anyone have an existing report they can share or even a link to where in the database certain info can be located?​
    Chris Burkhardt,  09-09-2020 10:51 AM
    The "build number" is in AeX AC Identification, if you really mean the Build number? If you mean the Windows 10 Version (1909 etc) then I suspect it's derived from the build number.



    Regards
    Martin


    ------------------------------
    Bangor University
    ------------------------------



  • 3.  RE: Does anyone have a good report to show Windows build number?

    Posted 09-14-2020 04:15 AM
    Edited by Johannes Bedrech 09-14-2020 04:15 AM
    Hi Chris Burkhardt,

    Take a look at this community post: https://community.broadcom.com/groups/communities/community-home/digestviewer/viewthread?MessageKey=bd3e3bdb-d212-4f65-bf32-1733fb1a86aa&CommunityKey=2eae875e-f73e-4358-8452-7bb8f7f27f59&tab=digestviewer#bmbd3e3bdb-d212-4f65-bf32-1733fb1a86aa-------------------------------------------

    Network23

    Original Message:
    Sent: 09-09-2020 10:51 AM
    From: Chris Burkhardt
    Subject: Does anyone have a good report to show Windows build number?

    I know it is in the database somewhere because when I click on a client from manage computers I see it in ()'s but I haven't been able to track down where in the database it is stored.  Does anyone have an existing report they can share or even a link to where in the database certain info can be located?​


  • 4.  RE: Does anyone have a good report to show Windows build number?

    Broadcom Employee
    Posted 09-14-2020 05:39 AM
    This version calculates using this function fnSysMask_GetWindows10_VersionCodeAsTable and [OS System Mask] value from Inv_AeX_AC_Identification data class.

    Example below:
    SELECT DISTINCT
    vc.[Name] AS [PC Name],
    ide.Domain,
    ide.[Last Logon User],
    ide.[Hardware Serial Number],
    ide.[OS Name] +
    CASE WHEN aa.ReleaseVer IS NULL
    THEN ''
    ELSE ' (' + CAST(aa.ReleaseVer AS nvarchar(8)) + ')'
    END AS [OS Name]
    FROM vRM_Computer_Item AS vc
    LEFT JOIN Inv_AeX_AC_Identification AS ide ON ide._ResourceGuid = vc.[Guid]
    OUTER APPLY dbo.fnSysMask_GetWindows10_VersionCodeAsTable( ide.[OS System Mask] ) aa

    Note:
    Windows version ( ) will be shown if basic inventory is sent from Symantec Management Agent 8.5 RU1 version (not lower than 8.5 RU1)

    Thanks,
    IP.

    ------------------------------
    Software QA Engineer
    Broadcom Inc.
    ------------------------------



  • 5.  RE: Does anyone have a good report to show Windows build number?

    Posted 09-14-2020 09:09 AM
    Thank you for the info.  I actually found the info online but hadn't had a chance to update this thread​ and unfortunately I can't seem to find the link so my apologies to the original poster.  It is very similar to what was already posted.

    select
        vc.name Computer
        ,VC.[OS Name]
        ,RelVer.ReleaseVer [Win10 Release Verision]
           ,OS.[Type]
        ,OS.Architecture
        ,OS.[Platform]
        ,OS.[OS Name] OperatingSystem
        ,os.[Service Pack]
        ,os.[OS Edition]
        ,os.TagFlags
    from VComputer vc
    JOIN  Inv_AeX_AC_Identification id ON id._ResourceGuid = vc.guid
    CROSS APPLY dbo.fnSysMask_GetAllSystemMaskAsStringTable( id.[OS System Mask]) OS   -->> the built in fnSysMask_GetAllSystemMaskAsStringTable contains a number of useful filter that can be used for filters
    CROSS APPLY dbo.fnSysMask_GetWindows10_VersionCodeAsTable( id.[OS System Mask]) RelVer  -->> the built in fnSysMask_GetWindows10_VersionCodeAsTable function contains the Windows 10 Release Number
    where vc.[OS Name] like '%Windows%'
    order by vc.[os name], os.[os edition]


  • 6.  RE: Does anyone have a good report to show Windows build number?

    Posted 09-14-2020 07:06 PM
    Sample of what i've been using, not sophisticated but works.
    SELECT ac.[Name]
    ,ac.[Domain]
    ,ac.[OS Name]
    ,ac.[Last Logon User]
    ,ac.[OS Build Number]
    FROM Inv_AeX_AC_Identification ac
    where ac.[OS Name] like 'Windows 10%'
    and ac.[OS Build Number] = '17763'