magicjuanhunglo

Orion is already pulling the cpu and memory values for the individual switches (as you can see if you view the stack details on a Node).... I don't see why I would need to pull this info again via a (UnDP) and double the space in the database... then go through the process of building an alert on the custom poller. I just…

Appreciate it.. i actually do have a work around to get the data into an alert.... by using a custom sql alert to pull the data (which is in different sql tables, of course).... Custom SQL alerts are pretty limited due to the Select From being pre-populated...., but it does the job). Just requesting the feature as I felt…

For your Alert, in the Trigger Condition, use "Custom SQL Alert": For Memory the SQL is: JOIN [dbo].[MemoryMultiLoad_Current] c ON Nodes.NodeID = c.NodeID JOIN [dbo].[NPM_SwitchStackMember] ss ON Nodes.NodeID = ss.NodeID WHERE c.AvgPercentMemoryUsed > '80' We set it to greater than 80%...and that looks at each individual…

Yep, that would be a good option... but Unfortunately, not all the instances we co-mange are sending Traps or Syslog to Orion... possibly in the future. And I have no issue using UnDPs or Traps/Syslog to build out the alerts... Just think that this is a feature that should be included out of the box... Orion is already…

Awesome.. that did it... Thank you so much for all your help. Really appreciate it.

So, as the join seems to work fine, but when i add the column name to the select (in this case its int.FullName), the query fails... not sure what im doing wrong. : SELECT distinct i.interfaceid, int.FullName , min(tolocal(i.DateTime)) as [Earliest Timestamp] , sum(i.InTotalBytes) as [InBytesTotal] , sum(i.OutTotalBytes)…

Ahhh... too bad. Ok. Well thanks anyways.

Awesome!! Thanks so much for your help. One more quick thing... for the report... what would i need to do if i wanted to join another table like ("Interfaces"... for example) so I could add additional data to the report.... Like adding Interfaces.FullName or some specific Interface Custom Properties?

I know this is old, but did you figure it out?

Thanks so much.. .I will test this out. I really appreciate your help.

Awesome... this seems to have done the trick. My SQL is "ehh" and my SWQL is worse... so this was just what I needed. Quick question... if i wanted to just run this query normally (say via a custom SWQL report), and show the values for In Total Bytes and Out Total Bytes, and the combined In+Out, so i could verify what…

Thanks, but that is different from what I'm asking.... For Example, I have a single table poller returning 75 Values per device. I want to create a chart on the node details page to view these values over time (vsys utilization every 5 min over the last 24 hours.. for example)... and the only way i see to currently do that…

That's awesome.. thank you. I know a little SQL ad even less SWQL. How would I change this up to show Alerts that have been acknowledged. So I would use your recommendation above for how many alerts were triggered per hour for my first chart... then on my second chart, I would want to show how many alerts were acknowledged…

That makes sense.... thanks for you input. I really appreciate it. 

The InterfaceTrafficByDays holds the daily total for the interface... so yea, i would need the add up the days to determine if the interface went over 25Mb of usage. There is one value per day in the table... so the query would only have to add up 31 values (days) at the most per Column in the table (2 columns,…