cancel
Showing results for 
Search instead for 
Did you mean: 

Accessing Blue Prism objects and processing through SQL Database

OngunArisev
Level 3
Hello, Is it possible to access Blue Prism tables via Microsoft SQL Server Management Studio? How are the processes, objects and logs stored in the database? I do not know which database these Blue Prism entities are saved under. My aim is to be able to modify (mostly delete) excessive logs, processes etc. directly from the database. I have included a screenshot from Object Explorer in MS SQL Server Management Studio. I would appreciate it if you could provide guidance. Thanks in advance
1 REPLY 1

Denis__Dennehy
Level 15
I would not recommend creating your own update/deletion scripts for enterprise software products.   The Blue Prism product includes an archiving/deletion feature for logs.  If you have not maintained your logs and they have grown too large then you should contact the product support team to ask for maintenance scripts that could be ran by your DBA. I would recommend that your organisation has a Data and Archive policy in relation to logs, there is a template for this in the ROM documetation area of the portal.  It is also good practice for developers to turn off as much logging as posible before a solution is moved into production.