How to get the total number of published process in blue prism

[Shivaraj_kumar2]

How to get the total number of published processes in blue prism using query on SQL database

[shashank.kumar280]

This asset can be used https://digitalexchange.blueprism.com/dx/entry/3439/solution/process-information-utility-3

[devneetmohanty07]

Hi Shivaraj,

You can try to execute the below query to get the desired result:

SELECT COUNT(*) AS PUBLISHED_PROCESS_COUNT FROM [blueprism].[dbo].[BPAProcess] 
WHERE [AttributeID] IN (SELECT [AttributeID] FROM [blueprism].[dbo].[BPAProcessAttribute] WHERE [AttributeName] = 'Published')​

Basically what this query does is it will try to look for the count of 'AttributeID' column in your 'BPAProcess' table where the 'AttributeID' column mapping is present in the 'BPAProcessAttribute' table where it indicates that the value '2' is equivalent to being published:




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

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

[devneetmohanty07]

Hi @Shivaraj_kumar2,

 Just checking if you were able to resolve your issue?​