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
[ - ] Hide Comments
Answer this question
or Comment on this question for clarity
Answers
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.
Please log in to comment
Comments