zackm ✭✭✭✭✭

The first point I would make is that the Alert History is only kept as long as the Event Log (default 30 days). So, I'm going to keep that in consideration on these queries. If you extend your event log retention, you can get a "previous month" addition here, but without knowing your environment and how many events it…

That's not a query. Try this instead: SELECT Nodes.NodeID, Nodes.Caption FROM Nodes WHERE Nodes.LastSystemUpTimePollUtc < DATEADD(DAY,-10,GetDate()) AND Nodes.ToBeDeleted <> 1

try running this in the database manager, if you get results, then your query is solid and you need to look at other reasons why this alert isn't firing SELECT Caption, VolumePercentUsed FROM VolumesWHERE ( (Volumes.VolumeType = 'Fixed Disk') AND (100-NullIf(VolumePercentUsed,-2) < 60) AND(Nodes.WindowsServersv3 = 1) )

just to be clear, you ran just the SQL query right? not the whole report definition? EDIT: Run the one below; the original has some custom properties you probably don't have in your environment (Might have to play with the parenthesis a bit, I haven't tested this, just glancing during lunch. )…

What modules do you own?

oh, yeah if you're looking for the last month you're going to lose granularity after 30 days by default. My initial report was looking at the last 7 days if you want to do something like that, try this: First, extend your hourly retention interval in your settings to 31 days then, try this query: --Here we are declaring a…

You might open a ticket with SolarWinds then. To my knowledge, once you install WPM on your main polling engine, it then adds the references to those tables in the report writer. Maybe try running the configuration wizard to rebuild first? (this will result in a 10-20 minute outage on your SolarWinds application, just FYI)

Nope. Just standard failover clustering. We keep it as simple as possible.

Put a 'HAVING' clause on the end of that. HAVING (Transact-SQL)

There's a builtin Syslog search under the "Alerts & Activity" tab in the newer Orion sites. (The same tab exists in the older sites, though I cannot remember the navigation steps) For an actual report, you can use the web report builder and create a dynamic query for Syslogs and just create a custom table and select the…

Fair enough. I would think that a problem like this would be due to the dependency of the child to the parent. It almost seems as though the parent has 'Unreachable' somewhere in relation to the child, which might be required for dependencies to work, but would break your query as is. I would suggest opening a ticket and…

That is from the InterfaceTraffic tables (there are 3). Those are polled according to the interface statistics polling cycle.

Trust me, I get that. Have you talked to anyone about the new Remote Office Pollers? My understanding is that this new licensing is made for small remote sites in istuations just like this with a price point that is a little easier to handle than the full price of an Additional Poller. If you're interested, feel free to…

If you already have SNMP queries working from SolarWinds to the nodes, then you just need to edit the way that SolarWinds gathers availability metrics on those specific devices. Settings > Manage Nodes > Select a Device > List Resources > Status & Response Time > SNMP Otherwise, if you want to use Additional Pollers, there…

I would first check the devices for compatibility with UDT. Past that I would say a trouble ticket with SolarWinds Tech Support would be the fastest resolution if there is indeed a problem with your environment. For peace of mind, UDT was designed to offer L2 mapping, so what you are experiencing doesn't "feel" right (of…

One of my clients had this issue a few months back and opened a ticket with SolarWinds, who responded with this SQL script (which assumes that you want to remove all Windows devices from UDT) DELETE FROM UDT_NodeCapability WHERE Capability IN ('2','3') AND WHERE NodeID IN (SELECT NodeID FROM NodesData WHERE Vendor =…

You can check you polling engine capacity by going to Settings > Polling Engines from the website. For each polling engine, there will be a 'Polling Rate', this will be a good representation of your server's capacity for polling at the current intervals. (There is a more detailed explanation of this metric under the 'Learn…

you would want to copy the Guest account settings and then update the Views highlighted below to be whatever view you want the user to see. Furthermore, to fully limit the account, you can make a menu bar with only a single link to the view you want the user to have. Assign that under the "Home Tab Menu Bar" setting below,…

That's some good stuff! Thanks for sharing, I would mention though that this is still limited to thresholds per a poller type, and not per poller. e.g.; Threshold for RemoteTemp NOT threshold for RemoteTemp on NodeA and a different threshold for RemoteTemp on NodeB So, while this definitely addresses item 7 in my list; it…

Sounds like you're right on track! I would also mention that, if you aren't already, you can use the custom properties to really route your emails like so: Create a custom property called something like 'AlertContact' and fill it with up to 10 email addresses, separated by comma. In your To:, CC:, and/or BCC: fields on…

Try uploading the file here: http://thwack.solarwinds.com/document/upload.jspa?containerType=14&containerID=2019

Try this: select ac.Name as 'Alert Name' ,ac.AlertMessage as 'Alert Message' ,ac.[Description] as 'Alert Description' ,cast((select replace(replace(ac.[Trigger], '<', '<'),'>','>')) as xml) as 'Trigger XML' ,cast((select replace(replace(ac.[Reset], '<', '<'),'>','>')) as xml) as 'Reset XML' ,a.title as 'ActionTitle'…

I don't have the internal ticket #, but I know that this was confirmed as a bug for me by Tech Support back on March 6th: Thank you for contacting SolarWinds Technical Support. My name is <redacted> and I will be working on this case with you. The first screenshot you sent appears to be a known bug. The web console will…

Hi Brett! It looks like you've got some great questions about how to utilize SQL and SWQL syntax in order to provide a more robust and customized experience with the SolarWinds Orion product suite. You might want to take a look at our Public Training 301 course where we deep-dive into not only the basics of SQL…

Just to confirm; under 'manage nodes', if you search for, and then select the checkbox next to a node in question, then go to 'edit settings' you should see a portion of the settings where your SNMP options are. Fort, comfi that the device is indeed setup for SNMP polling, not ICMP. Then, please click the 'test' button…

try this as a custom table resource: selectdateadd(mi, datediff(mi, getutcdate(), getdate()), timegeneratedutc) as 'Time Stamp',computername as 'Domain Controller',LEFT(TBL.source, 100) + '...' source,LEFT(TBL.dest, CHARINDEX('Additional', TBL.dest)-1) as 'User Name',REVERSE(LEFT(REVERSE(TBL.dest), CHARINDEX(':',…

Gotta love those vendors Re: Volume Type "Network Disk" versus "NetworkDisk"

That actually looks accurate. Try this, it will add the current status to your query: SELECT E0.[NodeID] ,E0.[Caption] ,E0.[IPAddress] ,E0.[CustomProperties].[DeviceRole] ,E0.[StatusDescription] FROM Orion.Nodes AS E0 WHERE ( E0.[CustomProperties].[DeviceRole] = 'WAN' ) The conditional logic looks correct. I think you may…

Sorry, now that I look at this again, I gave you the wrong query. Try this: SELECT Interfaces.CarrierName FROM Interfaces JOIN Nodes ON Nodes.NodeID=Interfaces.NodeID WHERE Nodes.NodeID=${NodeID} AND Interfaces._____ = ???

Interesting. Can you post either the SQL query or a screenshot of your report criteria?