VS Metrics Query to fetch Transaction Counts over a given time period

Products

• Service Virtualization

Issue/Introduction

The table VSE_METRICS_TXN_COUNTS does not have date ranges for the transactions. However, the portal report section does. What is the query needed to fetch the Transaction Counts from the backend tables, for a given time period?

Environment

All supported DevTest releases.

Cause

N/A

Resolution

The following query should give you the transaction counts for a given range. 

SELECT * FROM VSE_METRICS_TXN_COUNTS tc WHERE tc.COUNTS_DATE IS NOT NULL AND tc.COUNTS_DATE >= AND tc.COUNTS_DATE <= ;

For example, to fetch the details from 22-Apr-2020 to 24-Apr-2020:
SELECT * FROM VSE_METRICS_TXN_COUNTS tc WHERE tc.COUNTS_DATE IS NOT NULL AND tc.COUNTS_DATE >= '2020-04-22' AND tc.COUNTS_DATE <= '2020-04-24';