/bundles/itninjaweb/img/Breadcrumb_cap_w.png

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

  • ncaplan
    Senior White Belt
  • How helpful is this to you?
  • Average Rating 0
  • 1763 views
  • 06/23/2015

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:
Cancel
0 Comments   [ - ] Hide Comments

Comments

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

Answer Chosen by the Author

Answers

1

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

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

Answers

1
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:

Select
Select
  ASSET_DATA_5.FIELD_10121,
  MACHINE.BIOS_SERIAL_NUMBER
From
  ASSET Inner Join
  MACHINE On MACHINE.ID = ASSET.MAPPED_ID Inner Join
  ASSET_DATA_5 On ASSET.ASSET_DATA_ID = ASSET_DATA_5.ID

Update
UPDATE 
ASSET_DATA_5.FIELD_10121, 
MACHINE.BIOS_SERIAL_NUMBER
SET 
ASSET_DATA_5.FIELD_10121 = MACHINE.BIOS_SERIAL_NUMBER

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
Please log in to comment