Seashore · Solutions Architect · ✭✭✭✭✭

You could start here : /Orion/APM/Admin/MonitorLibrary/AppFinder/SelectMonitorType.aspx Component wizard, to search for the proper performance counters

With SAM and Performance Counters. You can start with "PerMon" on the windows server itself to find out the values you are after, then add a "Performance Counter Monitor" component to your SAM template.

I'd be happy to read it.

Ohh, but you will not see the qty in the output as Orion can't handle that in the alert rule. If you want to see the qty just runt the part between the (). The rest is for the query to work as a "custom alert query".

Could be because you don't have any interfaces matching the filters. Try remove the line "HAVING count...." and see if you get any results back

Sure, can this be what you are after? Same method as above, inner join the actual trigger query. Written in SQL, not SWQL. SELECT Interfaces.FullName, Interfaces.InterfaceID FROM Interfaces INNER JOIN ( SELECT count (E.EventID) AS qty ,I.InterfaceID FROM Interfaces AS I INNER JOIN [events] AS E ON i.InterfaceID =…

Hi As Orion alredy know how many things are joined there is no need here to add a manual join. You can but that will just be extra work. So we can jump from table [Request] to [site] to [application] to [node] and there get caption as servername. Like this: SELECT TOP 100 R.URLStem ,R.AverageElapsedTime…

Hi Here is a template we use to see that the SQL Availability Groups are in sync and cluster service is running. You might need to change the SQL instance the SQL query is running against. [View:/cfs-file/__key/communityserver-discussions-components-files/194/SQL-Basic-AG.apm_2D00_template:640:480]

Hi Can this be what you are after? SELECT TOP 100 R.URLStem ,R.AverageElapsedTime ,R.RecentRequestDate ,R.Site.Name ,R.DetailsUrl FROM Orion.APM.IIS.Request AS R WHERE R.RecentRequestDate>GETUTCDATE()-1 ORDER BY R.AverageElapsedTime desc

Hi Best practice is really depending on the size of your installation. In a small one sure you can have Orion and SQL on the same server but if you grow in load I would recommend splitting them up. Yes you can set the recovery mode to simple, thinkt it's actually recommended unless you use SQL Availability groups. I don't…

On the SCP page, https://support.solarwinds.com/solarwinds-certified-professional-program, there are study guides for all certifications. Some are better than others... I recommend people to start with NPM and then SAM, but if you already got those it's more up to what other modules you got. If no others the design and…

This query is querying the table "Orion.Nodes" with the line "from orion.nodes n". And as SWQL knows how this table is connected to "Orion.NodesCustomProperties" we can just add the column right away in the upper part with "N.CustomProperties.City" (for the custom property "city" as example). Full example: SELECT n.Caption…

Hi, Even though you provided good information it's still impossible to say. Those other 70+ databases could be huge or tiny. The size of them and the current load on SQL will decide what you need to do. Around 70 db's and probably some of them have some size, I would say that 128 GB RAM is probably a bit to little as it…

Hi First of all, most Orion modules share the same database. So NCM and IPAM will end up in the same database. So no new database if you install IPAM in an existing Orion installation. Performance between standard and enterprise SQL does not differ that much in it self. Enterprise CAN USER more hardware than standard and…

https://support.solarwinds.com/SuccessCenter/s/article/Configure-Orion-to-unmanage-items-on-a-scheduled-basis?language=en_US Use the "Unmanage scheduling utility" on the orion server to schedule when nodes should be unmanaged. 

There is a built in template in sam called "Log Parser (Powershell)" that does just that, stores values in a temp file on the Orion server. Think this is the main part of that: $t = (Get-Childitem env:temp).value $file_path = "$t\$usage-$filename-$position" if ( Test-Path $file_path ) { $known_rows = get-content $file_path…

Hi Looks like those alerts triggered more than a year ago and not today. Looking at "active time", thats more than a year. The alerts should reset if the interfaces are up. Look at the alert rule and the tab "Reset condition". Can it be something there that caused the alert not to reset? Sometimes I have seen that alerts…

Strange, and @"peacga9"you are logged in with admin priv.? 

Doing a http post for every trap can be alot of extra traffic and threads if there are alot of traps. If you have alot of traps I don't think this is a very good idea. If it's possible with just a medium amount of traps? Theoretically maybe but probably not practially. I guess you could set something up within Orion SQL to…

Hi The email address is within alot of other data in Orion.ReportJobs.ActionsData and not easy to find. So a query like the one below will give you that info. (SWQL Code) SELECT R.Name ,R.Description ,R.LastRun ,R.ReportTitles ,R.FrequencyTitle FROM Orion.ReportJobs AS R WHERE R.ActionsData LIKE '%person.name@company.com%'…

You probably don't need that argument as you don't use it in your script. Execution mode; Local means on the orion server. Remote is on the target node. In your case remote is probably what you want. If you enable debugging on the sam application you created you can find a better log file at…

Or below to get the current time. SELECT TOP 1 GETDATE() AS [DatetTime] FROM Orion.Nodes Put it in a custom query widget. Not very pretty but works...

That will work; install Orion on new server but don't run config wizard. Move database to new SQL. Run config wizard on new orion server. But, there are some extra things you need to do. Run some SQL scripts after moving the db and reset the license store. Look at this page for more info:…

Didn't find out how to do that in SWQL but in SQL you can use below script: select caption, ip_address, MachineType, SNMPVersion ,c.Name as [credential name] ,cp.Value as [username] from Nodes n inner join NodeSettings NS on N.NodeID=NS.NodeID inner join [Credential] as c on NS.Settingvalue=C.id and…

This SWQL should sort that out. Gives the "shortname" if a '.' is found, otherwise the whole name. SELECT CASE WHEN CharIndex('.',N.Caption)>0 THEN SubString(N.caption,0,CHARINDEX('.',N.Caption)) ELSE N.Caption END AS T FROM Orion.Nodes AS N WHERE N.NodeID=10 Where it says "WHERE N.NodeID=10" you need to change the "10" to…

As far as I know there are no external calendars that Orion support out of the box. But with the API you can build any integration yourself. Here are some examples: https://github.com/solarwinds/OrionSDK/wiki/Alerts#orionalertsuppression…

If you would like to use SWQL below query will list all nodes that has a specific application assigned to it: ('WebTest' is the name of the application we are looking for in these examples. Change to what you need to look for.) SELECT A.Name AS [Application] ,A.Node.Caption AS [Server Name] FROM Orion.APM.Application AS A…

Hi, yes these OIDs are for traps. Not anything you can poll. The device will not answer on those OIDs. You can set the Cisco device to send traps to Orion and then in orion configure it to alert if traps with these OIDs are received.…

Can it be that the script returns the value as a string instead of an INT? Can you try to force it or convert it to an INT?

Choose "Image/video/file" from insert menu, then you can click on "upload" to choose a file. Or you can just paste a picture in the text-area where you write the text for a message