/bundles/itninjaweb/img/Breadcrumb_cap_w.png
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