KACE Product Support

Hi there. I have noticed that when we re-image machines sometimes the K1 will recognize them as the same machine and everything is fine, but sometimes it creates a new inventory entry for the computer, ie. we will have two entries for LA019 (the active one and the one that has not checked in since before re-imaging). I was wondering if anyone had a handy SQL query to check for multiple instances of the same computer name. I can then use this to cleanup and free-up some licenses.

Thanks,

-DHF