Best practices for removing devices from inventory?
I'm trying to find a "best practices" list on how to remove devices entirely from the K1000. Does anyone know if there is something listed somewhere on this or the Kace site? I haven't been able to locate anything.
My process previously has been to just delete it from the Inventory-Devices page. However, I now realize this is not good, because it still leaves a record in the Asset Inventory. So, now my process has been to delete it in two places... Once from Devices, and again from Assets. This seems redundant, especially when doing it in mass quantities. And, even if I do have to do it this way, I want to make sure there's no other lingering places that have records of the devices.
So... What's your process? Thanks for any tips you can give.
1 Comment
[ + ] Show comment
-
Nico_K makes a good point about using MIA. I do that in Inventory. - rockhead44 10 years ago
Answers (3)
Please log in to answer
Posted by:
rockhead44
10 years ago
Here's what I do to resolve the computer Asset issue:
I created a custom ticket rule by going to Service Desk--> Configuration--> Queues
I created a rule that runs once per week and deletes any computer assets with no associated machine Inventory
My query is:
SELECT ASSET.ID
FROM ASSET
LEFT JOIN MACHINE ON ASSET.MAPPED_ID=MACHINE.ID
WHERE
ASSET_TYPE_ID=5
and MACHINE.ID IS NULL
**NOTE*** Yours may be different; You'll want to test and verify the ASSET_TYPE_ID from your database
Then, I run the following Update Query:
DELETE FROM ASSET WHERE (ASSET.ID in (<TICKET_IDS>))
and then get an e-mail that shows me what was deleted
Works beautifully for me and solved a huge problem. Good luck.
Posted by:
mikesharp1
10 years ago
I would recommend to export the assets before you delete them that way you have a record of the asset just in case (cya). But I don't remove the asset unless its retired and purged from all inventory systems.
You can do a export of the entire asset table to excel and filter those has needed.
Best of luck.
Posted by:
Nico_K
10 years ago
I simply use the MIA Settings (Inventory->Choose Action->MIA
Then the devices are deleted regulary if they don't show up for a longer time.
Since I use also agentless inventory also manual devices are no more needed.
