https://community.blueprism.com/t5/Product-Forum/SQL-Qurey-to-get-the-Blue-Prism-License-information/m-p/91753#M41700 Here is the query screenshot. Thu, 16 May 2019 12:34:00 GMT Hemachanderrao 2019-05-16T12:34:00Z https://community.blueprism.com/t5/Product-Forum/SQL-Qurey-to-get-the-Blue-Prism-License-information/m-p/91749#M41696 Folks, Any one has a SQL query or anything to get the details of the License info like the start date, end date etc. Tue, 14 May 2019 22:49:00 GMT https://community.blueprism.com/t5/Product-Forum/SQL-Qurey-to-get-the-Blue-Prism-License-information/m-p/91749#M41696 VinodGudupudi 2019-05-14T22:49:00Z https://community.blueprism.com/t5/Product-Forum/SQL-Qurey-to-get-the-Blue-Prism-License-information/m-p/91750#M41697 Generally, you can retrieve the license information from the Blue Prism System Manager by navigating through the following pathway Blue Prism > System > License   When the license key is installed, the BPALicense table retains the license information with the installation date and does not include further information such as the start date, end date.  Wed, 15 May 2019 06:33:00 GMT https://community.blueprism.com/t5/Product-Forum/SQL-Qurey-to-get-the-Blue-Prism-License-information/m-p/91750#M41697 jegendra 2019-05-15T06:33:00Z https://community.blueprism.com/t5/Product-Forum/SQL-Qurey-to-get-the-Blue-Prism-License-information/m-p/91751#M41698 Hi gudupv2, There is a table on the BP DB that stores some licence info as well but there's not much there. dbo.BPALicense Wed, 15 May 2019 07:42:00 GMT https://community.blueprism.com/t5/Product-Forum/SQL-Qurey-to-get-the-Blue-Prism-License-information/m-p/91751#M41698 BenKirimlidis 2019-05-15T07:42:00Z https://community.blueprism.com/t5/Product-Forum/SQL-Qurey-to-get-the-Blue-Prism-License-information/m-p/91752#M41699 Hi,  Blue Prism does not recommend direct queries on the database. However, you could use the attached query to get the information you need.       Thu, 16 May 2019 12:33:00 GMT https://community.blueprism.com/t5/Product-Forum/SQL-Qurey-to-get-the-Blue-Prism-License-information/m-p/91752#M41699 Hemachanderrao 2019-05-16T12:33:00Z https://community.blueprism.com/t5/Product-Forum/SQL-Qurey-to-get-the-Blue-Prism-License-information/m-p/91753#M41700 Here is the query screenshot. Thu, 16 May 2019 12:34:00 GMT https://community.blueprism.com/t5/Product-Forum/SQL-Qurey-to-get-the-Blue-Prism-License-information/m-p/91753#M41700 Hemachanderrao 2019-05-16T12:34:00Z https://community.blueprism.com/t5/Product-Forum/SQL-Qurey-to-get-the-Blue-Prism-License-information/m-p/91754#M41701 @Hemachanderrao You are correct. Good catch and thank you for pointing it out. In my reply above I recommened querying the Database (DB) but I forgot to specify to only query a mirror of the SQL database, not the actual production DB directly. Querying a PROD DB is never best practice and could create problems, instead it is best to have a copy of the PROD database (called a Mirror) that stores a copy of all the same data as the PROD DB, backed up periodically or triggered by certain events. A mirror DB can be queried without ever worrying about impacteding production services.  Hermachanderrao was absolutely right to say not to query the DB directly.  I left left out the part about only querying the mirror.  Thank you for catchgin that, someone could have read my message and created problems for themselves. Kind regards, Ben Fri, 17 May 2019 17:11:00 GMT https://community.blueprism.com/t5/Product-Forum/SQL-Qurey-to-get-the-Blue-Prism-License-information/m-p/91754#M41701 BenKirimlidis 2019-05-17T17:11:00Z