mcfobair

link is just broke or been moved... here is new link: The Basics of PowerShell (part 3) thwack.solarwinds.com/.../the-basics-of-powershell-part-3

in Run SQL query on Database server monitored with SAM Comment by mcfobair April 2022

Powershell Example of function where you must convert nodeid to xml for the verb to work: #<ArrayOfint xmlns:i="">www.w3.org/.../XMLSchema-instance" xmlns="">schemas.microsoft.com/.../ArrayOfint> function AssetInventoryItemKeyXml([int]$NodeID) { return @" <ArrayOfint xmlns='schemas.microsoft.com/.../Arrays'>…

in Add Asset Inventory to (WMI) Node Comment by mcfobair February 2022

SELECT Name, ac.Description, ObjectType -- , ac.Enabled, Frequency, Severity, NotifyEnabled , CONVERT(datetime, SWITCHOFFSET(CONVERT(datetimeoffset, LastEdit), DATENAME(TzOffset, SYSDATETIMEOFFSET()))) AS LastEdit , aa.actionid, a.Title , ap.propertyvalue , CreatedBy, Category FROM AlertConfigurations AS ac JOIN…

in Report to show configured alerts with trigger actions for specific customer nodes. Comment by mcfobair April 2020

added web report for Orion... WMI+Report.xml

in Credentials Used By WMI Nodes Comment by mcfobair April 2018

It is not for an individual support ticket. But, can and has been used as a reference for support reference. Currently, Solarwinds Orion Modules have an issue with installing the software due to a timeout on slower WAN link which we consider unsupported in Tech Support. There is a 'best effort' to manual build a local…

in SW ORION APE Folder File structure on Failed Install Comment by mcfobair January 2018

-- updated - node downtime for example 1 SELECT * FROM ( SELECT Nodes.StatusLED, Nodes.Caption, Nodes.NodeID, StartTime.Message, StartTime.EventTime AS DownEventTime, ( SELECT TOP 1 EventTime FROM Events AS EndTimeTable where EndTimeTable.EventTime >= StartTime.EventTime AND EndTimeTable.EventType = 5 AND…

in NPM Alert History Advanced SQL Reporting (Time Coalesce / Group / Events) Comment by mcfobair February 2017

mcfobair · AE · ✭✭✭✭✭

Comments