Systems Management Question

How to retain specific device data in assets after device is deleted.

06/23/2015 2551 views

I want to keep some of the data that is shown for a device in the asset for that item but I'm not sure how to get the fields I want retained into the asset type.

I tried adding the fields in the Device Asset Type by selecting Device Field in the dropdown but that didn't work.

Answer Summary:
0 Comments   [ + ] Show comments


  • This content is currently hidden from public view.
    Reason: Removed by member request For more information, visit our FAQ's.

Answer Chosen by the Author


This was sent to me as a solution from KACE. It took a bit of work to get the desired fields, but it works great. I created a Smart Label to automatically tag the devices that match my criteria and set the report to run on a schedule and email me the csv file. Now, if we could save the import steps, that would be even better; automate the whole process > run report, import to asset , and delete from devices > then I'm a really happy customer.

First thing, go vote forthe request: http://kace.uservoice.com/forums/82699-k1000/suggestions/1807341-retire-computers

It is something thatthey are working on. 


Second, a way tomanually do this would be to:

1.    Make a label ofthe computers that you want to Retire (e.g., "To Be Retired”)

2.    Run a report thatincludes the fields that you want to retain and only include devices in the “ToBe Retired” label

3.    Create a new Asset Typefor “Retired Computers” and create fields for the data you wish to retain.

4.    Import the report thatonly contains the fields you want for the devices that you want to retire.

Answered 06/24/2015 by: ncaplan
Senior White Belt

All Answers

You will need to create the fields within your Device Asset type and then create a Service Desk ticket rule to copy over the data from Inventory to Asset on a schedule. This can be done using the following as an example:

  ASSET Inner Join


Note that you will need to identify the DB value for the fields you create in your Asset, so that the SQL can be updated with the data.
Answered 06/24/2015 by: Hobbsy
Red Belt

  • how can you tell what the field is. in your example you have field_101021. if i am in the adminui all i see is the ID for the asset type. is there a way to drill down to this using mysql workbench?
    • Yes indeed, if in the database you go to the ASSET_DATA_5 table you will be able to see all of the custom fields that you have created, put a value in a test asset and view which custom field is which
  • Thank you for your response. We are not using the Service Desk Ticket feature.
    • You do not need to use the Service desk, however you can use the Service Desk ticket rules to copy the data you need from the Inventory tables to the Asset tables. You will note that in the SQL code posted above there is no reference to the HD_TICKET tables, only ASSET and MACHINE
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