I am trying to prepare a VS HitCount report for a particular month to show adoption of VS across organisation, but there are nulls values in column "COUNTS_DATE" under VSE_METRICS_TXN_COUNTS. This is happening with only few services and others has proper dates.
Due to "null" in DATE column, I am unable to report exact service hit count for that particular month.
Is there any solution to ensure system captures service hit DATE?
Please, take a look at the link below:
There are some interesting details on the VSE Metrics table.
Hope it helps.
Hi Heloisa, Thanks for sharing the link, Based on the given information it seems it keeps only historical value instead of each days count.
I am wondering is there a way to keep daily count so that it helps to report accurately.
I performed some testing on my side and could verify the following behavior:. When you deploy a new service to the VSE, nothing gets updated in the VSE _METRICS_TXN_COUNT table.. When you send a transaction to the VSM, and the VSM is new - there are no rows with this same VSM name, two rows will be created, one row will contain COUNTS_DATE=null and the other row will contain the date you are exercising that VSM.. When you exercise a VSM on two different days, you will probably have 3 rows for that same service, one for each date and an additional row with COUNTS_DATE=null.. In the tests I performed, this last row (COUNTS_DATE=null) contains the total hit count for that VSM.
The Server Console is documented and you can take the information from there to provide to others - by way of a screenshot, with DevTest 8.5, there is not an export option.https://docops.ca.com/devtest-solutions/8-5/en/using/using-ca-service-virtualization/using-the-workstation-and-console-with-ca-service-virtualization/virtualizing-a-service/vse-metrics
With DevTest 10.1 you are able to access the VSE Metrics in DevTest Portal and export the metrics to a PDF file.
The database design is not part of the documented DEVTEST tool. We cannot prevent you using it but the database design may change from release to release.