m-milligan ✭✭✭✭✭

Yes, you need to query each of the tables separately. You can use the UNION operator to combine the results into a single table for reporting, if you wish. Here's a very simplified example of a query that gets the Interface and Volume resources for a node. Node that these are the resources that are being monitored, not all…

Which version of Orion and SAM are you using? This seems to be an error introduced in the latest update to Orion. I had similar alerts configured and working. After the upgrade, this error started appearing.

We fixed this by updating the Websites table. Our website listens on port 443 with SSL, but the entry for the "primary" website was lacking the FQDN, had port=80 and had sslEnabled=0. I ran this query to update it: update Website set Servername='<web server FQDN>', Port='443', SSLEnabled='1' where Type='primary' After this…

OK, sometimes the website breaks because the URL that your web server expects doesn't match the URL that Solarwinds has concocted for itself. Try running the query below against your SolarWindsOrion database: select ServerName, IPAddress, Port, SSLEnabled from dbo.Websites where type='primary' Do the values match the URL…

What do you see when you browse to the website for your installation? Does the browser just spin for a while and then time out, or does it pop up an error message like "404 - not found" or "500 Server Error"?

In a report, you can select for nodes where each custom property matches the criterion "Is Empty". In a dynamic query, select nodes where each custom property "is" and then leave the value field blank, like this:

This query will get the description for all components in all application monitors on all nodes. You can add more conditions to the WHERE clause to refine your report: SELECT N.Caption, A.[Name], C.[Name], CTS.[Value] from APM_Application A INNER JOIN NodesData N on N.NodeID = A.NodeID INNER JOIN APM_Component C ON…

If you're using SWQL, the component description is in Orion.APM.Component.UserDescription. If you're using SQL, the component description is in the APM_ComponentTemplateSetting table. You'll need to get the component template ID from the component in order to get the description, as in: SELECT [Value] FROM…

We're getting ready to upgrade to SAM 6.4. Would you mind sharing with me the problems that you encountered after the upgrade? Thanks.

If you just want to see the most recent response time, go to the detail page for your HTTP monitor. Find the "Application Details" widget, like this: In the list of components, click on "HTTP Monitor" (if someone renamed the component, look for the one with a component type of "HTTP Monitor"). This will take you to the…

If you want to use the REST API, construct a URL like this (using your Solarwinds server IP to replace localhost): https://localhost:17778/SolarWinds/InformationService/v3/Json/Invoke/Orion.NPM.Interfaces/Unmanage with a request body like this (again, for an interface with ID 11). Remember to convert the request body to…

If you're using PowerShell, you can unmanage an interface using the Unmanage verb, like this (this example will unmanage the interface with ID 11 for 5 minutes, starting now): $interfaceID="I:11" $start=[DateTime]::UtcNow $end=$start.AddMinutes(5) return Invoke-SwisVerb $SWIS Orion.NPM.Interfaces Unmanage @( $interfaceID,…

If your alert is on the Application Component (and not on the parent Application), this macro will get the URL: ${N=SWQL;M=SELECT Value from Orion.APM.ComponentSetting where ComponentID=${N=SwisEntity;M=ComponentID} and Key='Url'}

Can you paste the code from your alert in this thread?

Since it's just one machine, I suggest using the Unmanage Utility to unmanage the node during the nightly job. This will stop collection of all performance stats, though. If you simply want to mute alerts on that node during the nightly job, you can use cron or the Windows Task Scheduler to run one of the scripts linked…

I set up a handler to let users acknowledge alerts by responding to an email message. Documentation is here: Acknowledge Solarwinds alert by email

How comfortable are you with custom SQL and SWQL queries? If you are, try this approach: * Create a query to get the status of your transactions. * Create a query to get the status of your non-web apps (the Citrix based apps, etc.) * Make sure that the column names are the same in both queries. You may have to rename…

If you have enough polling engines, you can add each DNS name as a node on a different polling engine. What I often do in this case is add one node for the actual server that hosts the URLS. I then add an app monitor (HTTP, HTTP, SSL certificate, etc.) for each URL hosted on that server. So you'd have a WMI node for your…

I see that your script accesses the server's filesystem: Set-Content -Path "C:\MyTextFile.txt" -Value "DEBUG-Process:$Process " -Force Are you running the various SAM component services as LocalSystem or as a named user account? Services running as LocalSystem don't have the same access to the filesystem as an actual user.…

This SWQL query should get you started. YOUR_CONTAINER_ID is the ID of the container that you've created to hold the interfaces. Interface.Node.Caption as [Node], Interface.InPercentUtil as [Receive % Utilization], Interface.OutPercentUtil as [Transmit % Utilization], Interface.InDiscardsToday as [Receive Discards Today],…

Select those nodes in "Manage Nodes," then click "Edit Properties." This will bring up the properties page for all of the nodes. For each custom property you want to edit, un-check the box to the left of the custom property name. Enter/select the value of the custom property. Submit the changes. Solarwinds will update the…

Custom reports are reports you build using the Report Manager. You can copy a canned report and customize the copy, or you can create new reports from scratch. There is a query builder that you can use to select the data you want in your report (very much like the alert trigger builder in Alert Manager). You can also write…

This query will show you IP Address and whether those node is physical or virtual (the NodeType column). SELECT [Node], [IPAddress], [NodeType], [OS], [OS Version], [Total CPU Sockets], [Total CPU Cores], [CPU Vendor], [CPU Cores Per Socket] FROM (select N.Caption as [Node], N.IPAddress as [IPAddress], CASE WHEN VM.NodeID…

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.