/build/static/layout/Breadcrumb_cap_w.png

Best Practices Question


How to create a custom report that will show the computer's S/N?

05/17/2018 1040 views
Needing to create and run a report that will show the hardware ID/ Serial Number. 
5 Comments   [ + ] Show comments

Comments

  • are these dells or a mix of manufactures?
  • Do you just want a list of serial numbers or are there other fields you would like included?
  • I posted the wrong thing and can't edit it because I'm not "approved"... Sorry.
  • these are all dells? @smal.tmcc
  • @chuckstell s/n, date of install with Mac Address


Community Chosen Answer

1
For just Dell hardware:
SELECT BIOS_SERIAL_NUMBER, OS_INSTALLED_DATE, MAC FROM ORG1.MACHINE
WHERE CS_MANUFACTURER like "Dell%"
Be advised that the OS_INSTALLED_DATE may depend on how you setup your machines. If you are performing a scripted install, then it should be accurate. If you are using an image, then I believe it will show the date that the OS was installed on the machine that was used to create the image.

Answered 05/24/2018 by: chucksteel
Red Belt

  • OS_INSTALLED_DATE will show the correct install data on a imaged machine as long as the image is properly sys-prepped. Also another thing to know that with Windows 10 when a machine upgrades from like 1709 to 1803 the install date will change to the date of that upgrade not the original 1709 install which makes sense as that really is a new OS being installed.

All Answers

0
Try this?

ShellCommandTextReturn(cmd /c wmic PATH Win32_SystemEnclosure GET SMBIOSAssetTag)
Answered 05/23/2018 by: jguthrie
Senior White Belt

Don't be a Stranger!

Sign up today to participate, stay informed, earn points and establish a reputation for yourself!

Sign up! or login

Share

 
This website uses cookies. By continuing to use this site and/or clicking the "Accept" button you are providing consent Quest Software and its affiliates do NOT sell the Personal Data you provide to us either when you register on our websites or when you do business with us. For more information about our Privacy Policy and our data protection efforts, please visit GDPR-HQ