Interface Summary Table Ultimate Tweak

A while back, I did a major customization of the Top Least Interfaces Table in NPC.  This is a NetVoyant view that normally shows interface availability and utilization in and out of every interface.  There's no reason, however, that that table can't contain many more metrics.  That's essentially what I did with this customization.

In order to implement this run the following command on the NPC server:
mysql -P 3308 -D netqosportal -e "replace into control_properties (controlid, propertyname, propertyvalue) values (20651,'ColumnNames','avail,Utilization_In,__Deviation_In,Baseline_In,e95th_In,Utilization_Out,__Deviation_Out,Baseline_Out,e95th_Out,Average_Utilization,Errors_In,Discards_Out,p_ifIndex_property_value,p_ifSpeed_in_property_value,p_ifSpeed_out_property_value'),(20651,'ControlType','Interface'),(20651,'data.chartType','Table'),(20651,'DataSetName','ifstats'),(20651,'Description','Originally the \'Top Least Available Interfaces\' view, this view has been highly modified by Stuart Weenig to include other major interface statistics.'),(20651,'DisplayFormats','percent:avail|percent|percent|percent|percent|percent|percent|percent|percent|percent|packetrate|packetrate|string|rate|rate'),(20651,'DisplayNames','Availability,Utilization In,% Deviation In,Baseline In,95th In,Utilization Out,% Deviation Out,Baseline Out,95th Out,Average Utilization,Errors In,Discards Out,Index,Speed In,Speed Out'),(20651,'FieldNames','(ifuptime/ifduration)*100;in_ifutil;(in_ifutil-in_ifutil_bl)/in_ifutil_bl*100;in_ifutil_bl;pct_in_ifutil;out_ifutil;(out_ifutil-out_ifutil_bl)/out_ifutil_bl*100;out_ifutil_bl;pct_out_ifutil;(in_ifutil+out_ifutil)/2;in_errorrate;out_discardrate;p_ifIndex.p'),(20651,'FieldNames2','roperty_value;p_ifSpeed_in.property_value;p_ifSpeed_out.property_value'),(20651,'OrderBy','Average_Utilization DESC'),(20651,'PropertyNames','Description,ifSpeed,ifType,Name,ifIndex,ifDescr,ifName,ifSpeed_in,ifSpeed_out'),(20651,'Title','Interface Utilization Summary');update controls set title='Interface Utilization Summary Table' where id=20651;"

That should do it. Now the default definition for that view should contain all the advanced metrics shown above. The view also has a new title when in the view list: "Interface Utilization Summary". The way you can know it'st he right one is by hovering over the view in the view list and it should pop up a description with my name in it.

This can also be applied directly to the NV view.  You can do it through the wizard, or just run the following command on the NV server:
mysql -P 3308 -D nms2 -e "replace into control_properties (controlid, propertyname, propertyvalue) values (20150,'ColumnNames','avail,Utilization_In,__Deviation_In,Baseline_In,e95th_In,Utilization_Out,__Deviation_Out,Baseline_Out,e95th_Out,Average_Utilization,Errors_In,Discards_Out,p_ifIndex_property_value,p_ifSpeed_in_property_value,p_ifSpeed_out_property_value'),(20150,'ControlType','Interface'),(20150,'data.chartType','Table'),(20150,'DataSetName','ifstats'),(20150,'Description','Originally the \'Top Least Available Interfaces\' view, this view has been highly modified by Stuart Weenig to include other major interface statistics.'),(20150,'DisplayFormats','percent:avail|percent|percent|percent|percent|percent|percent|percent|percent|percent|packetrate|packetrate|string|rate|rate'),(20150,'DisplayNames','Availability,Utilization In,% Deviation In,Baseline In,95th In,Utilization Out,% Deviation Out,Baseline Out,95th Out,Average Utilization,Errors In,Discards Out,Index,Speed In,Speed Out'),(20150,'FieldNames','(ifuptime/ifduration)*100;in_ifutil;(in_ifutil-in_ifutil_bl)/in_ifutil_bl*100;in_ifutil_bl;pct_in_ifutil;out_ifutil;(out_ifutil-out_ifutil_bl)/out_ifutil_bl*100;out_ifutil_bl;pct_out_ifutil;(in_ifutil+out_ifutil)/2;in_errorrate;out_discardrate;p_ifIndex.p'),(20150,'FieldNames2','roperty_value;p_ifSpeed_in.property_value;p_ifSpeed_out.property_value'),(20150,'OrderBy','Average_Utilization DESC'),(20150,'PropertyNames','Description,ifSpeed,ifType,Name,ifIndex,ifDescr,ifName,ifSpeed_in,ifSpeed_out'),(20150,'Title','Interface Utilization Summary');update controls set title='Interface Utilization Summary Table' where id=20150;"