Quick query to view the Orion (classic) views.
SELECT
v.ViewID
,v.ViewTitle
,v.ViewGroupName
,v.ViewType
,v.LimitationID
FROM Orion.Views AS v
WHERE v.ViewID IN ( 1, 2 )
I had the need to update the email action message (subject) of email actions, and also the email address fields in bulk and this is what I used to do that. Note these are both SQL queries - not SWQL
-- Update the Email Message of Actions
-- with the following query
UPDATE dbo.ActionsProperties
SET dbo.ActionsProperties.PropertyValue = replace (dbo.ActionsProperties.PropertyValue, 'oldval', 'newval')
FROM dbo.ActionsProperties
INNER JOIN dbo.Actions
ON dbo.ActionsProperties.ActionID =...
Query has NetObjectID = 1 as an example, simply replace with the node id necessary (or adjust as needed to show all data).
SELECT
n.Caption
,p.PollerID
,p.PollerType
,p.Enabled
,p.NetObjectID
FROM Orion.Pollers AS p
INNER JOIN Orion.Nodes AS n ON n.NodeID = p.NetObjectID AND p.NetObjectType = 'N' AND p.Enabled = 1
INNER JOIN Orion.DeviceStudio.PollerAssignments AS d ON d.NetObjectID = n.NodeID AND d.NetObjectType = 'N' AND d.Enabled = 1
WHERE p.NetObjectID = 1
UNION ALL
( SELECT...
This may belong in the alert lab - but it's not explicitly an alert of xml file type and is in essence a SWQL query.
Regardless I wanted to show how you can use the custom SWQL variables within the to / cc / bcc fields in email actions to send email conditionally to specific folks. This could also be a custom SQL variable also but works out better to be SWQL. Similar custom variables can also be leveraged in other alert actions such as filling in the data of a text custom property conditionally...
SELECT
n.Caption
,n.IP_Address
,n.Engine.ServerName
,n.ObjectSubType
,n.Uri AS [NodeUri]
,p1.PollerType1 AS [EnabledPoller1]
,p2.PollerType2 AS [EnabledPoller2]
,p3.PollerType3 AS [DisabledPoller3]
,p4.PollerType4 AS [DisabledPoller4]
,p1.p1Uri AS [EnabledPollerUri1]
,p2.p2Uri AS [EnabledPollerUri2]
,p3.p3Uri AS [DisabledPollerUri3]
,p4.p4Uri AS [DisabledPollerUri4]
FROM Orion.Nodes AS n
LEFT JOIN ( SELECT p.PollerID, p.PollerType AS [PollerType1], p.Enabled, p.NetObjectID...
Update 04/20/2022... re-wrote the SQL query into a SWQL query, the file to download is the SWQL query but I'll keep both versions available here for reference.
SWQL:
SELECT
n.NodeID
,n.Caption AS [DisplayName]
,n.SysName AS [Hostname]
,n.IP_Address AS [IP Address]
,n.ObjectSubType AS [Monitoring Method]
,a.ID as ApplicationID
,a.Name as [Application]
,c.ComponentID as ComponentId
,c.Name as Component
,cts.Value as TemplateCredId
,cs.[Value] as OverridenCredId
,cred.Name...
Update 04/20/2022... re-wrote the SQL query into a SWQL query, the file to download is the SWQL query but I'll keep both versions available here for reference.
SWQL:
SELECT
n.NodeID
,n.Caption AS [DisplayName]
,n.SysName AS [Hostname]
,n.IP_Address AS [IP Address]
,n.ObjectSubType AS [Monitoring Method]
,n.Community AS [Snmpv1/2c-RO]
,n.RWCommunity AS [Snmpv1/2c-RW]
,c1.Name AS [SNMPv3-RO]
,c2.Name AS [SNMPv3-RW]
,c3.Name AS [WMI-Cred]
FROM Orion.Nodes AS n
LEFT JOIN Orion...
This query will pull from both the NetObjectDownTime table, and the Events table (default to NetObjectDownTime via the ISNULL function, fallback to Events) to pull the last time node was seen up along with the most recent note.
SELECT
n.Caption
,n.DetailsUrl AS [_LinkFor_Caption]
,n.Status
,CONCAT('/NetPerfMon/images/Small-', n.StatusLED) AS [_IconFor_Caption]
,nn2.Note AS [Most Recent Note]
,TOLOCAL(ISNULL(d.DateTimeUntil, e.EventTime)) AS [Last Time Reported UP (EST)]
FROM Orion...
SELECT
n.Caption AS [NodeCaption]
,n.ObjectSubType AS [NodePollingMethod]
,n.IP_Address AS [NodeIP]
,a.IP AS [AgentIP]
,n.NodeID AS [RealNodeID]
,a.NodeId AS [AgentNodeID]
,n.SysName AS [NodeHostName]
,a.Hostname AS [AgentHostName]
,a.AgentGuid
,a.AgentId
FROM Orion.AgentManagement.Agent AS a
LEFT JOIN Orion.Nodes AS n ON n.NodeID = a.NodeId
Hi all,
This is a fairly simple script made based on a request from user aliaksei_halouka in this thread: https://thwack.solarwinds.com/product-forums/network-performance-monitor-npm/f/forum/93863/custom-widget-for-default-group-view
Create a custom query widget on your group details page and it will change based on the group you are looking at by using the ${ID} variable. (Note: this won't work as is straight in SWQL studio as the variable is only parsed when it's run on a group details...
A query to add to a custom resource.
It display by default the last 15 failover, and it can be configured to display the today failover or the last 2 days failover.
-- today failover --
-- AND tolocal(e.EventTime) > DateTrunc('day',GETDATE())
-- last 2 days failover --
-- AND tolocal(e.EventTime) < DateTrunc('day',GETDATE())
-- AND tolocal(e.EventTime) > DateTrunc('day',addday(-2,GETDATE()))
I found this on my server, so I must have set it up sometime in the past. I figured that I'd share it.
It's designed to be placed on a Node Details or Application Details page so it inherits the NodeID from the page.
