Object or Process to check if Queue is Encrypted

[PavelZuravliov]

Looking for an option to check if queue is encrypted before loading items to queue or getting items from it.
Due to sometimes tick is missing under queue config we run in to problems. Would like to automate message sending if queue was not configured properly. But dont see any way how to check, but only going to settings manually and check if tick is  marked. 

Working with BP7.1.

------------------------------
Pavel Zuravliov
Developer
SwedBank
Europe/Vilnius
------------------------------

[devneetmohanty07]

Hi @Pavel Zuravliov,

To do this the best way would be build a bot which can have a direct access to your Blue Prism database using the Function for Data - SQL Server - 10.0.0 business object and from there you can execute this simple query​:

SELECT COUNT([name])
FROM [Blue Prism].[dbo].[BPAWorkQueue] WHERE [encryptid] IS NULL

Ideally, what this query does is give you the total count of queues which do not have the encryption checkbox as checked while being configured. If this count is not equal to 0, then you can retrieve the list of all the queue names for your email notification with the below subsequent query:

SELECT [name] FROM [Blue Prism].[dbo].[BPAWorkQueue] WHERE [encryptid] IS NULL​

The working behind this logic is pretty simple as it queries the BPAWorkQueue table which consists of all the queue related configuration, and it has a column called as 'encryptid' which will have the encryption ID set up if you use the 'Encryption' feature in your work queue otherwise it would have null values as shown below:





------------------------------
----------------------------------
Hope it helps you out and if my solution resolves your query, then please mark it as the 'Best Answer' so that the others members in the community having similar problem statement can track the answer easily in future

Regards,
Devneet Mohanty
Intelligent Process Automation Consultant | Sr. Consultant - Automation Developer,
WonderBotz India Pvt. Ltd.
Blue Prism Community MVP | Blue Prism 7x Certified Professional
Website: https://devneet.github.io/
Email: devneetmohanty07@gmail.com

----------------------------------
------------------------------