Scripting Question


08/22/2017 1571 views
I just want to get the information below but i dont know how to create a script in SQL. Please help.

IP address
User Name
User Full Name
System Name
Service Tag
Asset Tag
Chassis Type
Answer Summary:
0 Comments   [ + ] Show comments


Answer Chosen by the Author


Try this.....

To get "Asset tag" info..... I believe you need to create a

"custom inventory rule" for it, as it is not shown by default.

Go to .....

Inventory -- Software......... then "choose action" -- New

Name it...... choose operating system......

in the "custom inventory field" ...... input the command......

ShellCommandTextReturn(cmd /c wmic systemenclosure get SMBIOSAssetTag)

then save it.

It should appear in the report field under "custom fields"

see below

Answered 08/22/2017 by: akmagnum
Red Belt

  • I already done, what next?

    Sir, from the Report under Hardware Category "Computer Inventory Detail" I can see the Asset Tag but the column title from the CSV is Video Controller.
  • I got your point sir. Very helpful. I can see now the progress from the Software and Reports. Thank you.

Community Chosen Answer


Kace has an in built wizard you can use to get all this info.

Just go to "Reports "  tab in the k1000.

Create a new report....... from the "choose action " drop down list, choose "New (Wizard)".

then name it ...., choose a category or create a new category to help you categorize your reports.

Then choose "Device" in the "topic"  dropdown list...... as below

then click next....

on the next page expand all the various different fields and tick the info you need in them .

 Then next.....next.....finish.

Answered 08/22/2017 by: akmagnum
Red Belt

  • Hello! Thank you. But my concern all my Dell desktop was already input the Asset Tag to the BIOS Asset. However I cannot find from the reports the Asset Tag of all Dell desktop.

All Answers

This content is currently hidden from public view.
Reason: Removed by member request For more information, visit our FAQ's.
This website uses cookies. By continuing to use this site and/or clicking the "Accept" button you are providing consent Quest Software and its affiliates do NOT sell the Personal Data you provide to us either when you register on our websites or when you do business with us. For more information about our Privacy Policy and our data protection efforts, please visit GDPR-HQ