How to retain specific device data in assets after device is deleted.
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.
Answers (2)
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
ASSET_DATA_5.FIELD_10121,
MACHINE.BIOS_SERIAL_NUMBER
SET
ASSET_DATA_5.FIELD_10121 = MACHINE.BIOS_SERIAL_NUMBER
MACHINE.BIOS_SERIAL_NUMBER
SET
ASSET_DATA_5.FIELD_10121 = MACHINE.BIOS_SERIAL_NUMBER
Comments:
-
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? - bstutz 9 years ago
-
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 - Hobbsy 9 years ago
-
Thank you for your response. We are not using the Service Desk Ticket feature. - ncaplan 9 years ago
-
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 - Hobbsy 9 years ago
Top Answer
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.