Join the #BuildWithBuildAgent Challenge! Get recognized, earn exclusive swag, and inspire the ServiceNow Community with what you can build using Build Agent.  Join the Challenge.

How to count the number of transactions per day

JackieZhang
Tera Contributor


We have exceeded the number of 100k transactions, we need to count the number of each transaction

3 REPLIES 3

kaushal_snow
Giga Sage

Hi @JackieZhang ,

 

Please check in syslog_transaction table for accurate daily transaction counts (and other metrics). Use GlideAggregate or GlideQuery to count/group by date...

 

 

Thanks and Regards,
Kaushal Kumar Jha - ServiceNow Consultant - Lets connect on Linkedin: https://www.linkedin.com/in/kaushalkrjha/

All the translations in syslog_transaction table  require consumption of transitionsthe and not just API? 

JackieZhang
Tera Contributor

Is there anybody can answer my question?