Statistics for the number of releases in CARA by application and environment

Products

• CA Release Automation - Release Operations Center (Nolio)

Issue/Introduction

How to gather statistics for the number of releases in CARA by application and environment.

Environment

NOLIO RELEASE AUTOMATION 6.8

Resolution

select d.application as app_id, 
       a.app_name,
       d.environment as env_id, 
       e.name as env_name,
       count(*) as rel_qty
from deployment_statistic d
     inner join deployment_statistic_period dsp on d.period = dsp.id and dsp.name = 'DAILY'
     inner join deployment_statistic_category dsc on d.category = dsc.id and ((dsc.name = 'SUCCESSFUL_DEPLOYMENT_COUNT') or (dsc.name = 'SUCCESSFUL_ROLLBACK_DEPLOYMENT_COUNT'))     
     inner join applications a on d.application = a.id
     inner join environments e on d.environment = e.id
where d.statistic_date > '2020-01-01'
group by a.app_name, d.application, d.environment, e.name