https://community.blueprism.com/t5/Product-Forum/To-check-the-Interactive-clients-connected-to-Application-server/m-p/90643#M40820 Hi Sheela.<BR /><BR />The BPAResource.AttributeID column is a foreign key of the BPAResourceAttribute table. Take a look do see what values you have.<BR /><BR />As I understand, 96 would be a default instanace (value of 64) and private resource (32), hence 96.<BR /><BR />jack<BR /><BR /><BR />------------------------------<BR />Jack Look<BR />Sr Product Consultant<BR />Blue Prism<BR />------------------------------<BR /> Mon, 28 Nov 2022 15:08:00 GMT lookman 2022-11-28T15:08:00Z https://community.blueprism.com/t5/Product-Forum/To-check-the-Interactive-clients-connected-to-Application-server/m-p/90642#M40819 <SPAN>Hi All,<BR /><BR />I have created below DB query to check the interactive clients connected to an application server instance, which are not&nbsp;active for last 2 weeks.<BR />select&nbsp;*&nbsp;from&nbsp;BPAResource&nbsp;where&nbsp;lastupdated&nbsp;&lt;&nbsp;GETDATE()&nbsp;-&nbsp;14&nbsp;and&nbsp;AttributeID&nbsp;=&nbsp;'96'<BR /><BR />Can someone confirm if this is the expected query or is there any other query.<BR /><BR />Regards,<BR />Sheela<BR /><BR /><a href="https://community.blueprism.com/t5/user/viewprofilepage/user-id/833">@ewilson</a> Could you please suggest here.<BR /><BR /><BR /><BR /><BR /><BR /></SPAN>​<BR /><BR />------------------------------<BR />Sheela Parthasarathy<BR />Assistant Vice President<BR />Deutsche Bank Group<BR />Pacific/Apia<BR />------------------------------<BR /> Thu, 24 Nov 2022 09:02:00 GMT https://community.blueprism.com/t5/Product-Forum/To-check-the-Interactive-clients-connected-to-Application-server/m-p/90642#M40819 Sheela 2022-11-24T09:02:00Z https://community.blueprism.com/t5/Product-Forum/To-check-the-Interactive-clients-connected-to-Application-server/m-p/90643#M40820 Hi Sheela.<BR /><BR />The BPAResource.AttributeID column is a foreign key of the BPAResourceAttribute table. Take a look do see what values you have.<BR /><BR />As I understand, 96 would be a default instanace (value of 64) and private resource (32), hence 96.<BR /><BR />jack<BR /><BR /><BR />------------------------------<BR />Jack Look<BR />Sr Product Consultant<BR />Blue Prism<BR />------------------------------<BR /> Mon, 28 Nov 2022 15:08:00 GMT https://community.blueprism.com/t5/Product-Forum/To-check-the-Interactive-clients-connected-to-Application-server/m-p/90643#M40820 lookman 2022-11-28T15:08:00Z