njoylif ✭✭✭✭✭

I've got a few things we could do (check content exchange stuff from me...I've got one where I take static routes from NCM and put into NPM so they show up on the map for a device, also serial numbers). Basically if you create a few custom properties in ncm (orionnodeid) in ncm nodes and use that with the IP address to…

do you have more than one web server? The Icons have to be on each individual web server (locally) you are running.

I wouldn't bother noting the trap IDs. If you were going to do that for records or such you would archive them out somehow. This basically removes [orphaned] data from TrapVarBinds table where there is no related trap id in the Traps table. you don't have to do anything but run the query. the subquery in () gets the list…

just run that same installer and it will recognize that it is just a web server and install only the info service piece.

I've updated to that RC Service release. I have an engineer that indicated he entered some IPAM "reservations" -> set to used, hostname, some custom fields -> systems not online yet. came in today and all his work was gone. I do have additional pollers and web servers that I installed it on as well. I only installed RC…

Server OS - All servers: Win2008 server 64-bit on VMWare DB - SQL2008 64bit dual proc 16GB RAM, Compellant SAN connected NPM/NF/IPAM/IPSLA - dual proc, 4GB RAM NPM addt'l PE/IPSLA x3 - single proc, 4GB RAM Addt'l Web srv x2 load balanced - single proc 2GB RAM Number of nodes 562 Number of interfaces 9615 Total elements…

only thing I can think to do would be to open the report in question, view the SQL, and dump that into a new report, but I wouldn't think that would give you the graphs, etc. the SQL server will run the "WHERE" clause before the actual select. might be worth a shot anyways...

I haven't tested but I would think as long as you know some way to ID the 'surrounding' nodes you'd be able to by hard coding the NodeIDs or whatever you chose to ID them with. Seems unuseful as it is very hard-coded and I'm not a fan of that. Another option would be to group your devices in some manner and create a new DB…

to my knowledge, there is no way to do this currently via the view page alone. I've worked around this by calling a page "top.html" which has code in it using frames before, though certainly not ideal. The frames (2 or 3 in your case) would then call individual view URLs.

what do you mean when you say job runs and send e-mail but only for my admin credentials ?This is how the report scheduler works. You tell it what account you want it to run as - the scheduler uses this account to launch the task so you must ensure that account has the proper permissions. You have to check "Run whether…

Not sure, but I think they are good about adding them in. Just send the MIBs your looking for in and then download the updated DB from the site.

this is referring to the version of the Solarwinds Module/software that you installed (not SQL DB Version). the additional web engine version is newer than what is currently installed on the main NPM engine. either download the specific module version for the web server that is installed on your main NPM engine, or upgrade…

not sure about the dynamic pulling groups, I didn't see groups as an object type so it doesn't seem possible in 10.7. I am on 10.7 and have tested this...to manually move a group though, try: check the group that currently "owns" the group you want to move and click "edit properties" -> in contains section click…

try ^\s*$ also, this is a great tool to test regex (keep in mind it may not be exactly the same as how SW implements) http://gskinner.com/RegExr/

also, try no space between sql: and select ${SQL:SELECT I've never used alerts around reports but other alerts allow SQL for sure.

you can put a SQL query in the alert email fields using CASE [NOTE-you cannot use () Statement] : I use the below to BCC the ticketing system if the group is <whatever>:

I don't believe so as the select statement is set and you are just adding [to] the "WHERE" clause

I select all types, and status types, and use regex: interface description -> "does NOT match..." (last option) and add this line...review to see what you want/don't want... ISATAP|Miniport|Teredo|Lightweight|Async|Software Loopback|Multiplexor|Kernal|sit0|Null|Backplane|Extended

bit old, but ran across when searching for something else. it will only return one cell. search for sql and "for xml" or path xml. that statement will allow you to squish results set into one cell, though you will have to play with formatting.

I'd love to see this too!

or perhaps ${customproperties.alertemails}? is this stuff case sensitive? Thx

try it without the getdate() section and see if that piece works, then work on the issue from there, if it does. Actually, do you need the getdate if you are just pulling the top 25? I haven't looked at that table.

have you checked into KB articles. a few say something about expanding your maxTCPPorts or something which the OS natively restricts out of the box, this registry fix permitting you to expand the resources available.

Thanks for sharing this useful tidbit of head banging aversion!

get with your VM guys. I would expect your "1 drive" for db is actually SAN space and spread across multiple disk heads. YOU NEED this. you will not be able to run on one single phsical HD effectively. Also, you are correct in that you want another space for your transaction(DB) logs. Ideally, this would be on a different…

really should be two separate alerts...in my env. and with our paradigm basically, when the alert is triggered as warning...it wouldn't re-trigger as critical...it's already triggered. What you could do, if it makes most sense in your env. to have them both in same alert.... "escalate" when critical

I would start by running permissions checker as administrator and fixing any issues there. shutdown website and services. rename the c:\inetpub\solarwinds to .old remove the website and app pool from IIS run config wizard - as administrator - again and see if that resolves any of the issues.

what version of Orion are you using? try using Nodes (view for backward compatability) vs nodesdata and nodescustomproperties (one option) Initially, your join for the nodescustomproperties, first and foremost, has to join to the "previously built/put together" table so that line should be... INNER JOIN…

I had this working prior to migrating to VM. it worked fairly well. Failovers did cause web page failures, but they refresh and right back in.

SAM is custom properties are housed in the APM_ApplicationCustomProperties table. Volume info is housed in the Volumes table. If these are not working there could be a few reasons. a. they are not set up to work with macros yet. b. the way you are deploying them...there has to be a tie to it and this may not be native.…