lbyoung

Seems to work. Its funny you mention that Report because I just got it mostly working on my end by modifying the Percent Down Last Month and making it Percent Down Last 72 Hours. I then look at the top for the devices that are 100%. I think either report will give me the info I need and I appreciate the work you put in to…

Thank you for the information. We are looking into separating the database and polling engine to two servers, but I do not believe that is the issue. We have not added any additional nodes in the past 3-4 weeks and this just started over the past weekend. I was told by Orion support that as long as the polling Indexes…

I opened a ticket with Solarwinds to see if there is a way to produce a "Last Seen" Field to show when the node last responded. If so, a script could be written to say only show nodes with a "Last Seen" Field of greater than 72 hours 

No nodes found with that one. I have no problem testing

Appreciate the help. I am the opposite. I have 10+ years of Cisco experience but am just getting into the SQL realm because of Orion.

Checking into the IO right now. We are running the polling engine and database on the same server, but it is Virtual Windows 2008 with 10GB Memory and 3 Processors. Orion is the only application running on this server. We currently have 8553 elements and that number has been pretty consistent for the past 6 months.

DANG IT! I thought we had it but I just ran into a snag. The report correctly lists the nodes that have been down for longer than 3 days but it also lists the devices that are currently down. I ran the report a few minutes ago to test the "sort by date" function and one of the nodes that had just gone down 5 minutes ago…

Current Time 11:04AM The poll interval should be 10 min unless I'm reading something wrong. This is what I see for the node and it does not change if I do a Poll Now or Rediscover (both successful): Polling Interval 600 seconds Next Poll 08:22 AM Statistics Collection 10 minutes Enable 64 bit Counters No Rediscovery…

One of our SQL guys happened to be in the office and was able to get the date piece working. We added the following line to the end of the code: order by AlertRaised desc Thank you so much for your help in getting this done.

That is giving me the nodes I am looking for! Great job! If I can ask one more small request, that would be great. Is it possible to include the ability to sort the columns? I would like to be able to sort by date? If that is not possible, I understand and greatly appreciate your help with the script. Thanks again!

No, we decided not to use the IPAM module or local DHCP. Sorry.

The next Poll is changing. I went ahead and Purged the queue (There were probably 100+ messages) and rebooted the server. I waited about 10-15 minutes and logged back in and looked at the polling settings for a node (The current time is 8:08AM on 10/26): Polling Interval 600 seconds Next Poll 10/25/2011 09:49 PM Statistics…

I am running 12.2(18)SXF8 (Sup2's) and 12.2(18)SXF10 (Sup720's).

It would be very useful to add a weekly scan to the schedule option. I have 5 scans that I want to run after hours and have gone through the process of running each and then changing them to 168 hours, but sometimes the scans do not seem to follow the logic. I have some that still run daily and another that runs at random…

It is currently 1:55PM and it shows: Poll Interval 600 secs Next Poll 10:08AM Rediscovery Interval: 60 Min Next Rediscovery 10:55AM Last Database Update: Today at 1:39PM I have performed the steps in the following post: replacing the 3 files and restarted the server after. Thanks again!!

It is possible that I am entering the script into the wrong location in Report Writer as this is my first attempt. I am going through File- New Report - Advanced SQL and then pasting the script under the SQL tab and running the Execute SQL Query function.

I read the KB and am confused that it states 12.8 is the minimum IOS when 12.4 is the highest version available. I am running 12.2(18) on the device and show ip dhcp pool is not available. That command is availbale on a 2811 router I have running 12.4(13). Do you know what the real minimum version is?

Issue has been resolved. When I performed the repair, it reset the IIS settings to port 80 while the application is set for 443. Changed this setting and I am now able to access again.

Thanks for the script, unfortunately it is not giving me any nodes. I have 4-5 nodes that have been down for about a week and they are not showing up in the SQL Query. I am not getting any error messages and unfortunately, my background is in Network Architecture so I have very limited SQL experience to edit the script.…

Thanks for the info. It looks like the ICMP polling is not working. Everytime I check the Polling Status, the ICMP is always the same: ICMP Status Polling Index: 8553 out of 8553 ICMP Status Polls per second: 0 ICMP Outstanding: 0 ICMP Statistic Polling Index: 15406 out of 15406 ICMP Statistic Polls per second: 0 The SNMP…

I am seeing something similar although my AWS hosts are red with the following message: PercentPortClosed 50% is over the critical threshold 25%

Add me to the list for TACACS or generic LDAP. We are running eDirectory which we would like to use either directly or indirectly through our ACS server.

Thanks for all of your responses. I have started a discussion on this topic in the NPM Feature Request section. Also, I have opened several tickets over the last 2 years for this issue. The latest ticket # is 318059.

Attempted to run a Repair on Core services. Configuration Wizard produced the following error: web request for /Orion/Login.aspx failed. The remote server returned an error: (500) Internal Server Error

A report showing "Last Uptime" for down nodes would also work if it could be sorted by date so those sites down the most amount of time appeared first.