rgoldberg

Yeah that's what I meant - the docs exist internally for your devs ( I would think?), and I was hoping to get a glimpse. But - what you are saying is totally rational and sensible, I appreciate the response. Anyhow, as regards my orig question, you have to return only "NetworkNodeID" and "Name" - I was also returning…

Thanks for the response. Good to know there's work on that front. However, in the meantime, a little docu on the interaction between the software and the table(s) would be fantastic. I'm certain I'll get this working, but I feel a little silly hillbilly-reverse-engineering this thing when I know the docs exist, and that…

I see the last execute time is blah blah year 1900, so, it's obviously never run. Here's the full row: F374C8A6-405A-4877-B36C-82CC148FB4BF xxxxx - HQ to Portland xxxxx - Tunnels from HQ to Portlan 1 1899-12-30 00:00:00.000 1899-12-30 23:59:59.000 1,2,3,4,5,6,7 SELECT Nodes.Caption as Name,Interfaces.NodeID as…

Version 9.1.0. Yes, I have the admin guide open, I'm looking at pages 123-129. As I mentioned above "I can configure alerts in the gui no problem" and I want to "define alerts the gui cannot define." I think other people do too... Ryan

that's actually the reset query - the alert query had "count(*) <= 1"

I'm trying to do similar - each site has 4 tunnels back to HQ, I want alerts to go out if they are down to 1 (or 0) tunnels. Here's the query I'm using: SELECT Nodes.Caption as Name,Interfaces.NodeID as NetObjectID,count(*) FROM Interfaces inner join Nodes on (Interfaces.NodeId=Nodes.NodeId) WHERE (InterfaceID=89 or…

I have a meeting in 2 minutes where I have to explain what's up with these alerts...

Yes, I can configure alerts in the gui no problem. But, the post I referenced shows how to run your own query to define alerts that the gui cannot define. This particular example deals with using count(), but the implication wouldbe that a person could define any alert condition they wanted, provided they could come up…

Yeah, I had looked around the posts little bit and that was the only thing I found suggesting I'd be able to do what I want. Simple queries that do what I want are easy, but would require one advanced alert per tunnel group I want to monitor. I think my only way to make things more generic is to have strict interface…