Scripting Question

how to update asset value from script

02/22/2019 510 views


I need to update a field in asset from the computers. So, my plan is to create a script, run a VB or powershell to update the field in asset. 

Please let me know what you think or if you have any ideas. 

let me explain. I have a software installed on about 1000 computers. The software keeps it's license/account number in a text file on the local computer hdd. 

I need to read the content of this text file  and update it's asset field on kace. or just create a report from it. 



Answer Summary:
0 Comments   [ + ] Show comments


Answer Chosen by the Author


What you can do is create a Custom Inventory Rule usingShellCommandTextReturn(cmd /c type c:\TEMP\testfile.txt) < Replacethe part in bold with your path & file name. This will then display the content of the text file in your inventory

You could then create a ticket rule which copies the value from your CustomInventory Rule data location to the Asset Field data location required

You can find your custom inventory fields in the MACHINE_CUSTOM_INVENTORY Table

And you can then copy STR_FIELD_VALUE to your Asset Type Field as required.

Just be aware each time you create an Asset Type you will need to find the unique field within the asset data table

Answered 02/25/2019 by: Hobbsy
Red Belt

  • I am not sure where to begin with. First of all thanks for above help. however I don't know how to do many things from what mentioned above. Like how to create inventory rule and shellcommandtextreturn, or how to create ticket rules.

    thanks anyway. I see this task is above my IQ
    • This content is currently hidden from public view.
      Reason: Removed by member request For more information, visit our FAQ's.
    • Jencam, we are always happy to setup a call and talk you through the basics, as well as get you started, just reach out if when you are ready to make a start

Don't be a Stranger!

Sign up today to participate, stay informed, earn points and establish a reputation for yourself!

Sign up! or login

View more:


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