Enterprise Dashboard alerting

[devtools]

We are in the process of upgrading to version 10.5 and heard there may be alerting functionality in this version.  Specifically, we would like to create thresholds for power user concurrency, transaction count, number of VSE's and number of services deployed to each VSE and send automated alerts when our predefined thresholds are reached. Is anything like this available with SV version 10.5?  If so, can someone point me to the procedures for setting it up?

Thanks!

[Tom Shokite]

​Hi,
One way to do it would be to create and run (scheduled) a Workstation "SQL Database Execution (JDBC)" test script.  We do that for capturing the number of transactions and virtual services running.  Here is a sample of one of the scripts we use.  We use Microsoft SQL database but you can change it if you have a different database:
SELECT [VS_NAME]
      ,sum([TOTAL_COUNT]) as totalcounts
FROM [LISANEW].[dbo].[VSE_METRICS_TXN_COUNTS]
where year(counts_date)=2020 and month(counts_date)=01
group by VS_NAME
order by VS_NAME

good luck