njoylif ✭✭✭✭✭

I have found this as well, and am frustrated that we don't have a solution (as is my management) that works. I have a compellant SAN that is not even breaking a sweat (3 addit'l polling engines, NTA, 2 addt'l web servers, etc... about 20k pollers) I am trying to schedule a meeting with my rep and a dev resource (but I keep…

don't know if this will work or not but try: SQLResource.SQL="USE <dbname> select count(*) as COS from heatdb.heat.asgnmnt"

I too have implemented this. seems to be a good way to scale. I'd love to be able to point map thresholds to custom properties.

try getting rid of the semicolon after DB name. then, assuming your DB name is Solarwinds-NetPerfMonNodes, I'd go to NPM server and pull up DB manager tool and run query there to see if executes successfully.

unfortunately, i don't think it will be that easy. If I'm understanding properly, you are not looking for a breakdown by engine, so those fields wont help. we'd need to get info from each of the elements tables that count towards licensing and the where clause would tie into the group table or column. First, we need to…

I thought there was a canned report for that... but anyways.. I've done something like this - but for total data in/out of data center:::Change the WHERE date clause -n for the number of months back you want to go (if I remember correctly). This may or may not help you do what you are trying to do...if nothing else, you…

this would be a great feature request!

you could do a UnDP (check content exchange) for serial numbers. There is a custom property (already in list of options) you can add for serial number.

I'm guessing here b/c I've never tried it, but you might be able to do it based on your pattern in example and then on DNS Hostname tab use regex and !(10.253.1.63). again, test this before relying on it...I'm guessing.

also, try going into SQL configuration tools -> configuration manager. go through all on left column and ensure that TCP/IP is enabled. I've had this get me before.

I had to do this because of 9.5s original slowness issue. I ended up writing a script to bounce the Orion Information Services (both) and scheduled every hour. That helped. Since, I've updated to SP4 and disbled the tasks and it seems to be working better now. One other thing to keep an eye on is to ensure that the page…

create a scheduled job -> execute command -> pick nodes you want -> show run -> email results of job.

Duh, I guess that's what advanced alerts are for. funny how that works

INSERTs are used to add new rows, UPDATEs are used to update existing rows. if Validated is binary, try using 1 instead of Y as it is binary True/False = 1/0 To test, I always add to my WHERE clause to use a specific row like NodeID=111 or something very specific.

I am getting this as well, trying to install 10.1.1 SP1....

no it doesn't automatically do it. admin/settings -> discovery central -> "interface discovery" or "network discovery" will find them. You'll still need to parse through or review. will give you notification at top of page(s). after scan, you can set interfaces to ignore for ones you never want to monitor (like null0 or…

Another option might be to write a SQL script. I've created some that I just run once a night to fill in my custom fields based on the Caption column in Nodes. One example: osql -d NetPerfMon -U xxxxxxxx -P xxxxxxxxxx -Q " UPDATE Nodes SET NPMGroup = ( SELECT SUBSTRING( Caption, 1,( ( Select CASE WHEN (CharIndex ('-',…

tag the trap (based on criteria you set with the alert) with some text. Initially I would use something bizarre for testing like "catdog" or something. the table it will reside in is the "Traps" table. an example query might be: select COUNT(tag) as occurances, tag as TagName from Traps group by Tag that would simply give…

look into dependencies: admin -> manage dependencies

don't know about graphing it, but I've done a custom sql query. try here and there is a link to the report I've created. basically, as long as the DBs are on the same server(instance) and the Orion users' permissions are allowed to hit the "other" DB, you should be good.

 I would very much like this feature as well. Some semblance of event correlation. Tall order though, I know!!

I tested mine and it appears to be working properly.

you could set a Custom Property <SDResolved> using powershell and the API for that object. your reset criteria would include this CP needing to be set... Also, you'd have to set up RESET action to clear that CP upon successful reset.

yea, I had done that as well until they fixed that link where it would translate properly to the text you set on that admin page, but then this changed. argggg! thanks

how often are you polling? does it have enough time to complete (usually will show unknown if not, though). can you remove this instance of appInsight and add new, if so, does it behave the same? what do the polling engine stats look like for the SW engine polling that node? I've never seen this behavior... Have you opened…