Volume Utilization with Forecast Capacity

I also encountered this problem......

Hi, just found this and like the look of it. I have run it SWQL Studio and it does output all the data but I notice about a third of the nodes for Warning, Critical and At Capacity columns have the value 'Not Calculated '. Looking at the nodes I see they have well over 12 months of historic data.
I had half an idea what the problem was so consulted chat gpt

The output 'Not Calculated' is generated when certain fields in the orion.forecastcapacity table are NULL. Specifically, in the CASE statements for calculating warnings, critical alerts, and days until capacity, the conditions check for NULL values. If the values for DaysToWarningAvg, DaysToCriticalAvg, or DaysToCapacityAvg are NULL, the corresponding CASE statement will output 'Not Calculated'.

For example, in the following portion of the code:

If the DaysToWarningAvg column in the orion.forecastcapacity table contains NULL values for certain records, the CASE statement will result in 'Not Calculated' being output for those records. This indicates that the warning days could not be calculated due to missing data or other reasons.

Anyone else get this or know how I can get the data populated?

i tried to change from Volume to CPU load and memory result was empty, can you show me how to get capacity forecast for CPU and Memory, thanks 

This is Great gives me a super view of the capacity for volumes... Now to have a look at Processor and Memory Capacities... Thanks again