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

Comments

  • Nico_K makes a good point about using MIA. I do that in Inventory.
Please log in to comment

Answers

1
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.
Answered 12/08/2014 by: rockhead44
Tenth Degree Black Belt

Please log in to comment
1

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.

Answered 12/08/2014 by: mikesharp1
Second Degree Black Belt

Please log in to comment
1
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.
Answered 12/09/2014 by: Nico_K
Red Belt

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