Service Level Description
we want to use the Dell Service Level Description for an external report. We can we find the information in Kace database and is it possible to create a xlsx report?
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
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