2 Replies Latest reply on Feb 19, 2009 4:24 PM by ttitech

    UnDP Transform function required for Avaya IP Trunk utilization


      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: