https://community.blueprism.com/t5/Product-Forum/How-to-get-the-total-number-of-published-process-in-blue-prism/m-p/101787#M48661 Hi Shivaraj,<BR /><BR />You can try to execute the below query to get the desired result:<BR /><BR /><span class="lia-inline-image-display-wrapper" image-alt="36827.png"><img src="https://community.blueprism.com/t5/image/serverpage/image-id/36836i9753F1C7618F2DB5/image-size/large?v=v2&amp;px=999" role="button" title="36827.png" alt="36827.png" /></span><BR /><BR /> <PRE class="language-sql"><CODE>SELECT COUNT(*) AS PUBLISHED_PROCESS_COUNT FROM [blueprism].[dbo].[BPAProcess] WHERE [AttributeID] IN (SELECT [AttributeID] FROM [blueprism].[dbo].[BPAProcessAttribute] WHERE [AttributeName] = 'Published')​</CODE></PRE> <P><BR /><BR />Basically what this query does is it will try to look for the count of '<STRONG>AttributeID</STRONG>' column in your '<STRONG>BPAProcess</STRONG>' table where the '<STRONG>AttributeID</STRONG>' column mapping is present in the '<STRONG>BPAProcessAttribute</STRONG>' table where it indicates that the value '2' is equivalent to being published:<BR /><BR /><BR /><span class="lia-inline-image-display-wrapper" image-alt="36828.png"><img src="https://community.blueprism.com/t5/image/serverpage/image-id/36842iD2C30A72AE4C875B/image-size/large?v=v2&amp;px=999" role="button" title="36828.png" alt="36828.png" /></span><BR /><BR /><SPAN>------------------------------</SPAN><BR /><SPAN>----------------------------------</SPAN><BR /><SPAN>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</SPAN><BR /><BR /><SPAN>Regards,</SPAN><BR /><SPAN>Devneet Mohanty</SPAN><BR /><SPAN>Intelligent Process Automation Consultant | Sr. Consultant - Automation Developer,</SPAN><BR /><SPAN>WonderBotz India Pvt. Ltd.</SPAN><BR /><SPAN>Blue Prism Community MVP | Blue Prism 7x Certified Professional</SPAN><BR /><SPAN>Website:&nbsp;</SPAN><A href="https://devneet.github.io/" target="_blank" rel="noopener">https://devneet.github.io/</A><BR /><SPAN>Email:&nbsp;</SPAN><A href="mailto:devneetmohanty07@gmail.com" target="_blank" rel="noopener">devneetmohanty07@gmail.com</A><BR /><BR /><SPAN>----------------------------------</SPAN><BR /><SPAN>------------------------------</SPAN><BR /><BR /></P> Thu, 26 May 2022 12:50:58 GMT devneetmohanty07 2022-05-26T12:50:58Z https://community.blueprism.com/t5/Product-Forum/How-to-get-the-total-number-of-published-process-in-blue-prism/m-p/101785#M48659 How to get the total number of published processes in blue prism using query on SQL database Thu, 26 May 2022 10:37:38 GMT https://community.blueprism.com/t5/Product-Forum/How-to-get-the-total-number-of-published-process-in-blue-prism/m-p/101785#M48659 Shivaraj_kumar2 2022-05-26T10:37:38Z https://community.blueprism.com/t5/Product-Forum/How-to-get-the-total-number-of-published-process-in-blue-prism/m-p/101786#M48660 This asset can be used <A href="https://digitalexchange.blueprism.com/dx/entry/3439/solution/process-information-utility-3" target="test_blank">https://digitalexchange.blueprism.com/dx/entry/3439/solution/process-information-utility-3</A> Thu, 26 May 2022 10:54:34 GMT https://community.blueprism.com/t5/Product-Forum/How-to-get-the-total-number-of-published-process-in-blue-prism/m-p/101786#M48660 shashank.kumar280 2022-05-26T10:54:34Z https://community.blueprism.com/t5/Product-Forum/How-to-get-the-total-number-of-published-process-in-blue-prism/m-p/101787#M48661 Hi Shivaraj,<BR /><BR />You can try to execute the below query to get the desired result:<BR /><BR /><span class="lia-inline-image-display-wrapper" image-alt="36827.png"><img src="https://community.blueprism.com/t5/image/serverpage/image-id/36836i9753F1C7618F2DB5/image-size/large?v=v2&amp;px=999" role="button" title="36827.png" alt="36827.png" /></span><BR /><BR /> <PRE class="language-sql"><CODE>SELECT COUNT(*) AS PUBLISHED_PROCESS_COUNT FROM [blueprism].[dbo].[BPAProcess] WHERE [AttributeID] IN (SELECT [AttributeID] FROM [blueprism].[dbo].[BPAProcessAttribute] WHERE [AttributeName] = 'Published')​</CODE></PRE> <P><BR /><BR />Basically what this query does is it will try to look for the count of '<STRONG>AttributeID</STRONG>' column in your '<STRONG>BPAProcess</STRONG>' table where the '<STRONG>AttributeID</STRONG>' column mapping is present in the '<STRONG>BPAProcessAttribute</STRONG>' table where it indicates that the value '2' is equivalent to being published:<BR /><BR /><BR /><span class="lia-inline-image-display-wrapper" image-alt="36828.png"><img src="https://community.blueprism.com/t5/image/serverpage/image-id/36842iD2C30A72AE4C875B/image-size/large?v=v2&amp;px=999" role="button" title="36828.png" alt="36828.png" /></span><BR /><BR /><SPAN>------------------------------</SPAN><BR /><SPAN>----------------------------------</SPAN><BR /><SPAN>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</SPAN><BR /><BR /><SPAN>Regards,</SPAN><BR /><SPAN>Devneet Mohanty</SPAN><BR /><SPAN>Intelligent Process Automation Consultant | Sr. Consultant - Automation Developer,</SPAN><BR /><SPAN>WonderBotz India Pvt. Ltd.</SPAN><BR /><SPAN>Blue Prism Community MVP | Blue Prism 7x Certified Professional</SPAN><BR /><SPAN>Website:&nbsp;</SPAN><A href="https://devneet.github.io/" target="_blank" rel="noopener">https://devneet.github.io/</A><BR /><SPAN>Email:&nbsp;</SPAN><A href="mailto:devneetmohanty07@gmail.com" target="_blank" rel="noopener">devneetmohanty07@gmail.com</A><BR /><BR /><SPAN>----------------------------------</SPAN><BR /><SPAN>------------------------------</SPAN><BR /><BR /></P> Thu, 26 May 2022 12:50:58 GMT https://community.blueprism.com/t5/Product-Forum/How-to-get-the-total-number-of-published-process-in-blue-prism/m-p/101787#M48661 devneetmohanty07 2022-05-26T12:50:58Z https://community.blueprism.com/t5/Product-Forum/How-to-get-the-total-number-of-published-process-in-blue-prism/m-p/101788#M48662 Hi <a href="https://community.blueprism.com/t5/user/viewprofilepage/user-id/55688">@Shivaraj_kumar2</a>,<BR /><BR />&nbsp;Just checking if you were able to resolve your issue?​ Mon, 30 May 2022 08:05:34 GMT https://community.blueprism.com/t5/Product-Forum/How-to-get-the-total-number-of-published-process-in-blue-prism/m-p/101788#M48662 devneetmohanty07 2022-05-30T08:05:34Z