slidermike

Thank you nj, I have verified what you stated as true. I do have various stats collected for longer duration but the "detailed statistics retention" is set for 7 days. As a side note, if I remove the "last month" filter & get results again, do you have a way to show the date of each occurrence as part of the results…

njoylif, good morning & thank you for your continued efforts. I changed the time line as you instructed. While the "error" has gone away, I no longer get any hits/results. I have lowered the 100]>89 to 100]>10 and still no hits. I know that the interfaces in question surely have usage hits of over 10% bandwidth utilization…

I get this error when I copy/paste it.

njoy, since you have been willing to assist (and I am a newb at sql) I would like to show you how I have modified what you originally posted (pre-date modifications). What I am posting here works but again without date ranges it is probably reaching 60+ days into the db. Would you be kind enough to show me how you might…

njoylif, thanks again for your efforts. Now I am off to figure out where to put the date/time code you graciously added at the bottom as a note. I appreciate your efforts! Mike

Thank you for the quick response njoylif. For those of us who data retention longer than 7 days & yet are sql challenged, would you mind giving an example of what the command would look like to force the date to be the "previous month" (not last 30 days but rather the last calendar month)? I think I can use almost…

I like the 5 minute threshold for triggering but I do have 2 questions. #1 How are you setting the time/date? #2 How are you telling the report to only return hits that exceed the given threshold for 5 minutes or more?

I do not have SAM so if that is required then it wont work. I have NCM NPM NTA VNQM

tdanner, thank you for responding. I do not know which application the SAM is so I would assume it is not one of the Applications we own currently. As for the query, I used the thread creators query attached to the thread itself. It says it is version 3.…

This looks very powerful. I have a couple of questions. I took the text supplied; copy/pasted it into a new "Custom Query" resource on a test page. When I apply it & the page refreshes I get this error. "Error: A query to the SolarWinds Information Service failed." Do I need something not supplied in SW or by my sql? My…

This is pretty cool, thank you for sharing. Do you mind answering a couple of questions? I am in the U.S., here we prefer Ferenheit to Celcus. Is there a simple way to translate the email returned value to F? In the trigger conditions, you set call the OUI which I followed but I am stumped by what the 2nd portion would be.…

Try reading through this thread. Especially the part where I got involved & started asking questions that contracer was excellent at answering. http://thwack.solarwinds.com/message/193028#193028

The same here. I ran installed it, double & triple checked everything. Several values are in the negative range. It would be nice if someone has figured out the issue that they would share the fix (if there is one).

Iclemmons, Any change you would share the portion of your report (SQL) for the time function? I am looking for that type of report but instead of ping loss I am looking for exceeding ping response of 499ms. I have everything correct in mine except for the "previous 48 hrs". I am sure I can adjust what you have down to…

I am having the same issue with my catalyst 3650-48PS. Just upgraded to the new release of NPM 11.5 Still showing incorrectly.

Dan, Thank you for sharing. I just ran into something similar & was able to use your auto bat script to do the same thing. Much appreciated.