#1318 Change Expiration Date from List

[Humangenom]

It would be much easier if you could select many entries from the list and change the expiration date for all of them at once.

PS: And it would be great to show the creation date inside the entry and not only in the list

[xaa]

hi,
first, thanks for Keepass. That's a very nice freeware. I use it for many years now.
As Pail459 has suggested me (https://sourceforge.net/projects/keepass/forums/forum/329221/topic/5048813), I add a comment here.

I am also wondering if you could think to this feature ?

The fact is, I manage a kdb with +-1000 entries. Many entries are not available anymore.
So, it will be really nice if we can select several entries in the list, right click and define them as expired.

In the same way, I am a bit surprised that we are able to define a group as expired and to see that the entries of this group aren't automatically defined as expired

Thank in advance to let me know :),
Xavier

[Jibbers42]

This would be a great feature for Heartbleed to help track sites that you still want to change your password for - in combination with http://filippo.io/Heartbleed/ to know when it is safe to make the change.

It would be great to see right-click and Tools menu items for manual expiry. Perhaps someone familiar with code would be willing to add this in short order and make a release available - or as a plugin if plugins support this kind of thing :)

[Paul]

Change the column view to show the expiry time, sort by that time and go from there.

cheers, Paul

[Jibbers42]

Paul, thank you for the input. I'm using quite a number of groups and so I did an empty search to list all entries. The UI seems to only sort within groups. Even if there is a way to sort the whole list, there are still a couple of other reason this isn't ideal for me.

For anyone who needs to expire all passwords, I made a powershell script for that. It requires a development version of KeePass and KPScript you can find here, https://sourceforge.net/p/keepass/discussion/329220/thread/6ed93b2f/, http://keepass.info/filepool/KPScript_140409.zip. I'm guessing the changes will be in 2.26 when released.

It might take a while to run if you have a lot of entries, so be patient.

** Warning: Backup your file!! **
I had a corruption, I think due to a file syncing software monitoring the file while it was being rapidly changed.

After saving the script below to a file, like expire-passwords.ps1, then right-click the file and choose "Run with PowerShell".

##################################
### Backup your password file! ###
### Edit these items as needed ###
##################################
$kps  = 'C:\Program Files (x86)\KeePass Password Safe 2\KPScript.exe'
$kdbx = '<your keepass file>'
$pass = '<your password>'


# Get entries
$output = & "$kps" -c:ListEntries "$kdbx" -pw:$pass
$pattern = 'UUID: '
$uuids = $output | Select-String -pattern $pattern

$date = Get-Date -Hour 0 -Minute 00 -Second 00 -Millisecond 0 -Format s
$count = $uuids.Matches.Count

# Update each entry
foreach ($match in $uuids) {
    echo "$count items remaining"
    $count = $count - 1
    $uuid = $match.Line.Substring($pattern.Length)
    $output = & "$kps" -c:EditEntry "$kdbx" -pw:$pass -refx-UUID:"$uuid" -setx-Expires:"true" "-setx-ExpiryTime:$date"
}


$x = Read-Host -Prompt 'Finished - Press Enter to continue'

[Dominik Reichl]

Included in the more generic FR 1659:
https://sourceforge.net/p/keepass/feature-requests/1659/