/build/static/layout/Breadcrumb_cap_w.png

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

Needing to create and run a report that will show the hardware ID/ Serial Number. 

5 Comments   [ + ] Show comments
  • are these dells or a mix of manufactures? - SMal.tmcc 5 years ago
  • Do you just want a list of serial numbers or are there other fields you would like included? - chucksteel 5 years ago
  • I posted the wrong thing and can't edit it because I'm not "approved"... Sorry. - jguthrie 5 years ago
  • these are all dells? @smal.tmcc - dbyrd18 5 years ago
  • @chuckstell s/n, date of install with Mac Address - dbyrd18 5 years ago

Answers (2)

Posted by: chucksteel 5 years ago
Red Belt
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.


Comments:
  • 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. - danflynn 5 years ago
Posted by: jguthrie 5 years ago
Senior White Belt
0
Try this?

ShellCommandTextReturn(cmd /c wmic PATH Win32_SystemEnclosure GET SMBIOSAssetTag)

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