Cireson WebPortal Database Table [Access_CI$User_ConfigurationItem] using too much hard drive space
I was tempted to put this particular question under the Portal section, however this deals with permissions on config items and that means it's using Asset Management Items as well.
Today in SSMS, I saw an enormous amount of memory being used by the Cireson Database: ServiceManagement
I am aware that it reserved/allocated a huge amount of free space compared to actual used space which can be defragmented down with the following SQL command:
ALTER TABLE [ServiceManagement].[dbo].[Access_CI$User_ConfigurationItem] REBUILD;
However that's not my concern, my concern is the fact it is storing such a large amount of CI and User GUIDs. Is there a way to limit this, be it by config items or otherwise? Is there a way to dynamically force the portal to calculate these permissions?