topic RE: How can I find license details from BP DB? in University Forum

How can I find license details from BP DB?

JasmeetSingh — Fri, 15 Jul 2022 18:14:00 GMT

Hi folks,
I've bunch of questions
1. How can I fetch total licenses available and used in BP DB?
2. How can I fetch license expiry date, name and license type or category?
3. How can I relate in which license the machine is running?

------------------------------
Jasmeet Singh
------------------------------

RE: How can I find license details from BP DB?

PabloSarabia — Sat, 16 Jul 2022 10:53:00 GMT

Hi @Jasmeet Singh

I test this in my local Data Base and I found the way to get the info.

As I told you yesterday, the table name in the Data Base is BPALicense and the field is licensekey, but this info is not encrypet, is in Base64.

If you decode the info, you will get an xml with all the info:

<?xml version="1.0" encoding="UTF-8"?>
<license created="2019-05-30 02:33:05.261867">
<type>enterprise</type>
<licensee>company name</licensee>
<starts>2019-05-29</starts>
<expires>2022-05-23</expires>
<maxconcurrentsessions>##</maxconcurrentsessions>
<graceperiod>5</graceperiod>
<salesorderid/>
<licenserequestid>##</licenserequestid>
<source/>
<Signature xmlns="http://www.w3.org/2000/09/xmldsig#">
<SignedInfo>
<CanonicalizationMethod Algorithm="http://www.w3.org/TR/2001/REC-xml-c14n-20010315"/>
<SignatureMethod Algorithm="http://www.w3.org/2000/09/xmldsig#rsa-sha1"/>
<Reference URI="">
<Transforms>
<Transform Algorithm="http://www.w3.org/2000/09/xmldsig#enveloped-signature"/>
</Transforms>
<DigestMethod Algorithm="http://www.w3.org/2000/09/xmldsig#sha1"/>
<DigestValue>##</DigestValue>
</Reference>
</SignedInfo>
<SignatureValue>##</SignatureValue>
</Signature>
</license>

You have all the info here.

Hope this helps you! And if this solves the problem, remember mark it as best answer!

See you in the Community, bye 🙂

------------------------------
Pablo Sarabia
Solution Manager & Architect
Altamira Assets Management
Madrid
------------------------------

RE: How can I find license details from BP DB?

JasmeetSingh — Mon, 18 Jul 2022 17:23:00 GMT

Thanks @PabloSarabia that's what I wanted, one question more can we get no. of used licenses for a day, suppose if we have concurrent license is 5 then how can we get used out of 5?

------------------------------
Jasmeet Singh
------------------------------

RE: How can I find license details from BP DB?

PabloSarabia — Tue, 19 Jul 2022 05:29:00 GMT

Hi @Jasmeet Singh

I have been looking for this but I didn't find anything 😞

Cause in the Resources table there is no info about the license that is using or similar...

In general, you want to know how much of your licence you are using, that's correct?

See you in the Community, bye 🙂

------------------------------
Pablo Sarabia
Solution Manager & Architect
Altamira Assets Management
Madrid
------------------------------

RE: How can I find license details from BP DB?

JasmeetSingh — Tue, 19 Jul 2022 07:33:00 GMT

Hi @PabloSarabia

Yes that's what I'm looking for, how much license are using currently.

------------------------------
Jasmeet Singh
------------------------------

RE: How can I find license details from BP DB?

Neel1 — Tue, 19 Jul 2022 10:15:00 GMT

From GUI perspective - in Home/Dashboard screen of BP- you can find the this information.

------------------------------
Neeraj Kumar
Technical Architect
------------------------------

RE: How can I find license details from BP DB?

shashank.kumar280 — Tue, 19 Jul 2022 10:57:00 GMT

Not sure if this asset gives all the info that you are looking for but here is a link to it. It returns historical Blue Prism license utilization over a user-definable duration and unit of time

https://digitalexchange.blueprism.com/dx/entry/3439/solution/license-utilisation-sql-script

------------------------------
Shashank Kumar
DX Integrations Partner Consultant
Blue Prism
Singapore
+6581326707
------------------------------