search cancel

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

book

Article ID: 189712

calendar_today

Updated On:

Products

Service Virtualization

Issue/Introduction

This 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?

Cause

N/A

Environment

All supported DevTest releases.

Resolution

Engineering provided the following query, which they say 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';