rstoney00

You can solve with a sub-select as a join, instead of hopping straight to the 'where' statement. Use that sub-select with the distinct, and right join it back to the top, so the top, unchangeable portion will only "match up" with the distincts you have created. Your where statement can go in this sub-select.

WHERE ( DateTime BETWEEN 41799 AND 41827 ) AND ( (Nodes.UnManaged = 0) AND ( (Nodes.Caption = 'Server1') OR (Nodes.Caption = 'Server2')) ) AND ( (APM_AlertsAndReportsData.ApplicationName ='AppNameYouWant1') OR (APM_AlertsAndReportsData.ApplicationName='AppNameYouWant2'))

<edit> Misread Seth's request. Sorry !

Another idea that I have used is to use WMI calls. I call both servers and check on them (who is active, services, etc) If the primary is up and active, I returned a 1 If secondary is up and active, return a 2 If both are down, or the services are not running to allow a fail-over - return a 3. Then of course anything…

So, as part of your NCM product for downloading configurations - there is an excellent tool for doing Security related checks and reporting. Take a look at Compliance. You can create a rule that searches for a string (or regex) of "username" Use a Compliance Policy to assign that rule to a group of nodes, and then create a…

Jiri Ticket was 624162. So - the dev solution that was given was to include the {$HostName} variable as part of the file name. This would have each poller write to the same location, and create individual files for each poller. If you have three pollers running the same NCM job - you would get Poller1-Filename.txt,…

Bkohls - The 'weird part' you see above - try running the schema update (or run config wizard) with an account that is an admin account on that machine. I believe that is what corrected the problem for me. When you use the Group, be sure to use the GroupMemberStatus option for 'down'

Hit the pavement running - Most really don't want to hit pavement to begin with, let alone running. At the end of the day - Translation I have no clue what will happen, or what did happen, or how to make it happen. But here is where I want everyone to agree. Circle back - Usually used to indicate they will contact you…

Very much looking forward to this feature release. THIS is how you should port features from Win32 clients to web !!

Helpful place to read through: http://www.brentozar.com/archive/2011/09/sysadmins-guide-microsoft-sql-server-memory/ It is geared towards SQL 2008, but the basics apply. Am sure some other folks will post out some good links as well.

By point and click in the routine SolarWinds web page? Not that I have ever seen. There is the dbo.Resource table - if you are brave enough.

I had to use a different number in awk to get the free memory value, but here is a workable solution for you: Script argument line bash ${SCRIPT} Body of Script #!/bin/bash memory=`free -m | grep Mem: | awk '{print $4}'` echo "\nStatistic: $memory"; echo "\nMessage: Free Memory is $memory Kb" fi On your results - you can…

Could you? Yes. Should you? I would think there are much better ways to determine what you are after. Your scenario would be adding the node in twice, with different IPs, and some what to name them so you know which is which. So, possible to do, and they would 'act' like two different nodes, even though they more or less…

Servers, applications, interface utilization spikes. I gave some example SQL code in this thread: Re: Help... how can I alert on a sharp change in the WAN Utilization? No reason that couldn't be modified around to look at memory. Premise is to look at utilization for the last hour/day then compare it to the average of the…

IPAM will not use the additional poller, sadly. There are a couple feature requests in for this already. It would help to push the UDT and VNQM load if you set up an additional poller to handle that traffic.

njoylif Perhaps a more desirable method. Cisco devices can use a filtering facility to send the syslog when some leaves conf t session, but ONLY that syslog message. Send that over to your Orion. Add in a processing rule after you trigger the RTCD action to event log it, then delete it. Keep your syslog table clean. edit:…

I believe you can create all of your pollers, then use UnDP transforms to average out one poll cycle. All UnDP pollers will have to be on the same time frequency, say, every 5 mins.

saroop; Sorry it was a bit unclear to me - which machine are you rebooting? The SQL server, the NPM/NTA machine or your PC?

ntp server (?!10.1.1.1).* This will find ntp server with any other IP address. Use this as a rule, alert critical if found.

Try changing Where LastChange to Where NPM_RoutingNeighbor_V.LastChange 

dbo.ConfigSnippets in your NCM database

Alex's world. <kidding with you Alex>

Okay - not stupid question - but have to put it out there as it was funny at the time. Two years ago, bought parents a tablet (basic Google Nexus....nothing fancy here) and wireless router. Got everything hooked up, working perfectly, taught them how to use it. Fast forward a few months: <phone rings> Dad - Hey, have a…

Why they couldn't get a login / password prompt from the computer. During a regional power outage.

Well, am guessing that you just want to to list out Caption, DeviceRole and IP Address. If so, the query is a bit off. Try this: Select Nodes.Caption AS ServerName, Nodes.DeviceRole AS DeviceRole, Nodes.IP_Address AS Ips FROM dbo.Nodes Not sure why you were including a subselect there, for information from the same table. 

Will shortly be web-based. This is one that I hope they do a REALLY good job of getting everything right.

Concur with Richard Letts - you need to do all at one time. Something to help speed up the poller installs: You can run all the installs at one time - just stop when you get to end, before "Config Wizard" gets opened up. Then you can just step through the pollers one at a time, running config wizard until done. Small…

Can it be done? Yes. Run over 5k nodes, standard polling rates on virtualized NPM, NCM, SAM, pollers etc. HOWEVER: If you are running any size to your installation, you should probably NOT run your SQL server as virtual. Now, some may have the SAN speed to support the IOPS needed for SQL server. This likely falls in to…

So, this would actually work out best in two rules, applied at the same time in one policy. Rule 1 Find all you should find, critical IF NOT FOUND test1|test2|test3|etc Rule 2 Tell me if you find anything that should NOT be there. Critical IF FOUND (?!(test1|test2|test3)).*privilege 15 blahblahblah Obviously, you will have…

There is a resource called "Custom Object Resource" you can add under "Customize Page" Try that out. You are already tracking the interface data. It is now just display issue.