How can we clean up stale users on our K1000?
I'm hoping someone has a SQL statement to find stale user accounts in Kace.
Kace keeps the AD import time stamp and the last modified time stamp for the user's in the Kace DB, but I haven't figured out what the SQL code should look like to find them.
I'd like to start with finding users that have a last modified date greater than 3 months ago. If I can build a label or report to find them, I can manually delete them. But if there's also a method to include in the statement that would auto delete them after 3 months, that's great also.
We do not use the Service Desk module. I'd like to, but we're part of a large tiered orginization and we use at our tier while other tiers do not. The top tier provides their own ticketing system. That said, we don't and will never need to keep user accounts in Kace in order to reference old tickets.