haydanb

Hey orionfan, Working with my DBA, we modified the report in my original post to use a custom field called WANCircuits which in my case is a simple no/yes (0/1) field. The code is below; look at the WHERE statement. You can see that it will include only interfaces where the WANCircuit = 1. If your custom field WAN_ID is a…

Downloaded the online installer... and it works fine.

I created a group that has all the WAN circuit interfaces. Where can the group be defined in the report? I'm using NPM 11.01 and the 95th Percentile Traffic Rate report is a historical report and can only be edited within the Orion Report Writer. I saw this post, but looks like its for Nodes | SQL or VIEW to select…

Just downloaded the latest offline installer (1.3.1.493) and still getting this error. Any ideas? This is a fresh install.

My DBA's figured it out... here is the correct code. ===================================== SET NOCOUNT OFF SET ROWCOUNT 0 DECLARE @StartDate DateTime DECLARE @EndDate DateTime SET @StartDate = DATEADD(d, DATEDIFF(d, 0, DATEADD(m, -1, DATEADD(d, 1 - day(getdate()), getdate()))), 0) SET @EndDate = DATEADD(ms, -2,DATEADD(d,…