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
