Jump to content
Valentijn Scholten

Report: Password lists (and/or folders?) without admins

Recommended Posts

Hi,

 

Sometimes it happens that people are leaving our company. When their account is deleted (or disabled) it can result in passwordlists having no admin anymore.

 

As far as I can tell there's no easy way to generate a report of these lists, so that would be a welcome addition to passwordstate.

 

Any work arounds maybe?

 

Valentijn

Share this post


Link to post
Share on other sites

Hello,

Thanks for your request. As a work around, you could run the SQL Query below. Any Password Lists with a TotalPermissions of 0, means there is no Admin on the list.

 

USE Passwordstate

SELECT PasswordLists.PasswordListID, PasswordLists.PasswordList, PasswordLists.Description, PasswordLists.TreePath, (SELECT COUNT(PasswordListID) FROM [PasswordListsACL] PSSWD WHERE (PSSWD.PasswordListID = PasswordLists.PasswordListID) AND (PSSWD.Permissions = 'A')) As TotalPermissions
FROM [PasswordLists] 
WHERE (PasswordLists.PrivatePasswordList = 0) AND (PasswordLists.Folder <> 1) 
GROUP BY PasswordLists.PasswordListID, PasswordLists.PasswordList, PasswordLists.Description, PasswordLists.TreePath
ORDER BY PasswordLists.PasswordList

Regards

Click Studios

Share this post


Link to post
Share on other sites

Hi,

 

used this SQL query for several times. I would put +1 for this feature to have it in the reporting. I would improve with the additional column indicating the number of records in the password list.

Share this post


Link to post
Share on other sites

I agree the query works fine, but it requires SQL access. I wouldn't want to allow too many servicedesk people access to the database (and bypassing audit logs).

So would be nice to have the report in place. 

The primary usecase I would use this report is when/before deleting a user. So ideally the report would be "Password lists for which a user is the only admin".

Share this post


Link to post
Share on other sites

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.

Guest
Reply to this topic...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

Loading...

×
×
  • Create New...