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

Question

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:

Accepted 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-computersIt 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” label3.    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.

Answer

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.

Systems Management Question