Scripting

The Dell Service information resides in the table DELL_WARRANTY, with the service description in DELL_WARRANTY.SERVICE_LEVEL_DESCRIPTION

I would suggest you start with a simple report like

SELECT * FROM DELL_WARRANTY

WHERE DELL_WARRANTY.SERVICE_TAG = 'add one in here'

If you want to expand it out to include other data from the main MACHINE table you could try this one for starters

SELECT MACHINE.NAME,

       DELL_WARRANTY.SERVICE_TAG,

       DELL_WARRANTY.SERVICE_LEVEL_DESCRIPTION,

       DELL_WARRANTY.END_DATE

  FROM DELL_WARRANTY DELL_WARRANTY

       INNER JOIN MACHINE MACHINE

          ON (DELL_WARRANTY.SERVICE_TAG = MACHINE.BIOS_SERIAL_NUMBER) 

WHERE MACHINE.NAME = 'add one in here'

I have added the where statements on both so that you can restrict the report to a single record as you test, otherwise running the report openly on the database may produce large data set.

Indigo Mountain is a Quest Silver + partner and operates as KACE professional services in the UK market place and has over a decade of KACE Service delivery

Thanks a lot, it works.