bobmarley ✭✭✭✭✭

This is fantastic, I was in the middle of creating UDP's for these at my company.

I take that back its loading now

You all may need to take a look at it this AM. It was working yesterday,

I have been using Copilot/Powershell/SWQL Studio like three super hero's together combining power :) anyone else been working on your super powers?

—Nodes SELECT 'Unmanaged' as [Maintenance] , n.Caption AS [Node], n.Status, n.ChildStatus , tostring(tolocal(n.UnManageFrom)) AS [From] , case when n.UnManageUntil is null or n.UnManageUntil = '9999-01-01 00:00:00' then 'Not set' else tostring(tolocal(n.UnManageUntil)) end AS [Until] , case when n.UnManageUntil is null or…

SELECT n.NodeID, n.Caption, n.IP_Address, n.UnManaged, n.UnManageFrom, n.UnManageUntil, r.ReasonFROM Orion.Nodes nLEFT OUTER JOIN( SELECT x.NetworkNode, x.Reason FROM ( SELECT e.NetworkNode, e.TimeLoggedUtc, a.ArgsValue AS Reason FROM Orion.AuditingEvents e INNER JOIN Orion.AuditingArguments a ON a.AuditEventID =…

Another war to approach it is to create a custom property and alert as shown below and then you can set the warning threshold for each node individually. Then create a second alert and custom property for critical.

This powershell will post all Active Alerts that have occurred in the past 24 hours. I hope this example helps.

======================================================Active SolarWinds Alerts - Last 24 Hours======================================================$swis = Connect-Swis -Host "YOURSOLARWINDSHOSTNAME" -Trusted $swql = @" SELECT aa.AlertActiveID, ac.Name AS AlertName, aa.TriggeredDateTime, ao.EntityCaption,…

My only experience so far has been using Copilot and it is the greatest thing since the Commodor 64 came out.

I believe this was fixed in 2025.4.2?

This is for failed logins. --Failed Logins SELECT TOP 100 AuditEventID,ToLocal(TimeLoggedUtc)AS LocalTime,--AccountID,CASE WHEN AccountID LIKE 'Domain\user1' THEN 'Users Real Name1' WHEN AccountID LIKE 'Domain\user2' THEN 'Users Real Name2' WHEN AccountID LIKE 'Domain\user3' THEN 'Users Real Name3' ELSE AccountIDEND AS…

If you want to use a custom SWQL Resource you can use this query. FIlling in the user names is optional in the case statement. --Users that have logged in in the last 24 hours SELECT tolocal(TimeLoggedUtc) AS [Last Login],CASE WHEN AccountID LIKE 'Domain\User1' THEN 'Joe Smith' WHEN AccountID LIKE 'Domain\User2' THEN…

Looking forward to the event

Will be glad to participate

Thank you for sharing, a lot of great content.

Looking forward to seeing this progress.

Great discussion. Thanks for sharing.

If this is for the health of your SolarWinds environment then you are in luck as a lot of the health test are built in if you have administrator access. From the main page got to Settings then My Deployment then the Deployment Health tab

The opposite query, nodes using ICMP SELECT n.NodeID, n.Caption, n.IPAddressFROM Orion.Nodes nSELECT n.NodeID, n.Caption, n.IPAddressFROM Orion.Nodes nWHERE n.NodeID NOT IN ( SELECT NetObjectID FROM Orion.Pollers WHERE PollerType IN ( 'N.Status.SNMP', 'N.ResponseTime.SNMP' ))ORDER BY n.Caption

I don't have any of that node type to test but try this: SELECT n.NodeID, n.Caption, n.IPAddress, p.PollerTypeFROM Orion.Nodes nJOIN Orion.Pollers p ON p.NetObjectID = n.NodeIDWHERE p.PollerType IN ( 'N.Status.SNMP', 'N.ResponseTime.SNMP')ORDER BY n.Caption

We built a new server cluster with new names and the DBA copied the databases over.

Happy Holidays to Everyone!

There are several automations that we have set up to similar tasks. In one system, the system that runs all of the timeclocks and scheduling. The timeclock engineers don't use SolarWinds, they use the Scheduling systems software to put clocks in and out of service. We were asked to manage the clocks in SolarWinds so have a…

One of our security tools does a great job of finding devices. We scripted our own job that compares the security tools discovery against the Node and Custom Properties tables in the SolarWinds DB and give us a report of missing nodes. We can then use the scripts that @HerrDoktor spoke of to import the nodes based on the…

Great accomplishment! Happy holidays!

We also did the upgrade and the only issue I remember is needing to run the config wizard on one polling engine.

When I was working retail the cold warehouse workers would spit on the phone as they drove by on a forklift and it would become a huge icy mess. That happened about four times. When I came I would take the phone off the wall and drop it on the floor and leave, leaving a blank plate. Around the fifth time the workers…

Well, from my perspective if I'm in San Francisco, I'm going to find out how fast one of those Lime (or whatever) rental scooters will go down the hills! Then maybe the hospital or conference afterwards, we will see how it goes!

Try looking it up in an AI engine, in Co-Pilot I am able to generate the code needed in both powershell and python and it may at least get you to the correct tables for the data.