COUNTLIST in CLI window

Products

• CA Workload Automation DE - Business Agents (dSeries)
• CA Workload Automation DE
• DSERIES- SERVER
• CA Workload Automation DE - System Agent (dSeries)
• CA Workload Automation DE - Scheduler (dSeries)

Issue/Introduction

I am looking for the SQL queries that are used by COUNTLIST used in CLI window of CAWA  for the below items.

I tried to get the counts for eight of the below items but remaining three, one I could not find the calendar info and other two Application and Report design counts are not matching.

Agents 
Alerts 
Application 
Calendar 
Events 
Forecasts
Groups
Javascripts
Report Designs
Resources
Users

Could you please share me the queries?

Environment

Release : 12.2

Component : CA WORKLOAD AUTOMATION DE (DSERIES)

Resolution

Query the ESP_AMS_DF table for the artifacts counts. For example;

SELECT COUNT(*) FROM ESP_AMS_DF WHERE ARTIFACTTYPE = 'AGENT'

SELECT COUNT(*) FROM ESP_AMS_DF WHERE ARTIFACTTYPE = 'APPLICATION'

SELECT COUNT(*) FROM ESP_AMS_DF WHERE ARTIFACTTYPE = 'CALENDAR'