Hi Sanjeeb,
Please let me know what worked for you.

Hello @Sanjeeb2024 ,

Why do you need this to be done using system tables?

If you have Account Admin access, there is a REST API that allows you to list all users, groups, and service principals for the account:

https://docs.databricks.com/api/scim/v1/user
https://docs.databricks.com/api/scim/v1/service-principal
https://docs.databricks.com/api/scim/v1/group

You can extract this information through a job using a service principal with Account Admin privileges, load it into a DataFrame, and then generate your own tables.
Please check if this meets your needs.

Regards,

Danilo Van der Linden