bobmarley ✭✭✭✭✭

Here is a script I use sometimes, it grabs a list of nodes from a file. I didn't take the time to convert the time to local time so take note in the script. You will need to have the Solarwinds SDK installed to use it which is available at GitHub. CLS Add-PSSnapin SwisSnapin $swis = Connect-Swis -host…

Check that the accounts related to the reports didn't get the password reset to blank on them. That has usually been the case for me. 

I tried to message you back but received and error Have you tried using component name instead if number? It is in the SAM template here and matched what I have in the alert You could also temporarily remove the IP address as the component will only trigger for nodes that have the SAM application assigned to them. Is email…

It looks like you have a space in here "Orion.NPM. Interfaces' between NPM and Interfaces, try removing it. 

Thanks for sharing, I ran across this and it was slowing down my SWQL Studio and Powershell scripts as well. Made the changes and they are running well again. 

This is how I usually set them up. Put your component name where I have DNS User Experience. You could also add Warning as another condition if you like.

Or try this which is just adding LastChange from the table. select i.FullName as Interface, i.DetailsUrl as [_linkfor_Interface], '/Orion/images/StatusIcons/Small-' + StatusIcon as [_iconfor_Interface], TOLOCAL (Lastchange) AS DownTime from orion.npm.Interfaces i left join orion.AlertSuppression sup on (sup.entityuri =…

This is from an older Thwack post it may be a good start. --https://thwack.solarwinds.com/products/network-performance-monitor-npm/f/forum/95022/report-for-interface-down-for-more-than-31-days SELECT I.Caption as [Interface Name] , I.Node.Caption as [Node Name] , tolocal(I.LastChange) as [Last Change Time]…

Assuming you own SAM, one way to do it is to pull up the node you want to monitor the service on and click here Then find the process you want to monitor and click here Then finish filling out the rest of the wizard. Below is the documentation. SAM Administrator Guide (solarwinds.com)

The query below should link up the tables for you. Included the Nodes table as well in case you need any info from there. SELECT top 1000 [Interfaces].FullName AS InterfaceFullName -- from the Orion.NPM.Interfaces table , [Interfaces].PhysicalAddress AS InterfacePhysicalAddress -- from the Orion.NPM.Interfaces table ,…

Uptime Report By Device Type - Report Lab - The Orion Platform - THWACK (solarwinds.com)

You can do some basic SWQL by using this URL and replacing YOURORIONSERVER with your server name. https://YOURORINSERVER/Orion/Admin/swis.aspx The URL to get SWQL Studio is here GitHub - solarwinds/OrionSDK: SDK for the SolarWinds Orion platform, including tools, documentation, and samples in PowerShell, C#, Go, Perl, and…

Do you own SAM? I used to do something similar using SAM and a SQL Query against our SQL clusters to determine which server was primary and secondary and which data center they were running in. Perhaps you can do some scripting via SAM using SQL or Powershell. Another thing that may be possible is if there is something in…

The widget name is this: Below are a couple query's you can use, depending on which select you remark out it will either give you the numbers or a list. ---------------------------------------------------------- --Count of Up Nodes SELECT Count(Caption) AS Caption --SELECT Caption , StatusDescription -- List of Down Nodes…

I upgraded our second system last week and all went fine, no issues. 

Try this. Go to https://radar.weather.gov/ and then zoom into the area you are trying to focus on. then grab the really long URL from the browser. As @"cnorborg" suggested place it in an Iframe as shown below. Replace the URL in red the line below with the really long URL of the map zoomed into your area. You can adjust…

I agree with both @HerrDoktor and @KMSigma.SWI . We used to do similar dashboards using a Map and an image as a background. We had a very large string of jobs that the mainframe would process nightly and if any of the jobs ran late or failed the overall process failed. We drew the whole job stream out and the scheduling…

Try looking into the events table and then the alerts table and see if you are seeing what you expect. Events: SELECT TOP 2000 TOLOCAL(EventTime) AS LocalEventTime, Message, EventType, NetworkNode, NetObjectID FROM Orion.Events Order by EventTime DESC Alerts: SELECT TOP 500 TOLOCAL ([AH].TimeStamp) as Timestamp ,…

You may try the query below to see if you have any alert actions that are failing. Sometimes you may find an incorrect address or the email server rejecting the email. SELECT [History].AlertObjects.AlertConfigurations.Name , [History].AlertObjects.AlertConfigurations.DisplayName , TOLOCAL ([History].TimeStamp) AS TimeStamp…

See if this gets you any closer, the Inner Join was removed as @"mesverrum" suggested. There are some edits you will need to make in the comments. SELECT [Nodes].NodeName AS [Node Name], '/Orion/images/StatusIcons/Small-' + StatusIcon AS [_IconFor_Node Name], DetailsUrl AS [_LinkFor_Node Name],Nodes.CustomProperties._Group…

Welcome to the community!

You would need to set up your own custom pollers using ifInDiscards (.1.3.6.1.2.1.2.2.1.13) and ifOutDiscards (.1.3.6.1.2.1.2.2.1.19) If it's a few interfaces it may be ok to do, but if it's a lot I would script it via command line and do a compare each time the script runs. Here are the OID's if you need them Consider…

Try this. SELECT [Nodes].IPAddress ,[Nodes].ObjectSubType ,[Nodes].Caption ,[Nodes].StatusDescription ,[Nodes].Volumes.Caption AS [Volume] ,[Nodes].Volumes.StatusDescription AS [VolumeStatusDescription] ,[Nodes].Interfaces.Name AS [InterfaceName] ,[Nodes].Interfaces.StatusDescription AS [InterfaceStatusDescription]…

Take a look here, some good resources Basic HTML and CSS in Alerts (solarwinds.com) 

Here is a set 

A lot of the info is in the Orion.Accounts table, this can be put directly into a report. SELECT TOP 1000 AccountID, Enabled, AllowNodeManagement, AllowMapManagement, AllowOrionMapsManagement, AllowUploadImagesToOrionMaps, AllowAdmin, CanClearEvents, AllowReportManagement, AllowAlertManagement, AllowCustomize,…

When I upgraded last week to 2024.1 using My Deployment - Updates the main poller downloaded all the files and updated perfectly. When the APE's were updating concurrently, they got about 30 percent through the process and the install exited saying it was complete only a couple minutes into the installation. They usually…

To do it via powershell use this OrionSDK/Samples/PowerShell/Update.Captions.ps1 at master · solarwinds/OrionSDK · GitHub Also see this for doing it using SQL (+) Bulk Node Name/Caption Change - Forum - Network Performance Monitor (NPM) - THWACK (solarwinds.com)

If you Google 'execute PowerShell script from ServiceNow' there are several articles that go into detail on how it is done.

We are doing the same thing exactly as you described and it has been working well. We use alert actions to fill in missing information on some of the custom properties and once a month run a report listing all of them, audit the report, then re-upload it in custom properties. As for cut/paste you could always paste into…