You can translate the question and the replies:

Denodo Usage metrics

1. Total Number of Users on platform 2. Total number of objects created on daily basis How do I query and get the above information using catalog queries? Thanks
user
15-03-2022 16:35:38 -0400
code

3 Answers

Hi, To find the number of users on the platform and the objects created on a daily basis, I will craft my aggregation queries utilising the [CATALOG_PERMISSIONS()](https://community.denodo.com/docs/html/browse/8.0/en/vdp/vql/stored_procedures/predefined_stored_procedures/catalog_permissions) and [GET_ELEMENTS()](https://community.denodo.com/docs/html/browse/8.0/en/vdp/vql/stored_procedures/predefined_stored_procedures/get_elements) stored procedures. I will also keep in mind the privileges that the user who runs these stored procedures have as the results may be different, depending on the privileges assigned to the user. Hope this helps!
Denodo Team
16-03-2022 03:48:07 -0400
code
Hi Denodo team, The above table/view does not help me to see how many new users have logged in. Here is the query I used. select distinct username, dbname, userrolename from CATALOG_PERMISSIONS() where userrolename is not null and username is not null and dbname is not null Thanks Paddy
user
17-03-2022 10:33:22 -0400
Hi, For managing user login activities on Denodo Platform, I will read and follow the steps listed in the [Auditing User Access in Virtual DataPort](https://community.denodo.com/kb/en/view/document/Auditing%20User%20Access%20in%20Virtual%20DataPort) Knowledge Base article. It is necessary for the Denodo Monitor to be enabled and running in order for the user connection details to be logged into Denodo Monitor’s **vdp-connections.log** file. By default, Denodo Monitor is not enabled and thus no records are logged inside the vdp-connections.log file. Hope this helps!
Denodo Team
18-03-2022 02:26:42 -0400
code
You must sign in to add an answer. If you do not have an account, you can register here