Which ActionPacks Are We Using?

Products

• CA Release Automation - Release Operations Center (Nolio)

Issue/Introduction

With the recent announcement, regarding certain named action packs being discontinued, you may wonder if you are using any of those action packs. This article includes some database queries (written for MS SQLServer) to assist you in identifying action packs being used. 

 

Note:
This specific announcement is only related to the named action packs. There are no changes to any of the Plugins (ex: Jenkins, TeamCity, etc) at this time.

Environment

Release : 6.7

Component : CA RELEASE AUTOMATION ACTION PACK

 

Resolution

This query will give a break down of all the %jenkins% actions you use with number of times used. 

SELECT AP.ID AS ACTION_PACK_ID,
       AP.NAME AS ACTION_PACK_NAME,
       AP.DESCRIPTION AS ACTION_PACK_DESCRIPTION,
       ACI.ID AS ACTION_ID, 
       ACI.CLASS_NAME AS ACTION_CLASS_NAME,
       COUNT(AI.ID) AS USAGE
  FROM ACTION_INSTANCES AI
 INNER JOIN ACTION_CLASS_INFO ACI
    ON ACI.ID = AI.ACTIONINFOID
  LEFT OUTER JOIN ACTION_PACKS AP
    ON AP.ID = ACI.ACTIONPACKID
WHERE ACI.CLASS_NAME like '%jenkins%'
GROUP BY AP.ID, AP.NAME, AP.DESCRIPTION, ACI.ID, ACI.CLASS_NAME
ORDER BY AP.NAME, AP.ID, ACI.CLASS_NAME, ACI.ID 

 

Alter the where clause to identify other potential action packs being used. 

 

Lastly, this query will list all of the action packs that have been installed:

select name, file_name, version from action_packs order by file_name;