/build/static/layout/Breadcrumb_cap_w.png

KACE Product Support Question


How to run an sql report or otherwise of 'Dell Service Information'?

07/15/2015 1351 views

Dell Service Information:

Top of Form

Service Tag:

 

System Type: 

 

Ship Date:

 

Country:

 

Last Updated:

 

Bottom of Form


2 Comments   [ + ] Show comments

Comments

  • some more information would be fine.
  • I want to run an inventory report which will show hardware 'Dell Service Information'.

All Answers

0
Service Tag and System Type (assuming you mean model) are both stored in the MACHINE table. Ship Date is stored in the DELL_ASSET table. I'm not sure what you mean by Country, although the DELL_ASSET table does include COUNTRY_LOOKUP_CODE column. Do you have equipment shipped to different countries? My KBox only has values of 11 and 0 in it. I'm also not sure what you mean by "Last Updated". Do you want the last time the machine updated its inventory record? That is also in the MACHINE table.

Answered 07/16/2015 by: chucksteel
Red Belt

 
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