/build/static/layout/Breadcrumb_cap_w.png

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.
Posted by: gcarpenter 11 years ago
Green Belt
2

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
Red Belt
0

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
 
This website uses cookies. By continuing to use this site and/or clicking the "Accept" button you are providing consent Quest Software and its affiliates do NOT sell the Personal Data you provide to us either when you register on our websites or when you do business with us. For more information about our Privacy Policy and our data protection efforts, please visit GDPR-HQ