Query to get a list of resources which are retired from BluePrism database

[YashaswiniB]

Hi All,

Can anyone help me with the query that can be executed to get the list of resources which are retired from BluePrism database.

Thanks,
Yash

------------------------------
Yashaswini B
------------------------------

[ewilson]

@Yashaswini B,

Give this a try. If you check the BPAResourceAttribute table you'll see that AttributeID 1 = Retired.

SELECT * FROM <YOUR DB NAME>.[dbo].[BPAResource] WHERE [AttributeID] = 1;​

​​
Cheers,

------------------------------
Eric Wilson
Director, Integrations and Enablement
Blue Prism Digital Exchange
------------------------------

[YashaswiniB]

Thank you Eric, I will try and let you know the outcome

------------------------------
Yashaswini B
------------------------------

[ManpreetKaur1]

Thanks @ewilson for the valuable information.​

------------------------------
Manpreet Kaur
Manager
Deloitte
------------------------------