njoylif ✭✭✭✭✭

not sure, but try instead of hitting enter, hit <ctrl><enter> or <alt><enter>

off the top of my head -> eval a product called "ultraedit" or some other product that allows you to search within "files and subdirectories". run a diag on NPM and extract the files to a directory and search the directory with subfolders for the nodeid. you will probably get a lot of extraneous items if you do the whole…

I think its "6 here, half dozen there". I guess I'd probably move the SQL first and very working, let bake for a day, then upgrade. ALWAYS make a backup of DB before doing anything like this (both times) :) I wouldn't expect any problems. when you move the DB server, just rerun config wizard. you should leave the old DB…

another option is to see this content share it has UnDPs, a report, and SQL stored procedure that you'd run as you saw fit. part of the challenge is that the IP follows the unit, so which ever unit is active, it has the IP address of the "primary"

try searching msdn.microsoft.com for <sql ltrim> I think that will help you, otherwise, try the content exchange. I've posted some work on how to tweak the system name for grouping purposes. I grouped into a custom property called NPMGroup. let me know if you can't find it and I'll dig it up.

SW, can you tag this for PM review :) thx

I do get that you can filter within the nodes management [admin] of web page, but I can only do approx 100 at a time..rough...FYI

I think this is a loaded question :) there shouldn't be any issues having Orion be the source for networking inventory as it will be DB to DB. I've pulled info from Orion into HP ServiceManager and other tools with no issue (uCMDB seemed to much for us). The particulars will depend on what tool you choose for your uCMDB…

 I agree, this would be very helpful

Usually, you can click on graphs for data you want, and option at bottom to export raw data. not sure if SUEM does that but worth a look.

I expect it uses different tables (not summarized) because when I try to copy the top 5 by IP addr group last 24 and change it to last hour, I get the following error:

We are the same as toilet, all being on same subnet, save for one poller that sits on the other side of a firewall and hits all of our remote gear. Although, we will be pulling that back inside as there is no visible benefit to having it out there and many benefits to having it inside the FW DMZ.

with SWQL, the tables are tied together (linked) for you typically. try: select i.NodeID, i.InterfaceID, i.Caption, i.FullName, i.Alias, i.IfName, i.CustomProperties.Comments FROM Orion.NPM.Interfaces WHERE i.CustomProperties.Comments = 'WAN vrf'

select City, State, [zip code] from NodesCustomProperties ncp Where ncp.NodeID=${NodeID} if that doesn't work try swapping: from Nodes.CustomProperties

I'm having the same issue where data is not available. I'd love to have SW chime in. I'm not having resource issues in my env. though.

edit the resource the map is within and uncheck the box with "show download link"

That's a great request, I'd love to get that as well.

you have to go in and specifically delete the "removed" objects from the older system. It will not auto delete as you may not have meant them to go away.

test sat :)

no, but if you go back into the trigger action and select simulate for the email action, change object to one that would alert and execute, you should get email and that will tell you if that is working. if not, change the to: to be just your email address and simulate again. try simulate -> simulate as well to see if…

I think what RichardLetts​ was getting at and the thing to understand for alert queries is that you MUST tie the criteria to an object that the alerting engine knows about -> i.e. one of the "allowed" tables from drop down. in your case... you have to tie in the applicationID b/c that is one of only 3 columns in that…

This would make a great feature request.

@julionavarro1414, you should be able to do this by adding List of all interfaces: ${SQL:SELECT Caption from interfaces where nodeid=${NodeID}}

is it a custom sql report? I have this issue with my custom reports for some reason...

you will see a tab called "CONFIGS" at the top of the page on the web server you install the integration pack on. if you have additional web servers, it will have to be installed on those as well.

did you upgrade or make any changes recently? without researching, I'm guessing the "'" is either a single or double quote. try replacing with actual single quotes. if not quote, remove all instances and test

for this type of thing, consider getting IPSLA, which would allow you to source a check from each "edge" device to another. continue until all paths are tested. A simple ICMP test would work. You can then put that IPSLA object on the map for the "LINK" however that looks for you.

my experience has been it is that simple. The only gotcha I've run across is - ensure you have the SolarWindsNPM [or your custom] user created and permissions set prior to. If you migrate the IP address/DNS name (depending on which you use), you should be golden. I just detached the db(s), copied to new system, attached…

can't use "/s" in NCM which equates to space(s) like tab, spaces, etc.. just hope there are no double spacebar taps in description.

 ah, this is an age old issue for me as well. I am simply trying to monitor those tunnels (IPSEC only) and can't seem to get it down...the tunnel ID changes after the lifetime expires, and gens a new tunnel...eagerly awaiting insight - if there is a way :) Sadly, I think i'd have to code something to get that to work.…