Comments
-
Can this do the trick? SELECT A.Name AS [Alert Name] ,A.LastEdit ,A.CreatedBy ,MAX(AO.LastTriggeredDateTime) AS [Last Triggered] FROM Orion.AlertConfigurations AS A LEFT OUTER JOIN Orion.AlertObjects AS AO ON A.AlertID=AO.AlertID WHERE A.Enabled=TRUE GROUP BY A.Name,a.LastEdit,a.CreatedBy ORDER BY [Last Triggered] EDIT:…
-
Hi, as I wrote before there is no such connection between alert rule and what components that alert can trigger. By joining in the AlertObjects table that you have in your query for applications we can see what Objects HAS PREVIOUSLY triggered on this alert rule but not all objects that CAN trigger on this alert. But if…
-
SELECT ac.AlertID AS [AlertRuleID] ,ac.Name as [AlertRuleName] FROM Orion.AlertConfigurations AS ac WHERE ac.ObjectType = 'APM: Component' --AC.ObjectType = 'APM: Application' AND ac.Enabled = 1 Order by ac.Name Hi, this SWQL code gives you all alert rules that looks for components. You can also just change the lines 7 and…
-
Hi If I understand your wish correct you don't get what you want from your query and that is not how orion works. As I understand you want a report on each alert rule that can trigger alerts on each application (and also components later on). But there are no such mapping in Orion. You are joining in [AlertObjects] to get…
-
Hi I thought I got this issue on two of our servers. WMI started failing on those servers just as the patch got installed and server rebooted. But another reboot "fixed" the issue. So no need to add the reg hack, just a reboot for us.
-
If you are using a normal "SQL User Experience Monitor" component, the output has to be one single integer. So in your case the [cntr_value] column has to be the first column in the output. optionally you can have a second column as output, that is like a "message" output and not something that you alert on or create…
-
A normal account within orion can be used to get information from the Orion API.
-
Hi Not directly but in some way.... In alerts you can see the SWQL code for the alert trigger: Click on the arrow to the right and then "show SWQL". That code can be used as a starting point for a datasource in a reports. But probably you would want to add more columns in the datasource for your report. The other way…
-
When you authenticate against SQL you can either use a Windows/ActiveDirectory account OR a SQL account(account built into SQL). That's how SQL works. When you choose "auto detect" Orion tries both methods to see if any of them works. So you probably have a proper windows account as it works with auto and windows. Why does…
-
Yes you can create a new view there (all settings/manage views) or on the All settings menu you might have "Manage dashboards". Goes to the same place. Links can be done in many ways. You can add menu items (all settings/customize menu bars), add a "use links" widget to any other view, add a "custom html" widget and add a…
-
The views are used for all things. For example the "node details view" are the same for all nodes. The "Group Details" view are the same view for all groups. For nodes and applications there are a way of creating specific "node details views" per node type but for groups there are no such function. You will have to create…
-
Hi I think KPI widget always need a number as input source. So not text.
-
You should be able to see it in the audit log. If you just search for all audit logs on that node, do you see anything then?
-
You can also go to "Settings/All Settings/SAM Settings/Manage templates". There you have a tab called "Assigned Application Monitors" where you can see, edit and delete all assigned monitors. The once that take up a license.
-
I would take out info about the node, status and polling method from orion. Export it to excel and compare it there with the data you got about the nodes.
-
No @"bmgarthwaite" there are no templates there. I suggest you create a map, take a screenshot of that and send it out with some instructions on how to create the site specific maps.
-
@"axg4437" To alert if a database goes either "Down" or goes "critical", create an alert that looks something like this: Clicking on the arrow that I circled above you can then click on "Show SWQL". There you can verify that you got the same query as I got: SELECT E0.[Uri], E0.[DisplayName] FROM Orion.APM.SqlDatabase AS E0…
-
No, Network Atlas maps are not "compatible" with new Orion Maps. The Maps has to be recreated.
-
Non-admins can't see the audit page in GUI and now can't access it via SWQL. Above query is using that audit table.
-
How about this? SELECT N.Caption AS [Node] ,N.StatusDescription AS [Status] ,N.DetailsUrl AS [_LinkFor_Node] FROM Orion.Nodes as N WHERE N.Caption LIKE '%SQL%' Adjust the WHERE part as needed
-
Adjust below line in the query to get data from the dates you are after: DS.TimeStamp>ADDDAY(-7,GETUTCDATE()) --Set days back to calculate avg availability Currently its "from now and 7 days back". Including the hours that has passed today. You can also hardcode date and time there if you want. Example:…
-
Remove "unplugged/Offline": Just add "WHERE SA.Databases.status!=10" at the end,making it look like this: SELECT SA.Node.Caption AS [Server] ,SA.InstanceName AS [SQL Instance] ,SA.Databases.DisplayName AS [Database] ,SA.Databases.StatusDescription AS [Status] ,B.Availability AS [AVG Availability last 7 days] FROM…
-
SELECT SA.Node.Caption AS [Server] ,SA.InstanceName AS [SQL Instance] ,SA.Databases.DisplayName AS [Database] ,SA.Databases.StatusDescription AS [Status] ,B.Availability AS [AVG Availability last 7 days] FROM Orion.APM.SqlServerApplication AS SA INNER JOIN ( SELECT A.DatabaseID ,AVG(A.Av*100) AS Availability --…
-
There are some settings involved here that only solarwinds support can change, according to this KB: https://documentation.solarwinds.com/en/success_center/la/content/lm/la-securesyslogsettingsexternal.htm Maybe you need to check with them
-
Did you send the alert email as "html" and not "plain text"?
-
Do you want availability per database? Not per instance? In that report we might be able to add a column named for example "Availability last 7 days". But there we have the following statuses, which ones are considered "available"?
-
If it says "MSSQLSERVER" it's a default instance. Not a named instance. Availability can be debated for long, available for who and with what performance and functionality. What is availability for you? What component under AppInsight for SQL do you want to measure on? Just if the service is running?
-
SQL is not aware of what groups or limitations a user has. The query has to be in SWQL for limitations to be applied
-
Hi How about below SWQL (SolarWinds Query Language) query? Can be used as a datasource in a report etc. Gives you availability for last 7 days for each instance using AppInsight for SQL: SELECT S.Node.Caption AS [ServerName] ,S.InstanceName ,S.ProductVersion ,ROUND(AVG(S.ApplicationStatus.PercentAvailability),1) AS…
-
Sorry for taking some time. Below query is now testes and works fine for me. The alert trigger object should be "Groups" for the group-id variable included in the query to be correct. Use below in a html formatted email and you will get each item on a separate row. ${SQL: SELECT REPLACE(Replace((SELECT(SELECT M.FullName +…
