yaquaholic · Senior Monitoring Simian · ✭✭✭✭✭

And the 95th percentile is available right out of the box (on the custom charts),, click on the More (where "Less" is below) button to reveal the options:

Hi @rehan.mudassir@wipro.com Yes, the Orion DB doesn't actually store the percentile values, so they are calculated on the fly - hence the long wait. Instead of viewing the report, copy and edit it and then limit the report to the interface (or interfaces) of interest, this will greatly reduce the amount of work the report…

I created a quick bit of SQL that will do the job for you: SELECT [NodeID], [IP_Address], [UnManaged], [Caption], DATEDIFF (mi, LastSystemUpTimePollUtc,GETUTCDATE()) AS [Minutes DownTime] FROM [SolarWinds].[dbo].[Nodes] WHERE Status = 2 AND UnManaged = 0 You could use this as your Report's SQL query and then build the…

Easy enough to do, though the Vendor field is stored within the Nodes table, which you can link to easily in SWQL: SELECT TOP 10 i.FullName, i.OutPercentUtil, i.InPercentUtil FROM Orion.NPM.Interfaces i WHERE i.Node.Vendor = 'Cisco' ORDER BY PercentUtil DESC I'd like to write up how this linking of tables works, but I'm a…

Hi Rajasekar, Here's a starter for you, but before I give you a fully working script you'll need to check that it works first! The below script will extract all Captions ending in 01, using Get-SwisQuery and the SWQL query: Select NodeID, Caption FROM Orion.Nodes WHERE Caption like '%01' It then removes the last character…

If you are new to SQL, start by having a look over sites like - W3schools SQL Tutorial and have a good Google, there are plenty of good resources out there and by picking up the basics, you will get a much better understanding of how the Orion DB works for doing so. Add to that that the native API language of Orion is…

Sorry the link fails and it won't let me post the PDF in this thread for. If you have support you can use this page, lots of information on WMI troubleshooting: Troubleshooting WMI issue in SAM - SolarWinds Worldwide, LLC. Help and Support

garyblack, Have you seen sprintgeek​ posting with PowerShell scripts to do just that - DFS Backlog I am currently playing with them trying to get them to function, but they're a start.

Unticking the real and virtual memory volume from the node references and deleting them from the volume table using SQL, does the same thing. Resource view for node: SQL shows: Then reopen resources and add virtual and real memory and save: And the re-run the SQL SELECT from Volumes table: Now if I delete those tow new…

Yes it sure is. So, the obvious question, are any volumes that fit that filter, actually below 15% avaialbe space? Now without seeing your database, it's pretty hard to see if any nodes pass that filter, let alone are below 15%. Are you comfartable with SQL or SWQL? You can see how the logic works if you hit this little…

Send alerts when things work? Sound counter intuitive to me. So why not produce them (mgmt.) a report, detailing such information? Have a look at the "Windows Scheduled Tasks General Report", it should get you started.

Hi David, On the application view, do you have the Management option in the Application Details? If so, click on it and you'll be editing the application monitoring. Each of the monitors will now be listed, expand one of the failing ones (they should have red status icons). You will now be able to see the credentials used…

The platform team have just given me a test system, so I will have a crack at this today for you.

Eeeek, tough one that! I can't see a way of disabling just the IPAM scanning. Can anyone else shed light on Jonathan's selective shutting down of IPAM, on a shared Orion platform?

Do you know which node(s) is coming and going from the group? Is it statically assigned or dynamically? If it's statically assigned, then it's sounds very bug like (support call time). If it's dynamic what does it look like? Is it possible the chosen quality is changing itself, such as a DHCP node and a dynamic IP filter…

Surely you only need to ensure that one instance of the process is running?

Postmaster is the PostgreSQL multiuser database server (PostgreSQL: Documentation: 8.1: postmaster)​.

Shaun_9999, Use the command: ps -ef This will list all the running processes and a few of their details, from there it should be quite easy to spot the PostGreSQL daemon and it's new name. Remember that Linux is case sensitive. HIH

Or in the alert Action, you can add an action to be executed, when the alert is triggered. This will allow you to execute a script or executable, when the alert is triggered. This can be a local file on the Orion server or a UNC path to a remote file.

Hi Ciboyle, Yes, yes there is but @mprobus​ beat me to it. (We were enjoying a long weekend, here in Great Britain). Though I would have based my SQL on VolumeType, rather than Caption. Hope you have sorted it

Once you see the logic and how the tables work, the alert trigger should be easy. You know the ProfileID for the discovery, you can now check the DiscoveryLogs table for its last result [Result] or [ResultDescription] and use this as your alert trigger.

Easiest way is probably to create SQL report. Try this for a starter, the DetailsURL will allow you to hyperlink the Caption. SELECT n.Caption, ai.NodeID ,ai.Name ,ai.Version ,ai.Publisher ,ai.InstallDate ,'/Orion/NetPerfMon/NodeDetails.aspx?NetObject=N:'+CAST(ai.NodeID AS varchar(256)) as 'DetailsURL' FROM…

Okay SNMP works fine: .1.3.6.1.2.1.2.2.1.2.1 = STRING: "Siemens, SIMATIC NET, Ethernet Switch Port 01" .1.3.6.1.2.1.2.2.1.2.2 = STRING: "Siemens, SIMATIC NET, Ethernet Switch Port 02" .1.3.6.1.2.1.2.2.1.2.3 = STRING: "Siemens, SIMATIC NET, Ethernet Switch Port 03" .1.3.6.1.2.1.2.2.1.2.4 = STRING: "Siemens, SIMATIC NET,…

Failing that you could always script locally (on the server, DB, etc) that you are monitoring, with results being outputted to a local file. Then use a PowerShell monitor to read from this file into SolarWinds. Set the script up to run via Scheduled Tasks, or from a DB trigger. I found this method useful for large SQL…

Victor, You can use vbscript, perl, Jscript and Python in SolarWinds,using the the Windows Script Monitor. Please have a look at Create a Windows Script monitor Good luck, Rich

Try adding the .0 to the end of the UDP polled OID. Try using .1.3.6.1.4.1.20542.9.1.1.1.261.0 instead of .1.3.6.1.4.1.20542.9.1.1.1.261

Agreed, I have spent the past half an hour trying to find an interval with less than ten minutes, in any interface database table. I am scratching my head myself.

Odd one, I have seen OIDs that encompass the IP addresses before, but I don't recall having issues with them (except trying to extract the IP from the OID). In fact I have just recreated the poller and it is working for me, you might need to raise a support call.

Hi Clarv02, There is no SQL or SWQL query, just a trigger that looks at Customer Node Poller, WHERE Unique Name = <poller name> (bgpPeerState in this example) and Current Value is not equal to 6 (aka Connected). You can add the icons, when you edit the table resource, within the table layout add a new column (click the…

Ryan, Sorry for the delay, I off was moving house. The full text from the Generic Icon resource was: /Orion/Images/StatusIcons/{0}.gif I hope it helps, Yaquaholic