dunky2k · Systems Engineer · ✭✭✭✭✭

Comments

  • Out of curiosity, can you change the select to only output the top 10 rather than top 1000 and see if that runs.
    in SQL Error Comment by dunky2k June 2020
  • What type of widget is this, is it a KPI one? Are you able to paste your configuration so i can see what you are trying to achieve?
  • @"Seashore"Yes that does work, but only when i use Edge for some reason. The strange thing is that it worked before in Chrome, no big deal really but would be nice to have it working like it did before.
  • @"rschroeder"Sure i can try and show you how i did it earlier, however please note that i am on version 2019.4 and not the latest 2020.2 First of all i will assume (probably wrongly) that you may already have a UDP to discover the Battery Temperature. Open up the UDP application on the main poller and you should get a…
  • Hi Scott, apologies for the delay. I read elsewhere that you cannot use Universal Device Pollers due to the version of NPM you are running. The above chart was created using Universal Device Poller. If my assumption is wrong then this is what i did to get mine work, albeit our UPS's are different models, but the principal…
  • Thanks dgsmith80​ and aLTeReGo​ all i wanted to know was if i needed to do anything specific with the HA pools prior to running the wizards.
  • Hi, Looking at our Proxy it doesn't appear to be able to list that information from the BLUECOAT-MIB although i can see the information from the Bluecoat Proxy Web Applet. Sorry but it looks like this might not actually be possible, but i stand to be corrected on that if anyone else knows of a way.
  • We run a similar setup except we also have APE's and we have all of our products licensed on our primary servers (NPM,MCM,IPAM etc) and a HA licenses for our failover servers. So in you instance you would license all of your modules on the primary server and just buy a HA license for your failover server, you don't need to…
  • @"neomatrix1217" Yes the alert is setup exactly the same in both instances. The alert works in the instance using Log Analyser. The alert doesn't work in the instance that is using Log Viewer
  • Hi there, I wasn't able to figure out what I originally wanted to do, however I did get a workaround to give me this information displayed on a report. Effectively I wrote an advanced sql to extract the data I required and then produce a report to display that information I needed.
  • Thanks for the reply. I ran the snmpwalk.exe from Orion and it doesn't show the OID that i'm looking for either. It appears that some of the OID,s on the ASA are marked as 'not-accessible' perhaps this is my issue, need to find a way of accessing these.
  • Many thanls for the tip, never thought about the user SID. Deleted and recreated the user on the Secondary Replica so that the SID macthed and that sorted the issue out.
  • I know the files are being locked by the traps/syslog service as when i stop these services the JET*.tmp files get removed from the WINDOWS\TEMP folder. On restarting these services the JET*.tmp file re-appear. Its not practical to have these services stopped for the duration of the database maintenance, nor should i need…
  • Hi sja, Firstly many thanks for your reply and suggestion. I'm not that familiar with the PollerCheckerTool, so not entirely sure what options to check, however saying that I have ran it against some of the nodes I have issues with. Attached are 2 images - 1 called Cisco that does show the topology information and 1 called…
  • Hey there, Sorry but just seen this message - give me a day or so and i will provide some info on what we did when we were in an active - active setup. Not sure though if your two installations are polling the same equipment like ours was, but it shows what we needed to do when we failed over to our DR box. Cheers Duncan
  • aLTeReGo​ Thanks for the reply, can you advise however which is better. Basic Availability Groups (SQL Standard) OR AlwaysOn Availability Groups (SQL Enterprise) Apart from the difference in licensing, are both methods supported? We only have a Solarwinds Database, we don't use NTA (yet). Regards Duncan
  • Many thanks, this does what I need it to do.
  • Hi aLTeReGo​ Many thanks for the reply above. Now that we have restarted with clean machines i proceeded to follow the steps below 1. Installed the HA installer on my Primary standby server that will protect my Primary poller and let the configuration wizard complete. 2. Installed the HA installer on my Additional Standby…
  • superfly99​ Managed to get it finally working - there was indeed an issue with some of the nodes that weren't showing the links. All sorted and working nicely.
  • @"famore" @"nz1jvb" Guys, i set this up for my environment and works fine for me, we use Cisco Anyconnect as the VPN client. VPN Widget To achieve the above i used the SWQL below where the XXX is the Solarwinds NodeID of your ASA devices, we only have 2, but if you have more then that line will need expanded to include all…
  • @"lawrencel" Are you wanting just the widget with the count, or do you want the tables that show the actual acknowledged / unacknowledged data, or would you like the both of them?
  • @"rshrewsbery" are you looking for something as simple as the widget below to display a count of users connected? If the above is what you are looking to achieve then the below SWQL should give you the desired results. SELECT count ([data].[RemoteAccessSessions].[UserName]) AS [Number] FROM orion.asa.node AS data where…
  • @"hernandez.julio92" @"jblankjblank" We had a similar issue when we had a map for our cisco switches in that some 'extra' links were being created which implied that these devices were directly connected where infact they weren't. We discovered that this was, in our situation down to the fact that as well as monitoring the…
  • Looks like if i do an inventory update for the devices that are missing, once completed the data now appears. Question i suppose now is, how did this information disappear in the first instance?
  • We have a couple of very high level basic screens that show an overall status of our network, from the main 'orb' page we can drill into each section to drill down even further and either end up on a page view or a network map or alerts etc. They currently cycle through on a spare monitor for the local support team to see…
  • @"nmsrabobank.nl" You don't need the 'AS' if ypu are aggregating the totals. SELECT ( Count(Nodes.Volumes.VolumeID) + Count(Nodes.Interfaces.InterfaceID) ) AS Total FROM Orion.Nodes WHERE Caption = 'the node I am looking for'
  • @"jblankjblank" Thanks for the update and reasoning behind why these limitations are in place. In our scenario, although we have a large number of maps, these are seperated into segments in our network, which in turn don't have a lot of entities on each segment, nowhere near the 100 limit. As for performance, again in our…
  • Try changing the From statement to the below. FROM Nodes Inner Join Interfaces on (Interfaces.NodeID = Nodes.NodeID) Inner Join InterfaceTraffic on (InterfaceTraffic.InterfaceID = Interfaces.interfaceID AND Interfacetraffic.NodeID = Nodes.NodeID) Inner Join DailyNodeAvailability on (DailyNodeAvailability.Nodeid =…
    in SQL Error Comment by dunky2k June 2020
  • You can resize the widget by editing it and then dragging the bottom right corner to the size you want like below.
  • I use a couple of similar ones that shows users currently connected and users that have connected in the last day as well as some statistics.