Comments
-
@"mrkuwait" What exactly are you trying to achieve here, are you trying to get the average node availability for the last 30 days and then match up the same average interfacetraffic on these nodes for the same 30 day period? If your interfacetraffic table is anything like ours, then this table contains 365 days worth of…
-
kreases , looks like you may have hit a brick wall my fried. NPM uses CDP, LLDP, CAM and ARP protocols to gather topology information from switches, so unless your switches support either CCDP or LLDP then you might be out of luck.
-
@"mrkuwait" You can try the query below to search for the last 30 days, i had some variance in the results, but feel free to try it. select top 10 T1.NodeID as NodeID, T1.InterfaceID as InterfaceID, T1.Caption as NodeName, T1.Interface_Name as Interface_Name, AVG(T1.inaver) as AVERAGE_of_Average_Receive_bps, MAX(T1.inmax)…
-
@"mrkuwait" Run the following, again adjusting the 'Select Top X' to suit your environment. select top 5 T1.NodeID as NodeID, T1.InterfaceID as InterfaceID, T1.Caption as NodeName, T1.Interface_Name as Interface_Name, AVG(T1.inaver) as AVERAGE_of_Average_Receive_bps, MAX(T1.inmax) as MAX_of_Peak_Receive_bps,…
-
kreases out of curiosity, what type of switches are these and do they have CDP enabled?
-
@"mrkuwait" Apologies, but got tied up with some other things, okay so since your individual queries appear to work when running them seperately, you could try joining these instead by using the below - you would still need to add your where clause any ordering you are needing to do. Please also note i adjusted the select…
-
kreases when you are connecting your devices in Network Atlas, are your endpoints the Node or the Interfaces? Initially when I was doing this the endpoints were the actual interfaces and this didn't work quite as I'd expected, but when I used the nodes themselves I had more success. It was just that some of the nodes…
-
Okay a couple of things to check. Are you running SSMS on the server directly or from a remote machine? When logging into SSMS, prior to connecting, click on the options tab and what is the 'execution time' is configured for. Once connected in SSMS, from the Tools > Options > Query Execution > SQL Server > General > What…
-
kreases Yes I finally got this working on the nodes that were only showing grey lines by doing a list resources on the nodes in question at either side of the links and ensuring that the Topology Layer 2 and Topology Layer 3 selections were selected. In my case the links that were showing grey had these options unchecked.…
-
Finally resolved this issue, it turns out that the rules albeit created under my own login account were using the default 'admin' account which is disabled on our system. Re-enabled the admin account and it now works as expected.
-
aLTeReGo yes we are already running SQL Server 2016 SP1
-
Apologies i misunderstood the question. We have what you have, a group, a network map tab and an orion map tab by default. The issue that we have is that the orion map tab dynamically populates each time it is selected, this throws all of the objects on screen in a random order, we can re-arrange this to reflect actual but…
-
I ended up raising a support ticket for this only to be told of an error showing in the Alerting.Service.V2 logs which was irrelevant to my ticket and was asked to check this log for further errors and ask on here for a quicker answer. The error that is being generated in this log for my alert is as below, it mentions in…
-
@"jblankjblank" The time travel feature has helped us to get to the bottom of an issue that we had been repeatedly seeing each weekend over a period of several months. On checking alerts and notifications from the network we would see a large number of devices in a particular section of our network go unobtainable without…
-
@"rschroeder"the only thing that should change in the query will be the CustomPollerID value. If you run the following below from either SWQL or SQL you should get your unique CustomPollerID vaule for your setup. SWQL SELECT CustomPollerID, CustomPollerDescription, CurrentValue FROM Orion.NPM.CustomPollerAssignment where…
-
gjp1971 mesverrum Its okay guys, helps if you read the manual - eventually figured it out
-
@"neomatrix1217" The one that is failing is running 2019.4.1 The one that is working that was downloaded as an offline installer from our customer portal is running version 2019.2 HF3 - that was the only version available to me.
-
I raised a ticket with Solarwinds who advised that I didn't need to walk the MIB if I knew the OID, I could just create the custom poller with the info that I had even if it wasn't being displayed in the MIB database. When I try that however, it says that the value returns no data for the selected device, so yes I might…
-
aLTeReGo I would love to be able to run this update, however i cant seem to get passed the validation checks for various reason that i cannot seem to resolve. Anyone any ideas as to what i am doing wrong. Below is the step by step process / output i get. Step 1. Step 2 Step 3 We can forget about the first 2 errors - thats…
-
I raised the issue with support and they have advised that this is a known bug that they are aware of. They have also advised that even though it is possible to change this setting like dgsmith80 has said, they don't recommend this, so i guess for now i will just have to live with the issue until its resolved.
-
Hi, Yes we have in this subnet a string of 5 Garrettcom devices connected to each other in turn. LLDP is enabled on all Garrettcom devices and the switches themselves show the neighbour information. However within Solarwinds, it only shows the topology information above on the first SW/096 connecting to SW/142, it doesn't…
-
aLTeReGo Many thanks for your continued support. the above information allowed me to look a little deeper into the issue and i discovered that my issue was some old 'orphaned' HA servers listed in the database. This came about as a result of how we did our failover processes in our then active-active environment. To get…
-
Hi gjp1971 mesverrum I have been trying with little success in getting the Scoreboard to work and wondered if either of you could assist. I have the custom properties defined. I have the SQL job running to update these. I can't for the life of me figure out what i have to do for the Network Atlas part, i can't seem to…
-
@"famore" if you change the 'WHERE' statement to read as below instead, this should give you the stats for the current month only and reset on the start of each month. WHERE (MONTH(i.DateTime) <= Month((getdate())) and MONTH(i.DateTime) >= Month((getdate())))
-
@"mesverrum" no we don't have an inventory job setup to run on schedule, does this information get purged after a period of time?
-
Think this is maybe what you are looking for. https://thwack.solarwinds.com/t5/NPM-Documents/Custom-Maps-for-Group-Details-Page/ta-p/516425
-
@"sachsj" This is the reply i got back from @"jblankjblank" There are limitations which were put in place in order to ensure you do not impact both performance of Orion and/ or your database. Storing these maps take into account all the details such as the entities and all their properties, their position on the canvas,…
-
@"shocko" From the Reports Menu select All Reports, then in the top right of the page select 'Manage Reports' From this page, select the option to create a new report and follow the wizard. It should be fairly self explanatory when you see it, to get it to email someone or a group of people you will need to setup a…
