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.
Community Chosen Answer
Please log in to answer
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