topic Query to get a list of resources which are retired from BluePrism database in Product Forum

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

YashaswiniB — Sat, 30 Apr 2022 16:13:00 GMT

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

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

ewilson — Sat, 30 Apr 2022 17:07:00 GMT

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

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

YashaswiniB — Sat, 30 Apr 2022 17:48:00 GMT

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

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

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

ManpreetKaur1 — Mon, 02 May 2022 08:08:00 GMT

Thanks @ewilson for the valuable information.

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