0 Replies Latest reply on Apr 23, 2014 8:41 AM by djobrien

    Custom Chart Permissions

    djobrien

      I have a created two custom charts to monitor transmit and receive on critical fiber interfaces. These charts are populated by the SQL below. I am able to see the data correctly but individuals without admin rights receive a "No Data Available" message. Also note that there are no account restrictions on this view. I am running NPM 10.7 and SAM 6.0.2. Help!

       

      Select CE_Interface_Alias, (In_Averagebps / InterfaceSpeed) * 100 AS "Percent Utilization Rx", (Out_Averagebps / InterfaceSpeed) * 100 AS "Percent Utilization Tx",  Stats.DateTime

      From dbo.Interfaces I, dbo.InterfaceTraffic_Detail Stats

      Where I.InterfaceID = Stats.InterfaceID AND CE_Interface_Alias IS NOT NULL AND Stats.DateTime >= DATEADD(day, -1, GETDATE())

      ORDER BY DateTime Desc

       

       

       

      ViewPermissions.png