Need to extract Perforce changelists information from Bamboo

Gregory Kremer

We need to extract information on all Perforce changelists in Bamboo. Atlassian Tech Support advised us that there is no such out-of-the-box feature exists. Has anyone done such report? I'd greatly appreciate any help/suggestion.

robhit

Hi Gregory,

Thanks for your question!

Let me know if the below query helps you go fetch the required result:

&nbsp;&nbsp;&nbsp;&nbsp;d.title<span>&nbsp;</span>AS 'Project Name',&nbsp;&nbsp;&nbsp;&nbsp;c.title<span>&nbsp;</span>AS 'Build Plan Name',&nbsp;&nbsp;&nbsp;&nbsp;c.full_key<span>&nbsp;</span>AS 'Plan Full Key',&nbsp;&nbsp;&nbsp;&nbsp;CASE&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;WHEN c.build_type =<span>&nbsp;</span>'CHAIN_BRANCH' THEN 'Branch Plan'&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;ELSE 'Main Plan'&nbsp;&nbsp;&nbsp;&nbsp;END AS 'Plan Type',&nbsp;&nbsp;&nbsp;&nbsp;a.build_state,&nbsp;&nbsp;&nbsp;&nbsp;c.UPDATED_DATE<span>&nbsp;</span>AS 'build_updated_date',&nbsp;&nbsp;&nbsp;&nbsp;a.build_number,&nbsp;&nbsp;&nbsp;&nbsp;e.COMMIT_FILE_NAME,&nbsp;&nbsp;&nbsp;&nbsp;g.CHANGESET_ID<span>&nbsp;</span>AS 'CHANGESET',&nbsp;&nbsp;&nbsp;&nbsp;f.COMMIT_DATE,&nbsp;&nbsp;&nbsp;&nbsp;f.COMMIT_COMMENT_CLOB<span>&nbsp;</span>AS 'Commit_Comment',&nbsp;&nbsp;&nbsp;&nbsp;CASE&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;WHEN h.LINKED_USER_NAME<span>&nbsp;</span>IS NULL THEN 'Author is not linked with a user in Bamboo'&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;ELSE h.LINKED_USER_NAME&nbsp;&nbsp;&nbsp;&nbsp;END AS 'Linked_Author_Name',&nbsp;&nbsp;&nbsp;&nbsp;h.AUTHOR_NAME,&nbsp;&nbsp;&nbsp;&nbsp;h.AUTHOR_EMAILFROM&nbsp;&nbsp;&nbsp;&nbsp;buildresultsummary a,&nbsp;&nbsp;&nbsp;&nbsp;build c,&nbsp;&nbsp;&nbsp;&nbsp;project d,&nbsp;&nbsp;&nbsp;&nbsp;commit_files e,&nbsp;&nbsp;&nbsp;&nbsp;user_commit f,&nbsp;&nbsp;&nbsp;&nbsp;repository_changeset g,&nbsp;&nbsp;&nbsp;&nbsp;author hWHERE&nbsp;&nbsp;&nbsp;&nbsp;c.build_type<span>&nbsp;</span>IN ('CHAIN' ,<span>&nbsp;</span>'CHAIN_BRANCH')&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;AND c.full_key = a.build_key&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;AND c.project_id = d.project_id&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;AND e.commit_id = f.commit_id&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;AND f.REPOSITORY_CHANGESET_ID = g.REPOSITORY_CHANGESET_ID&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;AND f.COMMIT_REVISION = g.CHANGESET_ID&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;AND g.BUILDRESULTSUMMARY_ID = a.BUILDRESULTSUMMARY_ID&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;AND h.AUTHOR_ID = f.AUTHOR_IDORDER BY d.title , c.full_key , build_updated_date<span>&nbsp;</span>DESC;SELECT

Thanks,

Robhit