m-milligan ✭✭✭✭✭

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

Ich hätte erwartet, dass es in diesem Beitrag um einen Mann namens Weniger ging, der viel Stress verursachte.

Thanks for explaining how that works.

One question. Your query includes the line: WHERE AA.TemplateID = 330 What's the name/function of the template (which components) with ID 330 in your system? In my installation, the template with ID 330 is a custom app monitor for PeopleSoft, which isn't useful for this report If you can share or describe your template, I…

Here's a view I created for our NOC. They really liked the "bullseye" charts from another application, so I wrote some Javascript to re-create them for Solarwinds groups.

We've had a similar problem since upgrading to SAM 6.2.4. Solarwinds support says this is a known issue and that it's fixed in SAM 6.3.

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?

We're using a custom Universal Device Poller (UnDP) to get DHCP subnet utilization for Infoblox. Here's the XML for the poller. Copy and paste into a new file, then import into Solarwinds using the Universal Device Poller application. <?xml version="1.0" encoding="utf-8"?> <CustomPollers version="9.0"> <CustomPoller…

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…