AIOps - How to get the # of logged in users in DX Platform

Products

• DX Operational Intelligence
• DX Application Performance Management
• CA App Experience Analytics

Issue/Introduction

How can we achieve this?

Environment

DX Platform 2x

Resolution

This information is not available from Cluster Management or APIs

SOLUTION:

There are some database queries that can be run to query on active dxitokens but not publicly exposed via a dashboard, supportability metric, or api. 

1) Connect to Postgres pod, refer to KB https://knowledge.broadcom.com/external/article?articleId=237028

2) Run any of the below queries:

select userid, orgname, creationtime from arudsauthsession;
select userid, orgname, creationtime from arudsauthsession where userid='userid';

example:

NOTES:

- From that table, you can extract the count via 'count(*)' or further break down via userid.

- The above queries will give give you the "Live user count " only.  At the moment, it is not possible to query on historical information, enhancement request # US890532 has been created for this current limitation.

Additional Information

https://knowledge.broadcom.com/external/article/190815/aiops-troubleshooting-common-issues-and.html