Heads up to anyone who recently upgraded to ITMS 8.6 or plans to. About a month after upgrading we started have disk space issues on our SQL server and narrowed it down to one table that had been growing since the upgrade. The Inv_Security_Groups table had grown to 110 million rows. Further analysis showed that each time a user import rule ran which is based on specified groups, all the groups for all the users who were a member of one of the specified groups would be added to this table. Then each time it runs, they are appended to the table with no apparent cleanup happening for the duplicates.
I have a case opened with Broadcom and they have been able to duplicate the symptom. I've been able to workaround the problem by periodically truncating this table.
------------------------------
Joe
------------------------------