How can I find license details from BP DB?

[JasmeetSingh]

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
------------------------------

[PabloSarabia]

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
------------------------------

[JasmeetSingh]

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
------------------------------

[PabloSarabia]

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
------------------------------

[JasmeetSingh]

Hi @PabloSarabia

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

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

[Neel1]

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



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

[shashank.kumar280]

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
------------------------------