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 6 years ago
-
Do you just want a list of serial numbers or are there other fields you would like included? - chucksteel 6 years ago
-
I posted the wrong thing and can't edit it because I'm not "approved"... Sorry. - jguthrie 6 years ago
-
these are all dells? @smal.tmcc - dbyrd18 6 years ago
-
@chuckstell s/n, date of install with Mac Address - dbyrd18 6 years ago
Answers (2)
Please log in to answer
Posted by:
chucksteel
6 years ago
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 6 years ago
Posted by:
jguthrie
6 years ago
Try this?