How to run an sql report or otherwise of 'Dell Service Information'?
Dell Service Information:
Please log in to answer
Posted by: chucksteel 5 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.