I am new to Dell Kace and I cannot figure out how to create a query that will pull up all of the following. 
  • Department
  • Asset Tag
  • User
  • Service Tag
  • Purchase Date  
Our company uses all Dell products and I have been tasked with creating a search that will include all of the listed. Can anyone assist me in a detailed description of how to create this in Dell Kace, or include a hyperlink that will show me how to perform this? Thanks.

Ray Masom
rmason@accriva.com
0 Comments   [ + ] Show Comments

Comments

Please log in to comment

Answers

0

 

The information you’re looking for is in two tables – DELL_ASSETand USER. I haven’t seen a Purchase Date field before but there is a SHIP_DATEfield in the DELL_ASSET table. To gather the information you’re after you’llneed to connect (JOIN) the DELL_ASSET and USER tables to the MACHINE table. Hereis a query I use but I have left of the conditions because yours would beunique to your requirements. You’ll need to add your own WHERE lines. The DELL_ASSETtable fields are aliased with D.fieldname, The MACHINE table fields are aliasedwith M.fieldname. I did not alias the USER table.

 

“SELECT D.SHIP_DATE, M.USER_LOGGED AS Logged_in_User,M.USER_NAME, USER.FULL_NAME, USER.DOMAIN, USER.BUDGET_CODE, M.NAME ASComputer_Name, M.CS_MODEL AS Model, M.CHASSIS_TYPE AS Type, M.LAST_SYNC,M.LAST_INVENTORY

FROM MACHINE M

JOIN DELL_ASSET D ON D.SERVICE_TAG = M.BIOS_SERIAL_NUMBER

JOIN USER on USER.USER_NAME = M.USER_NAME

WHERE”

 

Please know that I am an infrequent Ninja visitor. I may not respond to additional questions quickly ;) There are other serious Ninja users who may be able to assist further. I hope this enough to get you started.

Answered 09/26/2014 by: jmarotto
Second Degree Green Belt

Please log in to comment
Answer this question or Comment on this question for clarity