Extract user name from database

[italoc]

i have an HA instance with mariadb ad I need to extract some statistic based from users, for example all action done from an user in a day, now with a SQL query I can extract the data but the username name is an HASH, there is a way to join this HASH with username?

thanks

[VDRainer]

It looks like the ‘context_user_id_bin’ column contains the userid from HA with spaces.
To get the user with it in HA:

Person entity: how to use "user_id"

It’s a unique ID assigned to the user that, for example, comes in the context for an event indicating which user triggered the event. You can also translate it into a username with a template like this: {{ states.person|selectattr("attributes.user_id", "==", "mylonguserid")|map(attribute="attributes.friendly_name")|first }}

I don’t think it’s possible directly with SQL.