Service Virtualization

Expand all | Collapse all

Enterprise Dashboard alerting

Jump to Best Answer
  • 1.  Enterprise Dashboard alerting

    Posted 01-12-2020 09:51 PM
    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!


  • 2.  RE: Enterprise Dashboard alerting
    Best Answer

    Posted 01-13-2020 07:55 AM
    ​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