m-milligan ✭✭✭✭✭

Hardware details and status are saved under Orion.HardwareHealth. The set of hardware sensors for a given node can be retrieved from Orion.HardwareHealth.HardwareItem with a query like: SELECT ID, NodeID, HardwareCategoryStatusID, HardwareInfoID, UniqueName, Name, Value, Unit, OriginalStatus, Message, IsDeleted,…

Create an alert on a SWQL query. Set the type to "Virtual DataStore" and populate the query with: where Datastores.Hosts.DataCenter.Name = 'YOUR_DATA_CENTER' Like this:

The new version of the Linux agent detects GPFS mount points.

Most of my PowerShell monitors do this to get the user name and password from the ${CREDENTIAL} variable: $c = Get-Credential -credential ${CREDENTIAL}; [string] $user = $c.Username; [string] $password = $c.GetNetworkCredential().password; To connect to an Oracle database, build your connection string with $user and…

How frequently does Solarwinds poll your wireless controllers? Solarwinds learns the status of APs by polling the controller. If there's a delay polling the controller, the alert will be delayed. In your alert's "Trigger Condition" page, have you checked the "Condition must exist for for than N minutes" box (see below)? If…

I, too, would like Solarwinds to implement this. Can you create a feature request? That gets it on their radar.

What kind of alert is it (Node, etc.)? Assuming this is a Node alert, add this line to your query's Where Clause: AND Nodes.Unmanaged = 0 This will give you alerts only for nodes that are not unmanaged.

Can you post a screenshot of the application monitor template? In the trigger actions for your alert, edit the "Message" portion of the "Send an Email/Page" action. To include a list of application components that are down, warning, or critical, add the ${N=SwisEntity;M=ApplicationAlert.ComponentsWithProblemsFormatted}…

Add this clause to your WHERE clauses to get alerts that have been active for no more than 5 minutes: AND (MINUTEDIFF(o.AlertActive.TriggeredDateTime, GETUTCDATE()) <= 5) Add this clause to your WHERE clauses to get alerts that have been active for more than 5 minutes: AND (MINUTEDIFF(o.AlertActive.TriggeredDateTime,…

We just noticed this with the "Nodes with Problems" resource. We haven't found a fix yet.

Does your script expect any input or produce any output? If so, add the -noninteractive argument.

We had a similar problem after installing some new software to troubleshoot an unrelated problem on our Solarwinds server. Reinstalling the VC++ 2013 Redistributable x86 and x64 packages, Solarwinds seems to be stable again.

This SWQL query* will get you a list of all nodes that are currently unmanaged, the unmanage start time, when the node will be re-managed, the most recent occasion when someone unmanaged the node, and the account ID of the user who did it: Select N.Caption, N.UnManageFrom, N.UnManageUntil, LastUnmanageEvent.TimeLoggedUtc,…

I just had this problem. Rebooting my main Solarwinds server fixed the problem.

You can do this by creating an alert on Auditing Events that uses a custom SWQL query, like this: The query text in the white box is: INNER JOIN Orion.Nodes AS Nodes on AuditingEvents.NetObjectID = Nodes.NodeID WHERE AuditingEvents.NetObjectType = 'N' AND AuditingEvents.ActionTypeID = 102 AND…

Similar to the solution suggested by nks7892​, I just did this for a customer. In our case, the customer has their own Additional Polling Engine (polling engine ID is 12), and the discovery job runs on that polling engine. I created an alert with these trigger conditions: The alert has several trigger actions to set custom…

You can apply multiple templates to a server, so you can (for example) apply both the template for IIS and the template for Shift4.

This query will pull the information you need for your report only information about nodes that are ​not​ ESX hosts: select N.Caption as [Node], Count(N.AssetInventory.Processor.Name) as [Total CPU Sockets], Sum(N.AssetInventory.Processor.NumberOfCores) as [Total CPU Cores], Max(N.AssetInventory.Processor.Manufacturer) as…

I have a case open with Solarwinds for this issue. This morning I heard that it appears to be a bug in Solarwinds and a fix will be made available. ETA: I got a buddy drop today (13 December 2018) that fixed the problem.

We've had the same problem since we applied the last round of Solarwinds upgrades. I'll be interested to see if a fix is provided.

You can't create space-based thresholds on individual volumes, but you could create a custom Volume alert that looks at Orion.Volumes.VolumeSpaceAvailable, like this: Bear in mind that (1) you need to specify available space in bytes, and (2) You need to include only fixe disks or network disks, not memory, CDs, etc..

Try duplicating the alert definition and saving it as a new alert definition. I did this and found that the SQL macros in the new alert (the duplicate) execute correctly. Don't try simulating the alert - the error still shows up there. It should be correct when the alert runs, though. Please let me know if this works for…

2. Can I only populate the Map with nodes that are members of a specific group? You can't do this using the GUI, but I wrote a script to do something similar. In my case, I created a group called "World Map" and then I created a sub-group inside "World Map" to represent each building in my organization. Each sub-group has…

Are you running the Solarwinds services under a named Windows user account or as the Local System account? If you're running the services under a Windows user account, log in as that user and try to run your script from the PowerShell ISE. You may find that the named account is missing some permissions it needs to run the…

Do you just want a count of how many apps are up/down/unknown per poller, or do you need a list of the apps that are down/unknown per poller?

I don't have an answer for you. However, I tested ARRAYVALUEAT() with several queries and it does not work for me, either. Perhaps tdanner​ can weigh in? I tested ARRAYVALUEAT() with arrays that I got using SPLITSTRINGTOARRAY(), like this: SELECT TOP 1 Caption, ARRAYVALUEAT(SPLITSTRINGTOARRAY('Hello|§|§|World'), 0) as…

Unmanage/remanage a node already have auditing action types: ActionType IDAction TypeAction Type Display Name26Orion.NodeManagedNode managed27Orion.NodeUnmanagedNode unmanaged Mute/unmute are part of Alert Suppression, and they also have auditing action types: ActionType IDAction TypeAction Type Display…

I have Powershell script monitors that report that age of the newest backup file. Will that help?

You can also use the macro ${IP} to get the node's IP address into the script.

I was a DBA in a previous life, and I still occasionally cosplay one at work. You most definitely should have been warned that the TRUNCATE command would wipe out all the data in those two tables, and you should have been instructed to back up those two tables (and the whole database) before executing the command. What…