cancel
Showing results for 
Search instead for 
Did you mean: 

To check the Interactive clients connected to Application server

Sheela
Level 5
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
------------------------------
1 REPLY 1

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