I've got several years of user data I want to get rid of. Is it safe to delete (old) records from the User (UDT_User, UDT_UserToIPAddressCurrent, UDT_UserToIPAddressHistory) tables?
I've got several years of user data I want to get rid of. Is it safe to delete (old) records from the User (UDT_User, UDT_UserToIPAddressCurrent, UDT_UserToIPAddressHistory) tables?
Hi John,
changing data retention settings should do the job for you. Once DB maintanence starts, the older than required records will be deleted automatically so there is no need to do this manually.
Pe…
To what I understand the retention settings only applies for port history so I assume we should include another option for user history.
Hi John,
changing data retention settings should do the job for you. Once DB maintanence starts, the older than required records will be deleted automatically so there is no need to do this manually.
Peter
Hi Peter,
That's what I thought, but I had user data well beyond (years) the data retention settings.
I went ahead and deleted the old user records from the UDT_User* tables with database manager.
-john
To what I understand the retention settings only applies for port history so I assume we should include another option for user history.
Has anyone found a way to delete old records? Retention policy does not do it. The software was purchased years ago and no one was managing the rogue devices. I have computer and Users that have not been with the organization for 6 or 7 years that I would like to delete out of DB. Has anyone deleted the UDT completely and reinstalled? Would we need to detached old UDT tables from DB and delete? will this effect any other Orion products? Just to clarify, I do not want to delete the Nodes, just client computers and users. I cannot get SW support to understand that..
Hi saintsjeff do you have a support ticket number?
SolarWinds solutions are rooted in our deep connection to our user base in the THWACK© online community. More than 180,000 members are here to solve problems, share technology and best practices, and directly contribute to our product development process.