To check the Interactive clients connected to Application server

[Sheela]

Hi All,

I have created below DB query to check the interactive clients connected to an application server instance, which are not active for last 2 weeks.
select * from BPAResource where lastupdated < GETDATE() - 14 and AttributeID = '96'

Can someone confirm if this is the expected query or is there any other query.

Regards,
Sheela

@ewilson Could you please suggest here.





​

------------------------------
Sheela Parthasarathy
Assistant Vice President
Deutsche Bank Group
Pacific/Apia
------------------------------

[lookman]

Hi Sheela.

The BPAResource.AttributeID column is a foreign key of the BPAResourceAttribute table. Take a look do see what values you have.

As I understand, 96 would be a default instanace (value of 64) and private resource (32), hence 96.

jack


------------------------------
Jack Look
Sr Product Consultant
Blue Prism
------------------------------