Systems Management Question
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.
Comments
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.
All Answers
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
Reason: Removed by member request For more information, visit our FAQ's.