patriot ✭✭✭✭✭

So, is it as simple as replacing every mention of "AlertObjects" with "AlertActive" in the query?

Thanks Kevin and Brandon. The last sentence confuses me a little bit. Did you mean to say that the exclusions can be removed after troubleshooting is completed? That would jive with your first sentence.

Anyone???

Very interesting idea, but may I interject a question as to how this might work from a timing standpoint? Obviously, one would need for the custom property value to have been changed in time for the alert B and C exclusion to work properly. How would that be accomplished?

I assume that I would need to use the Add License button in order to add the SRM license key?

For example, the "API Pollers: When SNMP WOn't Cut it" video does not tell me how to obtain the URL to poll for Orion polling engine stats.

I would suggest contacting support because when I test this, I see that unmanaged time periods are indeed left off the report:

Perhaps I should have said that the HCO is a clean install, not an upgrade of Orion Platform. So, would I use the Orion installer to install SRM and then apply the SRM license key?

If I am not mistaken, the whole point of having the ability to unmanage nodes is so that those time periods will not be included as down time in reports. Unmute has no effect since the nodes are still being polled - just not alerted on. What makes you think that the unmanaged time periods are being included in your…

So, if HCO has been installed what should be done with the SRM module? Is there some sort of "integration" there too, or is that functionality totally lost? Try to find custom pollers in NPM as a workaround?

Thanks for the prompt answer jeff.stewart. I had forgotten about WPM and SRM. To your knowledge is SolarWinds working on incorporating those two modules in a future version of HCO?

Anyone please? Or is the question too stupid? :)

Anyone, please?

Anyone have any input? I have looked at both the Core Network Topology and the NPM Network Topology widgets, but I am not completely sure I know what those resources are showing. Does the Core Network Topology widget show the information I want? Does it show the connection for any node regardless of polling method and…

Appreciate the explanation sum_giais. How ever this query results in the Node Down and Node Up timestamps being exactly the same.

Not following. I don;t have both of the above Where statements in the same query if that is what you think I mean. I'm saying that the "-1" does not return events from the previous day, week, month, etc. that definitely occurred. So, what am I doing wrong? Can you give an example of the exact syntax that would return…

Additional notes: 1. Using ADDDAY set to -1 yields no events, but using ADDWEEK set to 1 (current week) shows events for the last 2 days. What gives? AND (StartTime.EventTime BETWEEN DATETRUNC('day', GETDATE()) AND DATETRUNC('day', ADDDAY(-1, GETDATE()))) vs AND (StartTime.EventTime BETWEEN DATETRUNC('week', GETDATE()) AND…

Well, I must be doing something very wrong, because: 1. If I insert the "ToLocal" in the first line of the query, I get no errors, but the times in the report are still in UTC 2. If I use "-1" in the WHERE statement I get no events in the report, which is incorrect because I manually created several down/up events…

Thank you. Is that the only place in my original query that needs the ToLocal command? Do I also need it in the AND statement 4 lines from the bottom? Also, can you help me with the syntax for Yesterday, Last Week and Last Month?

Thanks for the ideas folks, but I am still struggling to explain why the timestamps are displaying in UTC time. I've proven that by manually taking a node down and back up. The events show up on UTC time rather than CST even though the GETDATE is used in the query. Need to fix this. Also, need this report to be YESTERDAY,…

Gotcha. So, any thoughts as to why the query above results in UTC timestamps?

Interesting given that the report you see above is currently generating UTC timestamps. Any idea why?

Your contributions are always appreciated and valuable. I just don't have the depth of knowledge yet about SWQL to be able edit to fit my needs. Hence all the bothersome questions.

I knew you were going to say that! While I am in here - a feature request please - create some node downtime reports similar to the OOTB interface downtime reports.

Thanks for the reply wluther, but when I re-examined the following query I'm not sure now why I need the ToLocal after all. My understanding is that GETDATE should be returning the local time anyway (I verified that the Orion server is set to the local time zone). Anyway, in the following query I actually have two…

Sorry, need daily, weekly and calendar month.

Anyone? Also need 7 day, last month and last 3 months versions of this report. The idea is to show the duration of each outage for a customer's devices for those 3 time frames. Sorry to be such a bother, but this is definitely not a strength of mince and I need to get better. Thanks for all of your help.

Also, if I change the two lines with MONTHDIFF to try and get the last 7 days, I get data for the month of June. Weird. SELECT DATETRUNC('day', Nodes.ResponseTimeHistory.DATETIME) AS [SummaryWeek] , Nodes.NodeID , Nodes.CustomProperties.CustomerName , Nodes.Caption AS [NodeName] , Nodes.IP_Address ,…

Made the change in both MONTHDIFF locations and the report still shows data for the last 3 months. What am I missing?

I know this thread is about a year old, but where do things stand on this?