SQL Qurey to get the Blue Prism License information
Options
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Email to a Friend
- Report Inappropriate Content
14-05-19 11:49 PM
Folks,
Any one has a SQL query or anything to get the details of the License info like the start date, end date etc.
5 REPLIES 5
Options
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Email to a Friend
- Report Inappropriate Content
15-05-19 07:33 AM
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.Â
Jega Avinasinathan
Customer Support Engineer
Blue Prism
Options
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Email to a Friend
- Report Inappropriate Content
15-05-19 08:42 AM
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
Options
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Email to a Friend
- Report Inappropriate Content
16-05-19 01:33 PM
Hi,Â
Blue Prism does not recommend direct queries on the database. However, you could use the attached query to get the information you need.
Â
Â
Â
Options
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Email to a Friend
- Report Inappropriate Content
16-05-19 01:34 PM
Options
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Email to a Friend
- Report Inappropriate Content
17-05-19 06:11 PM
@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