/build/static/layout/Breadcrumb_cap_w.png

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

Dell Service Information:

Top of Form

Service Tag:

 

System Type: 

 

Ship Date:

 

Country:

 

Last Updated:

 

Bottom of Form



2 Comments   [ + ] Show comments
  • some more information would be fine. - aragorn.2003 5 years ago
  • I want to run an inventory report which will show hardware 'Dell Service Information'. - Odiasempa 5 years ago

Answers (1)

Posted by: chucksteel 5 years ago
Red Belt
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.

Don't be a Stranger!

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

Sign up! or login

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