Seashore · Solutions Architect · ✭✭✭✭✭

No, if you want to test Sam, just go to the manage licenses page and on the lower right (I think) you click to start a Sam trial. Just takes a minute.

Hi, what version of Orion do you have? Looks like 2022.3 or 2022.4. If that's the case, SAM is already installed. It's just a matter of adding the license on the "license manager" web page

Sorry @"jdheer", I got no more info here

Agree and wasn't sure on how to create this but created this. Try it! The code to add to the alert trigger condition: INNER JOIN ( SELECT S.NodeID FROM Orion.AssetInventory.ServerInformation AS S WHERE (S.FirewallDomainProfile + s.FirewallPublicProfile + s.FirewallStandartProfile)<1 ) AS T ON Nodes.nodeid=T.nodeid</pre>I'm…

Not sure about the win fw status but just yesterday I was also looking to create an alert for an Asset Inventory object. I had to create a "Custom SWQL Alert" for that. Might be the same for most Asset Inventory objects. So, start with SWQL studio and try to create a query for that :-)

https://www.solarwinds.com/trust-center/security-advisories/cve-2022-3602-and-cve-2022-3786 A little more info....

Make sure the license maintenance is renewed. Otherwise you can't upgrade. Use "License Manager" under "all settings"

Hi @"makecrazy" I added the first "down count". The next is for you to add, see it as practice and "homework" :-) SELECT datata.Total_ATM_BRanches AS [Total ATM Branches] ,datata.Total_ATM_BRanches_Unmanaged AS [Unmanaged Count ATM Branches] ,datata.Total_ATM_BRanches_Down AS [Down Count ATM Branches]…

No it does not, guess you then need to query the eventlog for failover events

Did you try this one? SELECT datata.Total_ATM_BRanches AS [Total ATM Branches] ,datata.Total_ATM_BRanches_Unmanaged AS [Unmanaged Count ATM Branches] ,datata.Total_NON_ATM_BRanches AS [Total Non-ATM Branches] ,datata.Total_NON_ATM_BRanches_Unmanaged AS [Total Count Non-ATM Branches] ,datata.Total_branches AS [Total…

Hi As alerts are most of the times not "assigned" to a specific node, such a report is almost impossible to create. 

You can set up a powershell script, with a SAM component, that tests if the node can access a website on internet. Have it run once a day or so as this will likely not change often.

@"makecrazy", try this: SELECT datata.Total_ATM_BRanches AS [Total ATM Branches] ,datata.Total_ATM_BRanches_Unmanaged AS [Unmanaged Count ATM Branches] ,datata.Total_NON_ATM_BRanches AS [Total Non-ATM Branches] ,datata.Total_NON_ATM_BRanches_Unmanaged AS [Total Count Non-ATM Branches] ,datata.Total_branches AS [Total…

Hi, I would instead use a generic volume alert, and alert when the disk usage is critical. On these "G: volumes", change the threshold on the volumes themselves to 70%. Something like this: The upper part with volume types as "ram" and "virtual ram" also is volumes in orion.

Hi, as I don't have your custom properties I couldn't test this but I think it should work. SELECT datata.Total_ATM_BRanches AS [Total ATM Branches] ,datata.Total_NON_ATM_BRanches AS [Total Non-ATM Branches] ,datata.Total_branches AS [Total Branches] ,datata.City AS [City] FROM ( SELECT SUM(CASE WHEN C.ATM_Branches = 'ATM…

Hi, don't know where these fields come from but my experience is that you can use these fields like any other fields.

Hi, this is a part of a script to do that and some more: switch ($action) { ({$PSitem -eq "Ack"}) { Invoke-SwisVerb $swis Orion.AlertActive Acknowledge @(@($TargetAlertID),"$TargetAlertNote") Write-Log -Level Info -Message "Acknowledged alert id $TargetAlertID"} ({$PSitem -eq "UnAck"}) {Invoke-SwisVerb $swis…

Hi, not sure I understand exactly what you are after but this is and example of a script I use alot when I want to display several UnDP's in one table. It's not that easy to join several UnDPs together as you see but this one works for me. One one row I have added "AND S2.Status=N.CustomProperties.MyCP" and this is what i…

Hmmm If you run: SELECT TOP 100 name, description FROM Orion.APM.ApplicationTemplate with QUERYSTATS you can see the SQL query orion is asking. You then get this:SET DATEFIRST 7; SET TRANSACTION ISOLATION LEVEL READ COMMITTED; SELECT TOP (100) [T1].[Name] AS C1 , NULL AS C2 FROM dbo.APM_ApplicationTemplateStorage AS…

Yes, one part that you have to include to make the alert mechanics work internally in Orion i guess. The rest I "Inner join" to have the result I want.

I Have been thinking on this scenario before and used versions of the options @"shuth" describes. Thought of another way just now. Below is a query for "Custom SWQL Alert". It will search for a component name and alert if just 1 component of that name is up. This will actually alert on the one that is up, not the once that…

See it also at one customer. Have you also just upgraded to 2022.3?

Hi, if I'm correct here, monitors that have status "down" are direct, can't have "x out of Y", whiles monitors with status "warning or "critical" can have delayed status with "x out of y". Think it's the same all over. The http/https monitor goes down if website is not responding at all. If you create a PS script that…

Sounds like a good feature request, please add it to https://thwack.solarwinds.com/product-forums/database-performance-analyzer-dpa/i/feature-requests and I'll vote on it too

Correct, it's one installer, one msi, that installs all the modules. But only the once you have license for will be available in the GUI.

I haven't seen an integration like this before but I guess here it's more about that the alerts in Orion is not closed as they should, right? So for example. If DiskUsage>80% THEN P3 Warning If DiskUsage>90% THEN P2 Critical Solving the P2 and disk usage is below 90% the alert will be reset. Same goes for the P3, if usage…

I had this the other week, where the test button under "settings/all settings/ Manage Alert Integration Instances" showed green but when configuring the alerts, like you do here, I got the same error. Also, in the ActionsExecutionAlert.log there where errors that it could not create tickets in servicenow. In this case, the…

I couldn't find how many licenses that are left in SWQL but here is a query to show the number of licenses used and how many instances that are not licensed. Also the code tried to find the node in orion that DPA is installed on, if it is monitored by Orion and has the same name. Hope that helps. SELECT COUNT(D.IsLicensed)…

If you are talking about hiding sites from the widget "Site Details" in AppInsight for AD I would say that is not possible. It's all sites or nothing.

I understand it as you want to from java query Orion API for information about devices. I have never tested this but I can see on Github that there are some old examples on how to ask queries from java against the API. I guess you would write a normal SWQL query first, using SWQL studio to form the query. Then use the…