locked
SCCM Computer Devices Captured Not Showing the Serial Number RRS feed

  • Question

  • Greetings!

    Anyone knows how to configure SCCM 2012 R2 to show Computer's Serial Number when such devices are discovered ?

    Currently the properties for the devices in concern, its discovery data shows no Serial Number property.

    I think that is a critical piece of data in Hardware Inventory management that we need. Your input is greatly appreciated.

    Sergio M. 

    Wednesday, February 17, 2016 8:40 PM

Answers

  • So, you want to be able to view the serial number in the device view of the console? I don't think you can add it as a column in that view, but you could create a report. Example here:

    https://blogs.technet.microsoft.com/infratalks/2013/09/10/sccm-2012-reporting-get-system-serial-number-create-custom-ssrs-report/

    Or you can go to Monitoring -> Overview -> Queries, and make a query that output the results in a column view. Just create a new query and name it something like "All Systems (with Serial Number)" then use this query (which is just a copy of the built-it "All Systems" query joined with the PC BIOS information)

    select SMS_R_System.Name,
    SMS_G_System_PC_BIOS.SerialNumber,
    SMS_R_System.SMSAssignedSites,
    SMS_R_System.IPAddresses,
    SMS_R_System.IPSubnets,
    SMS_R_System.OperatingSystemNameandVersion,
    SMS_R_System.ResourceDomainORWorkgroup,
    SMS_R_System.LastLogonUserDomain,
    SMS_R_System.LastLogonUserName,
    SMS_R_System.SMSUniqueIdentifier,
    SMS_R_System.ResourceId,
    SMS_R_System.ResourceType,
    SMS_R_System.NetbiosName,
    SMS_R_System.ClientType from  SMS_R_System join
    SMS_G_System_PC_BIOS on SMS_G_System_PC_BIOS.ResourceID = SMS_R_System.ResourceId

    Or, you can right-click the device and go to Start -> Resource Explorer -> Hardware -> PC BIOS if you just need to view it for single machines periodically.

    • Edited by KevinMJohnston Wednesday, February 17, 2016 10:19 PM
    • Proposed as answer by Frank Dong Thursday, February 18, 2016 7:39 AM
    • Marked as answer by Frank Dong Friday, February 26, 2016 9:13 AM
    Wednesday, February 17, 2016 9:19 PM
  • The serial number is collected by default, so what exactly do you mean by discovered? Before or after the CM client is installed?

    Garth Jones

    Blog: http://www.enhansoft.com/blog Old Blog: http://smsug.ca/blogs/garth_jones/default.aspx

    Twitter: @GarthMJ Book: System Center Configuration Manager Reporting Unleased

    • Proposed as answer by Frank Dong Thursday, February 18, 2016 7:39 AM
    • Marked as answer by Frank Dong Friday, February 26, 2016 9:13 AM
    Wednesday, February 17, 2016 9:46 PM

All replies

  • So, you want to be able to view the serial number in the device view of the console? I don't think you can add it as a column in that view, but you could create a report. Example here:

    https://blogs.technet.microsoft.com/infratalks/2013/09/10/sccm-2012-reporting-get-system-serial-number-create-custom-ssrs-report/

    Or you can go to Monitoring -> Overview -> Queries, and make a query that output the results in a column view. Just create a new query and name it something like "All Systems (with Serial Number)" then use this query (which is just a copy of the built-it "All Systems" query joined with the PC BIOS information)

    select SMS_R_System.Name,
    SMS_G_System_PC_BIOS.SerialNumber,
    SMS_R_System.SMSAssignedSites,
    SMS_R_System.IPAddresses,
    SMS_R_System.IPSubnets,
    SMS_R_System.OperatingSystemNameandVersion,
    SMS_R_System.ResourceDomainORWorkgroup,
    SMS_R_System.LastLogonUserDomain,
    SMS_R_System.LastLogonUserName,
    SMS_R_System.SMSUniqueIdentifier,
    SMS_R_System.ResourceId,
    SMS_R_System.ResourceType,
    SMS_R_System.NetbiosName,
    SMS_R_System.ClientType from  SMS_R_System join
    SMS_G_System_PC_BIOS on SMS_G_System_PC_BIOS.ResourceID = SMS_R_System.ResourceId

    Or, you can right-click the device and go to Start -> Resource Explorer -> Hardware -> PC BIOS if you just need to view it for single machines periodically.

    • Edited by KevinMJohnston Wednesday, February 17, 2016 10:19 PM
    • Proposed as answer by Frank Dong Thursday, February 18, 2016 7:39 AM
    • Marked as answer by Frank Dong Friday, February 26, 2016 9:13 AM
    Wednesday, February 17, 2016 9:19 PM
  • The serial number is collected by default, so what exactly do you mean by discovered? Before or after the CM client is installed?

    Garth Jones

    Blog: http://www.enhansoft.com/blog Old Blog: http://smsug.ca/blogs/garth_jones/default.aspx

    Twitter: @GarthMJ Book: System Center Configuration Manager Reporting Unleased

    • Proposed as answer by Frank Dong Thursday, February 18, 2016 7:39 AM
    • Marked as answer by Frank Dong Friday, February 26, 2016 9:13 AM
    Wednesday, February 17, 2016 9:46 PM
  • Dear Sir,

    Garth is correct that the serial number is collected by default and it's in SQL DB (V_GS_PC_BIOS), just not showing on the console. You can think about Kevin's suggestion to create reports or queries.

    I used to view those hidden property by running console in Debug mode which I can see WMI Objects instances' properties by one click.

    Even complicated way is to build your own console view by using Console Builder. I've not tried yet, but as tool is there, it must make some sense.

    http://blogs.technet.com/b/matt_hinsons_manageability_blog/archive/2013/08/22/using-configmgr-2012-console-builder-create-custom-console-node.aspx

    Best regards

    Frank


    • Edited by Frank Dong Thursday, February 18, 2016 7:52 AM
    Thursday, February 18, 2016 7:51 AM