njoylif ✭✭✭✭✭

absolutely possible. you need to have a unique field in each DB to "tie" them together. see example below. if you don't feel comfortable sharing here, private message me and I'll work with you to help as much as I can. remember: before doing any back end database work, ALWAYS BACK UP your databases. DB1_table1: column_a…

gotcha. additional web is $400 list. off-loads that from main poller and allows this workaround. Don't know your situation but might be worth it for now. Regardless, this needs to be fixed! good luck.

you betcha. I talked w/ Tulsi and UX team yesterday actually.

Ah yes, sorry...didn't read closely enough. you are trying to run a report against the nodes table that needs to include criteria from the interfaces table so you must do a custom SQL report that combines both tables in the query. If you are not the SQL person, I recommend getting with them to assist you with tweaking the…

probably vendor or specific hardware related then. I have quite a few Cisco 6500s loaded out and don't have any issues (minute or two). Anyone from SolarWinds - have you seen this before/Known issue?

So I need to know what the difference is between a resulttypeID of 1001, and an operationstatusID of unknown and down? how does orion determine a down? no response? if so, what scenario would give a 1001 or unknown? thanks

great question -> I second for feature request. SW -> can you move to feature request section and forward to PM? thx

thanks rob.hock‌, anyway to recover OOB alerts if existing implementation?

SQL statement is easy enough, but I don't know about dependencies. Deleting a node for example has many dependencies in other tables like interfaces, volumes, statistics, etc... can anyone from SW chime in on a way to mass delete volumes based on status?

ensure you right click on object and select label. That should actually populate a label with the system name. (another way to verify is to grab and move the label -> it will show a line to the object it is tied to - if any) This will ensure the label is tied to the proper object so the correct macro/column name gets…

weird, it worked in my env. I'm 10.2 w/ running SQL 2008 on 2008 R2. replace the sql with this (just removed the variable): select i.InterfaceName, i.NodeID, i.interfaceid, i.interfacealias, sa.StatusName as AdminStatus, so.statusname as OperStatus, ss.Statusname as status, Interfacelastchange, n.caption from Interfaces i…

select n.caption, rt.* from ResponseTime_Hourly rt join Nodes n on rt.nodeid=n.nodeid where n.caption like '%V=%' and rt.availability <> 100 select n.caption, rt.* from ResponseTime_Daily rt join Nodes n on rt.nodeid=n.nodeid where n.caption like '%V=%' and rt.percentloss <> 0 update ResponseTime_Detail SET…

ah, I gotcha..so you've grouped IP Subnets on right into a "folder/group" on the left pane correct? so there are several different options here... in the IPAM_Group table, you have columns (groupid, parentid, grouptype, friendlyname) plus others. grouptype = 2 should identify as a group. you could also validate by using…

ah, I would definitely open a support case then. Please post the resolution here when done. thx

Yea, had that in several iterations of the test. My last post errored out as well...jumped the gun on the post. it works if I just use order by timestamp desc, but I only want the "last results" for a given component ID which boils down to the top ComponentStatusID. I'm just struggling with how to limit it in that fashion.…

I asked this question a while back and got: The time it takes is based on the number of linked maps and objects on all of the submaps. Orion has to query the DB for the status of ALL objects within the map hierarchy. I am going to get around this by making several "TOP" maps for the different areas and have my Network Ops…

excellent, thanks all

i did try it w/ $lvl = $res.notificationlevel as [int] and still got same behavior...very weird. Thanks for exit code Heads Up... now I get stat as 0 but I know the remote system I'm testing against is 3... new to PS...it should be remote to run against the target system and not run local on the poller right? something…

good question on how to do it...I will say you do have the ability to add application custom properties to the task as it is monitored as an application, it is just not intuitive how to get there since the links just send you back to the node. rather labor intensive through gui, but...might be able to do something with CP…

you can include that in your WHERE clause even if not returned. should be able to just add: AND Rate >=50

not that I'm aware of, but I didn't try hard

in the WHERE statement before the ORDER BY add: Where (StartTime.EventType=1) AND <condition> not sure if you are talking about using a Node Custom property..that's easy AND Nodes.<groupCP> like '%partOfName%'

Excellent. glad that worked for you.

I think if you unmanage ports here, it unmanages them from the Orion environment, so be sure that is what you want to do as you will no longer get stats, alerts, etc...

when you need to set thresholds but have no idea what to set them to; it is the perfect time to "use latest baseline threshold" where the system looks at trends. even if you end up padding those numbers, its a place to start since every implementation and environment is different.

gotcha. I have no idea where (what table or calc) they get that number from. I think it has been on thwack that people want web based access to those stats as that is really good info...

I created a report -> see attached, for unmanaged nodes. I then put this report in a view and put it in my top 10 page. you could also put it in its own view and create a menu bar option for that...I think I'm going to move to that and do a nodes and interfaces report. only thought on the user would be very manual and…

Interesting. I haven't customized any Netflow views. Node, yes, but not Netflow. any thoughts?

I tried the <br>, <br />, and <br \> for good measure...none work. I am in the same boat on this...trying to get a column to "break up" nicely for report output. SQL using replace.. to insert breaks, char 10s,13s, both, etc... nothing seems to be working when report outputs via web

didn't realize they were unreachable; could be many reasons for unreachable...are these interfaces off a node or is it a "node" or device? check poller load off the admin page, check "list resources" to ensure no issues there, etc..