can i use python/powershell list all alert and alert action?
Which table should I query.
Thanks
can i use python/powershell list all alert and alert action?
Which table should I query.
Thanks
Yes. I recommend reading Home · solarwinds/OrionSDK Wiki · GitHub to get oriented and Alerts · solarwinds/OrionSDK Wiki · GitHub for guidance on how the alert information is structured.
HI.
$swis = Connect-Swis -Hostname orion_ip -UserName USERNAME -Password "PASSWORD"
#create the connection to Swis
Add-PSSnapin swissnapin
Get-SwisData $swis "SELECT Name AS AlertName, AlertMessage, AlertRefID, aa.Description, ObjectType, ac.Enabled, aa.Description,CategoryType,a.ActionTypeID,a.Title
FROM Orion.AlertConfigurations ac
INNER JOIN Orion.ActionsAssignments aa on aa.ParentID = ac.AlertID
INNER JOIN Orion.Actions A ON A.ActionID = aa.ActionID
WHERE AC.Enabled = 1 "
Thank you your script, i though have a seperate table to store, no idea to join the table
Thanks
SolarWinds solutions are rooted in our deep connection to our user base in the THWACK® online community. More than 195,000 members are here to solve problems, share technology and best practices, and directly contribute to our product development process.