removing old user data

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? 

Support Ticket #00874672.  I even tried deleting application (UDT) hoping that it would delete data or remove SQL UDT tables from DB.  that did no work.