Hello!

I've raised the issue of tracking deleted assets with Dell Kace support and they have noted it for future enhancement if enough people request it. But it wont be added to the Kbox's functionality at the moment which leaves me in a position needing to think of alternative ways to acheive the same.

Essentially I need to be able to keep track of Assets that are deleted for auditing purposes, somehow. At the moment, an asset has its own 'history', when it was created, changes made to its name or other attributes etc. But when the asset is deleted from the Kbox, thats it, its gone!

The fear is a few assets could be deleted maliciously or accidentally and over time the list of assets would become increasingly inaccurate. This would be our main day-to-day asset tracking system and whilst there would be a paper trail of purchase orders and invoices for hardware, if for example a laptop was deleted from the Kbox and stolen we wouldn't necessarily know.

I've been thinking and it would be easy to create a custom Helpdesk rule that regularly emails a list of all the Assets. Then some other mechanism would need to read the email, perform the comparison of lists and trigger alerts to warn us.

Ideally this would be peformed within the Kbox though. e.g. everytime an asset is deleted a note is recorded within a new table, that we could then lookup. Or an email is sent when an asset is deleted.

This is my problem. Any help or suggestions would be greatly appreciated! My IT Director is refusing to let us change over to the Kbox as our primary asset tracking system until this problem is addressed. [:(]
0 Comments   [ + ] Show Comments

Comments

Please log in to comment

Rating comments in this legacy AppDeploy message board thread won't reorder them,
so that the conversation will remain readable.

Answers

0
You could schedule a report as an email. You could have a VMWare standby (this is an option you can purchase via sales) and if a delete happens by accident you could bring up your backup (make sure you isolate the virtual network) and export it off of the VM.

And of course, you are taking daily backups
Answered 10/01/2010 by: GillySpy
Seventh Degree Black Belt

Please log in to comment
0
Thanks Gilly

Yep we backup the Kbox every night. Your idea would be good for restoring accidentally deleted assets but it doesn't address the problem of how to tell if an asset has been deleted. Unless I have completely misunderstood your post? A scheduled report (as an email) identifying deleted assets would be perfect!
Answered 10/01/2010 by: stubox
Blue Belt

Please log in to comment
0
There would be no way of knowing that for sure. Very kludgy but the ASSET.ID column is sequential so you could keep track of the number of gaps. An increase in the ID should match the number of new assets. Any discrepancy means that assets were deleted.

e.g
Day 1: 1,2,3,5
Day 2: 1,3,5,6,7,9

on Day 1 you knew what you had. On Day the number went up by 4 but the count only went up by 2 which means 2 were deleted. Item #2 would be in the backup. Item #8 was created and deleted the same day so is lost.
Answered 10/01/2010 by: GillySpy
Seventh Degree Black Belt

Please log in to comment
0
Good idea Gilly, we may fall back on this if my app doesnt work.

At the moment I'm working on a VB.net app that reads the Asset table for a list of Asset ID numbers, takes the Asset_Type_ID to find the associated details from the Asset_Data_x table and stores it all in a CSV. Then on subsequent runs compares the live Asset table with the CSV to find missing assets, and if it does it emails the Asset_Data_x to an administrator. Pretty simple VB stuff really.

If/when its working I'll post again.

N.B. Asset_Data_x - the x is the table number, e.g. Asset_Data_19 in our Kbox DB holds the name and type of thin client devices.
Answered 10/11/2010 by: stubox
Blue Belt

Please log in to comment
0

Anyone come up with a solution for this?

So far, the "best" solution I can think of is to do this offline by comparing daily database backups.  Ugh!

 

Answered 04/23/2012 by: serkowski
Senior Yellow Belt

Please log in to comment
0

You can find this in Settings -> History -> Asset History Listing.  Do an Advance Search and there's a dropdown box for Change Type and Deletion is one of the options (we're on inversion 5.4.7684).

Answered 11/05/2013 by: ptandoc
Senior Yellow Belt

Please log in to comment
0

You could create a whole new asset_DATA_table and make it the historical table?  Set it up so anything placed in another ASSET_DATA_## also creates in the ASSET_DATA_##History but does not delete from that backup asset_data.  Granted your doubling the amount of information you have but you can have 1 active and 1 that stay historically the same (or collects data actively, but does not remove)

Answered 11/08/2013 by: Wildwolfay
Red Belt

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