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 9 years ago
-
I want to run an inventory report which will show hardware 'Dell Service Information'. - Odiasempa 9 years ago
Answers (1)
Please log in to answer
Posted by:
chucksteel
9 years ago
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.
