KACE Product Support Question
Asset database got corrupted, how to fix data?
01/11/2017 1041 views
Our asset database got corrupted. The issue has since been fixed, but there are entries that have incorrect data. We mainly use it to track user laptops, which we assign a company asset tag to (e.g. 103465). Each asset entry also contains the Dell service tag, user, and some other information. However, after the corruption happened, there are some entries that have different company asset tags, but the same Dell service tag. Likewise, there are some entries with different Dell service tags, but the same asset tag. Also, some of the assets have the incorrect user assigned.
How can we fix this? Can I semi-automate or automate an audit of the Kace data and make sure it matches what users physically have? I would want to know the user, the asset tag and the Dell service tag. (We also have some Mac users, but they are so few that I would be willing to manually audit these entries.)
In the past, someone did a mail merge using an Access database to send out emails to users and track responses, but I'm not an Access expert, and we have Kace, so I'm hoping there's a solution here. Thanks!