bobmarley ✭✭✭✭✭

Nice work! @sum_giais 

So you want to subtract 857 from 879 (= 22) and then alert if the result is greater than lets say 15? This will be a little tricky as @"sum_giais" explained, you can't change the predefined initial Select statement in the alert. Typically you would do the subtraction within the Select statement. Anyone have any ideas?

CASE WHEN condition1 THEN result1 WHEN condition2 THEN result2 WHEN conditionN THEN resultN ELSE result END;

Here is the query for a KPI widget to show total number of AP's up/down. Here is the UP widget, change the Status to 2 for a Down Widget, 3 for Warning, etc Here is a nice guide: A Step-by-Step Guide to Building Modern Dashboards on the Orion® Platform – SolarWinds Lab Episode #93 SELECT COUNT (Status) as APStatus FROM…

The data is located in these tables Here is an example query for Thin AP Status SELECT TOP 10 DisplayName, IPAddress, Clients, Status ,CASE WHEN Status = 1 THEN '/Orion/images/StatusIcons/Small-Up.gif' WHEN Status = 2 THEN '/Orion/images/StatusIcons/Small-Down.gif' WHEN Status = 3 THEN…

I would try the suggestion @borgan made first. If that doesn't get you what you need then you could create an alert using SWQL. There is more than one choice here so make sure you are getting the correct one Then finish up the alert above. If you want to see what the original query looked like in the alert you already…

I looked at how we set it up and here you go A powershell script runs daily as a scheduled task. The script uses the Invoke-Sqlcmd -Query to get the data. Once retrieved it is manipulated in powershell then written out like this: Out-File -FilePath 'C:\inetpub\SolarWinds\Orion\MyOrionData.txt' Then we set up a Custom HTML…

I was thinking the same, it probably would be served better using a different tool. Perhaps run a powershell script via Windows task scheduler, have the script massage the data in any manner you wish and save it as a .csv or even as a .html into your Orion Web directory and display it as a Custom HTML resource. That I have…

Try this How to Create a report from a SWQL Query - Forum - Network Performance Monitor (NPM) - THWACK (solarwinds.com) In the line that states 'Select Query Type SWQL' select SQL instead of SWQL There are several other posts out there that also go over this in case this one isn't enough. Good Luck!

I use powershell and an alert action to do my deletes, here is how if you are interested. You will need to have the SDK installed. Alert action - run a script C:\Windows\System32\WindowsPowerShell\v1.0\powershell.exe -Command "C:\scripts\deletefromalertaction.ps1 '${N=SwisEntity;M=Caption}'" You will need to modify the…

I did add the reset action and it worked great! Also another thing to note, in my system these are ran infrequently as in once a day. Mostly to catch custom properties that were missed when field techs forget to fill them in. Didn't want to run them on the default 5 minutes or whatever your system is set at as they didn't…

@stuartd @sum_giais Great points! I'm going to try the reset suggestion this morning :)

My first thought is you could be taking in more messages than it is designed for. Here is some info on scaling. How to Improve Your Experience With Log Analyzer and Orion Log Viewer - Newsroom - Log Analyzer - THWACK - SolarWinds Community Another may be the order the rules are processed. Sometimes throwing out the 'trash'…

If you are managing the Wifi Controllers then you already have an inventory stored you didn't know about :) Try looking in these tables Below is a query you can try as well. SELECT IPAddress, DisplayName FROM Orion.Wireless.AccessPoints Where Available LIKE '1'

I would start by reading up on the Software Development Kit Download the SolarWinds Orion SDK and start using SWQL

Should you decide to try the Custom HTML widget there is a security setting you may need to adjust. Read up on it before changing it so you know the security risk. You will need to access to the Advanced Configuration page which is this URL, replacing the words in caps with your server name.…

Just trying to think out of the box here, if you own SAM you could run your SQL query from there against your external database and retrieve the results. Those results would be available to use for your dashboard resource. There is also the Custom HTML option which you could make as pretty as you wish in the HTML code. We…

We occasionally will do 'Lunch and Learn' events at our company and the system owners will cover the basics of using the system. These are not just for Solarwinds but several of the systems in the company. We record them so any one that comes in new or anyone that needs a refresher can go back and watch them. That has…

Try running C:\Program Files (x86)\SolarWinds\Orion\SNMPWALK.exe from your Orion server and verify in the MIB that the data is present on the node you are trying to poll and it is the correct OID. 

Here is a query you can use and the instructions on how to make a report are in the link. This query will pull in the most recent 100 traps, adjust it as needed. https://thwack.solarwinds.com/product-forums/network-performance-monitor-npm/f/forum/95393/how-to-create-a-report-from-a-swql-query SELECT TOP 100…

Yes, if you have pollers that are collecting the expiration date you can add them into the SQL report. Just cut/paste the lines that have 'YOURCUSTOMPOLLERNAME' in them and make sure you add a comma to them at the end except for the very last line. You can add as many as you need to the report.

There is a table you can access via SWQL named Orion.Traps Yes you can create views of the traps that are received from that table.

I used a SQL Query for mine and made a report out of it. You will need to fill in the information for your system where shown in all caps below. Make sure you fill in YOURCUSTOMPOLLERNAME in both places and it needs to exactly match your UDP Poller name. The YOURFRIENDLYNAME can be anything you wish. In the Where clause…

This should get you started Select NodeID, IP_Address, Caption, status, Network_Family FROM Orion.NodesCustomProperties cp INNER JOIN Orion.nodes nd on cp.NodeID = nd.NodeID Where Network_Family Like '%YourFamilyNameHere%' Order by Status DESC

This is how I use that action. Here is an example for a script action I use to delete nodes. In the External program area you will need this info. In this case I'm using the variable for the Caption of the node but you can adjust to your on needs. Also make sure the path to the powershell scripts on your Orion server is…

On your Orion server there is an SNMPWalk program that you can use to walk the MIB tree of the device. I usually do the MIB walk then search through the results to see if there is a match for the item and then if there is one create a custom poller for it. Give that a try. 

What kind of deployment issues are you getting stuck on?

User rights are pretty well displayed in the Manage Accounts screen. However, some things to know about accounts. An individual account settings will over-ride a Window Group account and in the Windows Group accounts if a user is a member of more than one Group then they will receive whatever the first match is top down in…

What type of event? If it is an Audit Event those are available in the Trigger Condition section. Can you show an example? 

I would take a copy of the database, place the copy into Azure and then spin up a new Windows server in Azure and run the installer. When you get the the database portion simply attach to the existing database you copied over. Any reports, alerts, etc that you have set up should now also appear in Azure. Once everything is…