I am setting up some trending. We currently collect stats on the largest tables and load them into Splunk. I am able to retrieve the 10 largest tables with the following search:
sort - data_object_p_size | head 10 | eval TableName= tabschema."-". tabname | table TableName, data_object_p_size
I would like to use the results from the search to include the table size over the last 90 days so I can gather the trend. Basically, I would like something like:
TableName, Current Size, Size 30 days ago, Size 60 days ago, Size 90 days ago, Monthly growth
Could someone point me in the direction of where to get started? Any help is greatly appreciated.
... View more