UnDP Transform function required for Avaya IP Trunk utilization

Question

I'm polling our Avaya 8700 for IP Trunk utilization and get the following info in UnDP:

Using the Report Writer, I have converted this to Percent Utilization with the following query:

Select DateTime, Count(CustomPollerStatistics_Detail.RowID)*100/1250 AS Percent_Active_IP_Trunks
From CustomPollerStatistics_Detail
Where Status = 'in-service/active'
Group BY DateTime
ORDER BY DateTime

I get a display like this (which I want to graph):

What I need is a transform function that can count the number of lines with the status "in-service/active" and display this number as a percentage in a graph like this:

ttitech · Answer

Dear Mr. Guru,

We would be honored if you could help us with monitoring our Avaya devices with Solarwinds. Any help would be appreciated.

Regards,

Arnie

bshopp · Answer

I don't believe we support this scenario at this time, great use case though and added internally here for tracking.