/build/static/layout/Breadcrumb_cap_w.png

Service Level Description

Hello,

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?


0 Comments   [ + ] Show comments

Answers (2)

Answer Summary:
Posted by: Hobbsy 2 weeks ago
Red Belt
0

Top Answer

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


Posted by: HB-Support 2 weeks ago
White Belt
0

Thanks a lot, it works.

Don't be a Stranger!

Sign up today to participate, stay informed, earn points and establish a reputation for yourself!

Sign up! or login

View more:

Share

 
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