Computer Inventory Description Field
I would like to add the Descripion listed on the Computer Inventory page to the Dell Waranty Reports. Can anyone tell me what to use to query this field in the report?
Thanks,
Ron
0 Comments
[ + ] Show comments
Answers (2)
Answer Summary:
If you are using the standard Dell Warranty Report on KACE, you'll want to: JOIN MACHINE M ON (M.BIOS_SERIAL_NUMBER = DA.SERVICE_TAG) in the FROM statement and you can add: M.SYSTEM_DESCRIPTION in the SELECT statement.
If you are using the standard Dell Warranty Report on KACE, you'll want to: JOIN MACHINE M ON (M.BIOS_SERIAL_NUMBER = DA.SERVICE_TAG) in the FROM statement and you can add: M.SYSTEM_DESCRIPTION in the SELECT statement.
Please log in to answer
Posted by:
gcarpenter
11 years ago
If you are using the standard Dell Warranty Report on KACE, you'll want to:
JOIN MACHINE M ON (M.BIOS_SERIAL_NUMBER = DA.SERVICE_TAG)
in the FROM statement and you can add:
M.SYSTEM_DESCRIPTION
in the SELECT statement.
Comments:
-
Ugh, 1142 ERROR. - gcarpenter 11 years ago
-
This worked perfectly for the csv export! Thanks for the speedy reply. - 2iron 11 years ago
Posted by:
dugullett
11 years ago
Add SYSTEM_DESCRIPTION to your select statement.
Comments:
-
Not 100% correct, as the DELL_WARRANTY information is on the KBSYS schema whilst MACHINE.SYSTEM_DESCRIPTION is on the ORG1 side. - gcarpenter 11 years ago
-
I read right over the part where they were using the existing report. Good catch. - dugullett 11 years ago
