How to list unshared records

Hi,

If a user forget to share one of his password and lose its private key and/or his master password… the password is lost
Is it possible as an admin user to list these records (without the password) and so be able to remind user to share these records ?
Thank you

Hi @mdufourd this is an interesting question. If you are the admin in this scenario, are you restricted to a method internal to the app, or might your need be satisfied through some kind of a database query?

Hi @garrett
I am OK with a database query. I will put it in a cron and check the result with our nagios.

@mdufourd for example something like that?

Get the list of users with unshared passwords:

select username from users where id IN (select aro_foreign_key from permissions group by aco_foreign_key having count(aco_foreign_key) = 1);

Get the list of passwords that are not shared with anyone:

select name from resources where id IN (select aco_foreign_key from permissions group by aco_foreign_key having count(aco_foreign_key) = 1);
1 Like

Thanks

It works great. and Nagios raise the alarm accordingly.
Have a nice day
Marc

1 Like