zackm ✭✭✭✭✭

Yeah, if you make node groups, then any problem with a member of that group would cause an alteration of the overall group status. It's really just two sides of the same coin. I personally prefer to make more alert definitions and less groups. Groups ABSOLUTELY have a time/place in Orion, and some would argue that your…

try this one out (SQL) SELECT ac.Name 'Alert Name' ,ao.EntityCaption 'Alert Object' ,ac.ObjectType 'Object Type',ao.RelatedNodeCaption 'Related Node' ,DATEADD(mi,DATEDIFF(mi,GETUTCDATE(),GETDATE()),aa.TriggeredDateTime) 'Alert Trigger Time (Local)' FROM AlertConfigurations ac FULL OUTER JOIN…

Unfortunately; the newly updated schema page is erroring on that entity so I cannot tell you if there's been an update on this: http://solarwinds.github.io/OrionSDK/schema/Orion.Netflow.cbQoSConfigurationDetails.html That being said, if you download the SDK and connect to your Orion instance via SWQL Studio; you should be…

tdanner​ would be the source of truth here, but I think you are correct in that 12.0.1 does not have the Orion.HardwareHealth verb you need.

to be clear; this was run using SWQL studio on the polling engine, or from a remote location? test it local to your polling engine; the idea is to eliminate the risk of network vs application in this scenario. if it runs on the polling engine without issue, but fails to run from a remote location, then it's almost…

I'm not sure, I do not have anything in there for "Top 10". Off the top of my head, I would suspect that the ones missing do not have any instances where the MaxRoundTripTime was > 300

Try adding some parens to group your where clauses logically: WHERE ( (Nodes.MachineType = 'IBM PowerPC') AND (Volumes.VolumeType = 'Fixed Disk') AND ((NullIf(VolumeSize,-2)-NullIf(VolumeSpaceUsed,-2)) <= 1073741824) AND ( (Volumes.VolumePercentUsed >= 84) AND (Volumes.VolumePercentUsed < 94) ) AND ( (Volumes.FullName <>…

so, the problem right in front of us is on lines 11 and 15 You cannot alias a table name (line 15) and then call the full table name in your select statement (line 11). Since the SELECT statement runs after the FROM statement in the order of operations, once you create an alias, the original table name ceases to exist for…

I'm not quite clear on your request. The queries I gave you will give a list of every alert that was triggered and how many times. Are you asking for a list of every single alert that was triggered and the associated objects? If so, try this: SELECT TimeStamp 'Alert Time' ,Name 'Alert Name' ,ObjectType 'Object Type'…

I would edit it a little (but that's just me, I think you'd still get the same results with what you have) <tomAto vs tomAHHto> INNER JOIN Nodes on Interfaces.NodeID = Nodes.NodeID WHERE Nodes.Caption NOT LIKE 'NOC-DC2-1KV%' AND Nodes.DeviceType <> 'Server' AND Interfaces.Caption NOT LIKE '%Ethernet%' AND (…

i and n are just variables used to tell the script which table to look into. You could just as easily use the following script: SELECTNodes.Caption, Nodes.IP_Address, Interfaces.InterfaceName, Interfaces.StatusFROM NodesLEFT JOIN InterfacesON Nodes.nodeID=Interfaces.nodeIDWHERE Interfaces.AdminStatus =…

I unfortunately do not have any VoIP equipment that I can test this on. Have you tried creating a new UnDP? I am really not sure why your CompressedRowID entries are all NULL. In my lab, all of them reflect the integers in the RowID column. This is a new column (CompressedRowID) in the database. I am thinking at the very…

If you look at your Event Type filter, you've got a typo Also, as discussed prior; with the EventType filter sitting in the lower portion of your query, the parens are not being applied correctly in your And/Or block. I would revisit the post I put up a few replies above and try and duplicate that screenshot exactly…

The DNS entries are generally gathered with a reverse-lookup. Can you check the PTRs for those IP addresses on your DNS server to make sure there isn't an inaccuracy or conflict? -ZackM Loop1 Systems: SolarWinds Training and Professional Services * LinkedIN: Loop1 Systems * Facebook: Loop1 Systems * Twitter: @Loop1Systems

For Future Reference: Triggered Alert History - Last 30 Days

That works perfectly! Is it safe to assume that the HardwareInfoID is for Platform 2017.x and later then?

OK, so you have 2 options: 1) as njoylif‌ mentioned, you can just add your rate limitation to your current Custom SQL: SELECT CustomPollerStatusTable.CustomPollerAssignmentID, CustomPollerStatusTable.CompressedRowID, CustomPollerStatusTable.FullLabelFROM CustomPollerStatusTableWHERE CustomPollerAssignmentID =…

do you have both the old and new database still? it isn't a pretty thing, but you can pull a report from both in SQL that you can play with in Excel. If the new nodes are still polling with the same IP as the old nodes; you could actually run a simplified report to show the deltas for NPM, SAM, and NCM. IPAM is similarly…

There are no dynamic custom properties. One of the primary purposes of custom properties is to allow administrators to make dynamic queries for groups of objects in the system. However, there are several options for assigning a custom property after you have created it. * In the workflow of creating a custom property, the…

do you need it for pools or virtual servers?

How long between the 11:19 event and the email alert? And no, you don't have to remove that custom property, that is fine.

OMG. How I wish I had you working with me when I was still in corporate culture. Then my boss would have heard the same rants from TWO employees!

Great point!!! Updated: join events on events.netobjectid = APM_AlertsAndReportsData.ComponentID --match your message here where events.message like 'netpermon event log:%'--only look at component monitor eventsand events.netobjecttype = 'AM' --look over the last 1 day and events.eventtime > (getdate()-1) group by…

That's a SQL query, you have the option in that screenshot set to SWQL

If you create a custom property, it would be very simple to pull it into the report as such: SELECTn.Caption 'Device',n.IP_Address 'IP Address',c.Name 'Connection Profile',p.LoginStatus 'Login Status',p.DeviceTemplate 'Device Template'--Change this next line to match whatever Custom Property name you end up…

try this instead; you were close, but the format of ISNULL is more like this: ISNULL(column,'valueToUseIfNull') 'columnAlias'... ${SQL:SELECT ISNULL(Caption,'Not Found') FROM NodesData LEFT JOIN NodeIPAddresses on NodesData.NodeID=NodeIPAddresses.NodeID WHERE (NodeIPAddresses.IPAddress='${N=SwisEntity;M=NeighborIP}' OR…

Try this: SELECT n.NodeID ,n.Caption as Device ,n.IP_Address as 'IP Address' ,n.Vendor ,n.MachineType as Model ,e.ServerName as 'Polling Engine'FROM Nodes nJOIN Engines e on n.engineid = n.engineidORDER BY e.servername, n.vendor -ZackM Loop1 Systems: SolarWinds Training and Professional Services * LinkedIN: Loop1 Systems *…

Sort of. With a bit of editing, your query would return all Servers that are missing C or D, and C and D. Server1 - C: and D: Server2 - D: Server3 - Server4 - C: Your query would return Servers 2, 3, and 4. The way I read it, the request was for a return of only Servers 2 and 4. That being said, I would personally think…

You can also delete the instance from the database (that's what is causing this error). Backup Your Database First!!! I don't have any configuration wizards running to test the syntax, but to find the issue you can try a query like this: SELECT * FROM Settings WHERE SettingID LIKE 'CW-ActiveInstance-%' If that returns any…

With the extent of man-hours to be spent on creating a custom resource like that, I would defer to an upgrade to 10.6 if it were me. I'm positive this could be done in SQL, but without the data in my DB, I'm not much help on testing and creating it for you.