Control what your users can access and save time, money, and frustrations. Lock down sensitive data in SugarCRM or SuiteCRM to specific groups or teams. Supports unlimited assigned users, unlimited group assignments to records, custom layouts for each group, login/sudo capabilities and much more.
#1131 - Table securitygroups_records 20M records 11GB!!!
Hi Jason,
I have installed SecurityGroups feature limited version 2.7.4 and I have noticed that the table securitygroups_records has growth to 20 million records and 11GB size, this is too much!!!
What steps can I take to reduce the size of this table?
I have configured 4 security groups with languages and users within these languages for assigning tasks and records based on the language of my CRM users. I have the default configuration on, I don't know where to start slimming down this table...
Can you help? Thanks!
-
"Quite powerful, flexible and easy to use plugin. Works perfectly in SuiteCRM as well as in SugarCRM." - damien8105
Read More Reviews
- Most Recent Love from Users
kacsoristvan- damien8105
- anri
- Administrador
- Stefano1
- einkauf2
9 years ago
Hello Jose,
Check out this support case for guidance on how to address this:
https://www.sugaroutfitters.com/support/securitysuite/496
Also delete anything in the securitygroups_records table that is related to SchedulersJobs. Make sure to backup the database before doing anything.
9 years ago
Hi Jason, thanks for quick response.
I have deleted some records from the DB, everything inside securitygroups_records for the modules SchedulerJobs and ProcessAudits and some records from AOW_processed.
My question now is how I control so securitygroups doesn't create a record for each processaudit and schedulerJobs? I thought about creating a workflow that cleans regularly these records but it seems that processaudit is not available as record in AOW.
Is there a configuration so securitygroups ignores these records?
Thanks.
Jose.
9 years ago
Hi Jose,
Sorry, I thought I replied to this, but I guess the day's events just pulled me away. Within modules/SecurityGroups/SecurityGroups.php in the getSecurityModules() function (around line 536 depending on your version) there is a $module_blacklist array. If there isn't, please upgrade to the latest SugarCRM and install the matching SecuritySuite version or if you are up to it then download the latest SecuritySuite code here and compare and migrate the code for your version. Just add the Process Audits and AOW_processed modules to that array so that they do not get added.
SchedulersJobs records shouldn't show in securitygroups_records anymore since it is in this new module_blacklist array. If they still are then you may be on a version that doesn't have this new change anymore.
Hope that helps! -Jason