Script gathers details of history log size by field
Change variables as necessary
@minMBSizeToShow INT = 100 --Minimum size of tracked field history to display in results (default 100)
@CalculateRefContentInformation BIT = 0 --Setting to 1 calculates additional information related to reference content to help understand data distribution (default 0)
@CalculateRefContentSizeLimitMB INT = 1000 --When @CalculateRefContentInformation enabled limits to fields with history log larger than provided value in MB (default 1000)
@ForceRebuildAllTables BIT = 0 --Setting to 1 forces rebuilding work tables, leave at 0 so you can modify last query to allow filter, analysis etc. (default 0)
|Table Name||Rows||Size MB|
Example execution for tables sizes above
History base query takes about 6 minutes to run
Enabling @CalculateRefContentInformation adds about 3 minutes
The work tables are not always repopulated to allow re-running the last statement with modified filters.
If you want to force repopulation change the @ForceRebuildAllTables option to 1
This is not an officially RSA supported script.
It is provided as is.
Suitable precautions should be taken for your environment such as, but not limited to, backing up any related data
20190116 Initial Release
20200611 Added @minMBSizeToShow, formatted numbers, added module, level and field ids
20210503 Added max action date, tracking field and type
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.