SQL Query to retrieve information about artifact

Products

• CA Release Automation - Release Operations Center (Nolio)
• CA Release Automation - DataManagement Server (Nolio)

Issue/Introduction

How to get some information about artifacts using a SQL Query ?

Environment

Release Automation - All Versions

Resolution

Here is an example of SQL Query which returns some information about artifacts :

SELECT a.APP_NAME "Application Name", t.name "Artifact Type", d.name "Artifact Definition",  ra.artifact_version "Artifact Version", p.name "Artifact Package"
FROM artifact_type t
INNER JOIN artifact_definition d ON d.artifactType_id=t.id
LEFT JOIN applications a ON a.id=d.applicationId
LEFT JOIN rc_artifacts ra ON ra.artifactDefinition=d.id
LEFT JOIN artifact_version_in_package ap ON ap.version_id=ra.id
LEFT JOIN artifact_package p ON ap.artifactPackage_id=p.id

Example :