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

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.
Cancel
0 Comments   [ + ] Show Comments

Comments

Please log in to comment

Community Chosen Answer

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.

Answered 12/19/2012 by: gcarpenter
Green Belt

  • Ugh, 1142 ERROR.
  • This worked perfectly for the csv export! Thanks for the speedy reply.
Please log in to comment

Answers

0

Add SYSTEM_DESCRIPTION to your select statement.

Answered 12/19/2012 by: dugullett
Red Belt

  • Not 100% correct, as the DELL_WARRANTY information is on the KBSYS schema whilst MACHINE.SYSTEM_DESCRIPTION is on the ORG1 side.
    • I read right over the part where they were using the existing report. Good catch.
Please log in to comment
Answer this question or Comment on this question for clarity