/bundles/itninjaweb/img/Breadcrumb_cap_w.png

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

  • Odiasempa
    White Belt
  • How helpful is this to you?
  • Average Rating 3
  • 923 views
  • 07/15/2015

Dell Service Information:

Top of Form

Service Tag:

 

System Type: 

 

Ship Date:

 

Country:

 

Last Updated:

 

Bottom of Form


2 Comments   [ - ] Hide Comments

Comments

  • some more information would be fine.
  • I want to run an inventory report which will show hardware 'Dell Service Information'.
Please log in to comment
Answer this question or Comment on this question for clarity

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

Please log in to comment
Share SNMP OID and MIB Information
It’s easy to add custom SNMP OID GETs to your Dell KACE K1000 inventory, but where do you find the exact OIDs you need for a specific device? This is the place to share the OIDs and MIBs you have – and to request the ones you need.

Share

Related Questions

Related Links

Related Posts