Add Overall Percentage to Availability Report?

travispbonfigli

Hello All!

 

We are trying to prepare a report that will show all our Cisco networking devices (component name, ip address, and the availability percentage) and we have that down and working.  However, we are wondering if there is a way to have the average of all the percentages shown at the bottom of the report (so we don't have to do it manually each week - ugh!).  We are using the latest and greatest of NCM and working in Report Writer.  Any help would be GREATLY appreciated!  Thank you!

 

Cheers,

Travis

wbrown

I don't know about adding an overall availability percentage to a detailed report, but for NPM I did an overall availability average for my wireless networks by modifying a copy of a detailed availability report and unselecting the fields (vendor, device name, etc) that I didn't care about.

In the end, the only fields left in my select statement are SummaryDate, City, and AVERAGE_of_Avg_Availability.  I'm using the City field for each of my buildings.  This results in having an availability report for each building.