zackm ✭✭✭✭✭

What you are looking at is probably a UDT resource (generally speaking, any time you see the word "Port" in Solarwinds, it's referring to UDT) In SWQL, the table would be Orion.UDT.Port, or you could try to report on the "Port" object type in the web report writer. -ZackM Loop1 Systems: SolarWinds Training and Professional…

Done.

couple of thoughts: 1) Try to create 2 separate rules in your Comparison Criteria like so: ^ip vrf Liin-vrf ^! For whatever reason, NCM DOES NOT like any Regex statements that cross multiple lines... (even though that's just silly) 2) I've seen similar errors with ASA devices that are using the generic Cisco IOS Device…

you should be able to adjust the Discovery API example to fit your needs: OrionSDK/DiscoverSnmpV3Node.ps1 at master · solarwinds/OrionSDK · GitHub ref: Discovery · solarwinds/OrionSDK Wiki · GitHub

There's an Acknowledge verb in the SDK that can be leveraged for this SolarWinds Information Service v3.0 Schema Documentation -ZackM Loop1 Systems: SolarWinds Training and Professional Services * LinkedIN: Loop1 Systems * Facebook: Loop1 Systems * Twitter: @Loop1Systems

you could also try this one for a little more information in one report: Orion_Account_Audit_Loop1Systems.OrionReport - ZackM http://www.loop1systems.com

Here's a few options for you: SELECT n.Caption ,n.IP_Address ,n.SystemUptime AS [SystemUpTime_Seconds] ,ROUND( n.SystemUpTime / 86400, 2 ) AS [SystemUpTime_Days_Rounded] ,FLOOR( n.SystemUpTime / 86400 ) AS [SystemUpTime_Days_Rounded_Down] ,CEILING( n.SystemUpTime / 86400 ) AS [SystemUpTime_Days_Rounded_Up] FROM Orion.Nodes…

I'll just focus on what's on the top of my head at present. I'm sure there's a ton more that everyone else can add to the discussion. If you could pick just three things for us to fix about views, what would your three things be? * * Account Limitation Builder should be removed entirely from the server and made as a…

Add a custom property for all of your fixed volumes that you don't want to alert on and then use that as a limitation for your alerts Trigger Alert When ALL of the following apply Vendor = Windows VolumeType = FixedDisk VolumePercentUsed > 95%Trigger Alert When NONE of the following apply CustomProperty IS 'ABCXYZ'

Volume alert setup - SolarWinds Worldwide, LLC. Help and Support This is a good starting point for creating a basic volume alert. Are you asking how to limit the targetd of the alert to specific nodes, or how to pass the node name into the data of the triggered alert message? For limiting targets, you'll want to look at…

can you post both of your queries please?

you'd need to share all of the details on how you built the datasource and table columns for us to help with that question.

can you post the alert names here?

can you elaborate on what didn't work specifically? screenshots or ideas of how the report didn't meet your expectations would be helpful. on the surface, those steps look pretty accurate, so identifying exactly what went wrong would be a good start.

Cisco_Fan_States.OrionReport Try that and let me know how it works. * PLEASE NOTE * I would still recommend an upgrade to NPM 10.6 (10.7 is Beta right now and shouldn't be too much longer), but this should satisfy your request for the interim.

This is absolutely something that can be accomplished, but it will require some customization in the alert. I would recommend posting this over in the Alert Lab. Basically, you're going to need a custom SQL alert that will count the # of times a specific value is provided from the dbo.CustomPollerStatusTable view. It's not…

SELECT ..... ,CASE WHEN AVG(Availability) >= 99.995 THEN '<font color ="green">OK</font>' WHEN AVG(Availability) BETWEEN 95 AND 99.994 THEN '<font color = "yellow">WARNING</font>' WHEN AVG(Availability) < 95 THEN '<font color="red">DANGER!!!!</font>' END AS 'Status' FROM Table

My general method in a situation like that would be your 2nd notion. SQL Cluster Name/IP: ICMP node with AppInsight for SQL applied 4 member Servers: WMI/SNMP for statistical polling (no application monitoring on individual nodes) -ZackM Loop1 Systems: SolarWinds Training and Professional Services * LinkedIN: Loop1 Systems…

This should get you pointed in the right direction: select caption, max(eventtime) as 'last time down', messagefrom nodesjoin events on nodeid = networknodewhere eventtype = 1and status = 2and (eventtime > (getdate()-1) )group by caption, message - ZackM http://www.loop1systems.com

Try this: Status = 2 AND Caption LIKE '%Tunnel2 - bb dmvpn network%' -ZackM Loop1 Systems: SolarWinds Training and Professional Services * LinkedIN: Loop1 Systems * Facebook: Loop1 Systems * Twitter: @Loop1Systems

you should be able to filter on application instance type instead of instance. that will omit any of the AppInsight for SQL monitors. If you want to filter on the text `MSSQLSERVER` you would use the application name. alternatively you could also apply a custom property to the application monitors and use that to filter.…

Thanks for the message Jim. Email reply sent.

Can you post an example of the report you are starting with? -ZackM Loop1 Systems: SolarWinds Training and Professional Services * LinkedIN: Loop1 Systems * Facebook: Loop1 Systems * Twitter: @Loop1Systems

1) have you tested the query in SQL to see if the syntax is still valid? 2) if you're calling that view name in your statement at all, it should be called everywhere... try this: Nodes.LastSystemUpTimePollUtc < DATEADD(DAY,-10,GetDate()) AND Nodes.ToBeDeleted <> 1 If that still isn't working, please come back with a full…

You're close! (This is really why NPM 12 with the Web Alert Engine is going to be so dang nice) First, are you wanting to alert on RAM or Fixed Disks? I am going to assume fixed disk... try this out: (Note that I used VolumeType starts with 'Fixed'... this is because some volumes show up as 'Fixed Disk' and some show up as…

You could also make this a custom SQL alert to get past the and/or limitations: WHERE (APM_AlertsAndReportsData.ApplicationName = 'Oracle Database monitor')AND (APM_AlertsAndReportsData.ComponentName = 'Oracle User Experience Monitor')AND ((Nodes.IP_Address = 'xxx.xxx.xxx.xxx' AND ComponentStatus =…

The ObjectSubType field only has SNMP/ICMP/WMI; what you're looking for is the SNMPVersion field. Valid entries are 0 (ICMP/WMI), 1, 2, and 3 Try this: SELECT NodeID ,Caption ,IP_Address ,Vendor ,MachineType ,SNMPVersion ,SNMPV3Username ,SNMPV3Context ,SNMPV3PrivMethod ,SNMPV3PrivKey ,SNMPV3PrivKeyIsPwd ,SNMPV3AuthMethod…

SELECT n.caption as 'DEVICE', d.name as 'SCHEDULED TASK', r.description as 'LAST RUN RESULT'FROM APM_WstmTask_Detail dJOIN Nodes n ON n.nodeid=d.nodeidJOIN APM_WstmTaskResult r ON r.resultid=d.lastrunresultWHERE r.resultid != 0 -ZackM Loop1 Systems: SolarWinds Training and Professional Services * LinkedIN: Loop1 Systems *…

you can definitely do this via script/PowerShell. depending on the complexity of the ask, you may even look at the alert action to update custom properties and build this inside of orion itself. for powershell; it would be something similar to this, set the a scheduled task, I'd imagine (sorry for the brevity, I'm on…

It sounds like you're looking for a report on UDT data. My buddy (and fellow MVP) nickzourdos​ is a UDT wizard and might have something similar lying around already. Disclaimer: If you do not have UDT, the challenge intensifies. So let us know if that's the case please.