/bundles/itninjaweb/img/Breadcrumb_cap_w.png
Needing to create and run a report that will show the hardware ID/ Serial Number. 
5 Comments   [ - ] Hide 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
Please log in to comment

Community Chosen Answer


Answers

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

Please log in to comment
Answer this question or Comment on this question for clarity

Answers

0
Try this?

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

Please log in to comment