SmallestDruid Posted May 6, 2022 Share Posted May 6, 2022 Many years ago we imported a large number of passwords into PasswordState and, somehow, many (~2,500) of these passwords acquired an expiry date where no expiry is required. These passwords appear in our expired passwords report (of course). How can we batch remove expiry from these passwords? We can assume that no passwords in our PasswordState instance (build 9500) need/have an expiry if that simplifies things. Thanks! Link to comment Share on other sites More sharing options...
support Posted May 6, 2022 Share Posted May 6, 2022 Hello, We do not have a way to do this in the UI, but you can do it directly in the database if you like. Steps are: Determine the PasswordListID or IDs, using screenshots below The use SQL Management Studio and execute the commands below - update the PasswordListID as appropriate USE Passwordstate UPDATE [Passwords] SET ExpiryDate = NULL WHERE PasswordListID = xxxxx Regards Click Studios Link to comment Share on other sites More sharing options...
SmallestDruid Posted May 7, 2022 Author Share Posted May 7, 2022 Thanks, that worked perfectly 😀 Link to comment Share on other sites More sharing options...
support Posted May 7, 2022 Share Posted May 7, 2022 Link to comment Share on other sites More sharing options...
Recommended Posts
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now