topic Re: Blue prism CLI - export a list of .bpreleases of a package from a given database in Product Forum

Blue prism CLI - export a list of .bpreleases of a package from a given database

OlgaDiyakonova — Fri, 14 May 2021 08:40:47 GMT

Hi all,
is there a way to retrieve a list of .bpreleases of a specific package present in a given database?
I'm just trying to use the /report command, still running, and I still can't figure out if it's the right way.

Thank you for your help,
Olga

Re: Blue prism CLI - export a list of .bpreleases of a package from a given database

Ben.Lyons1 — Fri, 14 May 2021 10:22:34 GMT

Hi Olga,

I do something similar, but in 2 stages. First I find the releases for a given time frame, then get the respective release info, as follows:

SELECT BPAAuditEvents.eventdatetime
      ,BPAAuditEvents.sNarrative 'Action Summary'
      ,BPAUser.username 'User'
  FROM [BPAAuditEvents]
  Left Join BPAProcess On BPAAuditEvents.gTgtProcID = BPAProcess.processid
  Left Join BPAUser On BPAAuditEvents.gSrcUserID = BPAUser.userid
  Where sCode = 'E004' AND
BPAAuditEvents.eventdatetime > '2021/05/13 11:21:14' AND
BPAAuditEvents.eventdatetime < '2021/05/14 11:21:20'

Then run

SELECT BPAPackage.id
      ,BPAPackage.name 'Package Name'
      ,BPAPackage.description
	  ,BPAProcess.name 'Process / Object Name'
  FROM [BPAPackage]
  Left Join BPAPackageProcess On BPAPackage.id = BPAPackageProcess.packageid
  Left Join BPAProcess On BPAPackageProcess.processid = BPAProcess.processid
  Where BPAPackage.name = '$$$$'

Replace the $$$$ with the package name, that can be retrieved from the output of the first query with a calc stage:
Replace(Trim(Mid([Releases List.Action Summary], InStr([Releases List.Action Summary], "from the package")+17,100)),"'","")

You can probably tailor this more specific to your needs.

let me know how it goes.

Re: Blue prism CLI - export a list of .bpreleases of a package from a given database

OlgaDiyakonova — Fri, 14 May 2021 10:35:13 GMT

Hi Ben,
Thank you so much! So you're talking about querying the DB directly, and I think this will be the right way...
I was actually trying to bypass the DB query in order to integrate this control into an already existing batch that imports releases.
I think I should still learn more about these operations..

I'll let you know if I will opt for trying your solution instead!