Seashore · Solutions Architect · ✭✭✭✭✭

@"christopher.t.jones123" i can't resist a challange :-) Created below line that takes out all members from the group "test" and write them with a "</BR>" after each. So if you html-format your email you get them one at each line. One trick with the SQL-variables is that the query has to be in one line. No line-breaks, so…

Ghaaa, why does thwack shorten my links.... .... Finally, all the link text....

Haven't tested this myself but the wiki has below as an example: https://localhost:17778/SolarWinds/InformationService/v3/Json/Invoke/Metadata.Entity/GetAliases HTTP/1.1 With your path I guess that would be something like this:…

As far as I know you can't with permissions give just the monitoring account read access to secondary replicas. It's a setting in the AG setup. If you set the secondary replicas to "readable" then Orion can read those databases as normal and they will not be unknown anymore. If that is a situation you want is up to you and…

I use a normal SQL component in SAM to run below query to get AG sync status: select g.name INTO #AGStatus from sys.dm_hadr_availability_group_states S inner join sys.availability_groups G on s.group_id=G.group_id Where synchronization_health<2 AND s.primary_recovery_health=1 IF (Select COUNT(name) from #AGStatus)>0 BEGIN…

Would love to have AppInsight for SQL "AG aware". As you say, most databases that are not primary on that node goes "unknown" now. Now I use custom templates to monitor and alert on the services and AG replication status. If you want monitoring on specific databases you have to set up a new node in orion pointing on the…

SRM does not give you that capability, to search and bulk edit volumes. I have searched some also but haven't found any good solution through the API or GUI. Closest is through the database that is discussed here: thwack.solarwinds.com/.../orion-default-thresholds-bulk-change

Maybe I should test my code myself before sending it over.... Another try, wrapped the above query in another select statement to get rid of the strange xml-named-columns ${SQL: SELECT(SELECT M.FullName + ' (' + S.StatusName + ')' +', ' FROM ContainerMemberSnapshots AS M INNER JOIN StatusInfo AS S on M.[Status]=S.StatusId…

Ahh, my bad. Orion does not like if you have "unnamed columns" so we have to add a name for the column: ${SQL: SELECT M.FullName + ' (' + S.StatusName + ')' +', ' AS [N] FROM ContainerMemberSnapshots AS M INNER JOIN StatusInfo AS S on M.[Status]=S.StatusId WHERE status != 0 AND status != 1 AND status != 9 AND status != 27…

But that does not look like a Custom QUERY widget. The edit page should look like this:

Query got A LOT mot complicated as the table with statistics does not look at the speed at all. Just the total count. So this report will only look at the current usage. No history available. Hope I got it right this time :-)…

Aha, I see, let me think a bit more.....

What kind of error do you get? If the same as on your posted picture above you are using "custom table widget". Use "custom query widget" instead. The path to icons are relative to the web installation so drive letter should not matter.

Hi, like what you trying to create but the query need some changes. Below query should give you what you want: SELECT M.FullName + ' (' + S.StatusName + ')' +', ' FROM ContainerMemberSnapshots AS M INNER JOIN StatusInfo AS S on M.[Status]=S.StatusId WHERE status != 0 AND status != 1 AND status != 9 AND status != 27 AND…

@"CourtesyIT", Something like this? Add a custom query widget and below code: SELECT n.Vendor, COUNT (CASE n.Status WHEN '1' THEN 1 else NULL end) AS UP, COUNT (CASE n.Status WHEN '2' THEN 1 else NULL end) AS DOWN, COUNT (CASE n.Status WHEN '3' THEN 1 else NULL end) AS WARNING, COUNT (CASE n.Status WHEN '9' THEN 1 else…

See https://thwack.solarwinds.com/product-forums/the-orion-platform/f/report-lab/94764/udt-port-capacity-grouped-by-port-types 

Is it something like this you want? In that case you can download and import the xml-report below. [View:/cfs-file/__key/communityserver-discussions-components-files/46/UDT_2B00_Ports_2B00_Used.xml:640:480]

select count(n.status) +(select count(a.status) AS AP from Orion.Packages.Wireless.AccessPoints as a where (a.status =2)) as total from orion.nodes as N where (n.status =2) Does this work for you?

The deep down technical answer to why it behaves like this here and only on this table: The SQL table [AssetInventory_Software] containing this info is NOT case sensitive. So I ran the query in SWQL studio and there it's case sensitive. In SWQL studio you can add "With querystats" to see the actual SQL query behind this:…

In what database do you see these accounts? A db you are monitoring or the DPA repository database?

WinRM is only used for Application Related polling. Not node related polling. Between WMI and Agent I don't think there are any differences except that the Agent CAN get more info but does not by default. I have not seen a complete list of what is polled.

Ok, then that might be the issue. Latest HF requires the latest SWQL or you get an error on logging in looking something like that.

Great, please add it here as well: thwack.solarwinds.com/.../application-monitor-templates

Just one thing to make sure, if you have the latest hotfixes for Orion you also need the latest SWQL studio - do you have the latest SWQL studio? Also, are your AD users added as groups or individual accounts? I see this behavior at other places with group accounts. 

In the best of worlds below would work. Test, if it doesn't we have to convert above report query to an alert query.

https://thwack.solarwinds.com/product-forums/the-orion-platform/b/news/posts/wwwo

I guess you could write a PS script to get out the values, using a power shell component inststead, but it will not be as pretty as normal service monitoring. 

Hi, don't think there is. You need to adjust this on each place (been there done that...). Pick the one most commonly used and adjust where needed.

Hi, you are correct. Apply template and change the fields that need to be changed. No variables on the instance field. Say that you on many SQL servers have several instances. You could at the template add a couple of components with different instances. Maybe disable all but one and when applied enable the once you need.…

Hi If the query you got from your DBA is just for ONE database, you have to apply this to every database on every instance you want to monitor. BUT you don't have to create new templates for every instance. You can "Override" the fields for instance and database when applied. Setting the vales that applies for that…