How to update update old psd files when upgrading to 5.6.1

Symptoms:

In 5.6.1, is is possible to crop PSD files, but only those uploaded after the upgrade.

Pre-upgraded PSDs cannot be cropped because "The crop button is not shown because the asset has no width and height. These dimensions were not added to the asset table before 5.6.1."

[RNDS-1540] Make it Possible to crop Old PSD assets in 5.6.1 - Jira (atlassian.net)

Download The One-Off application

Unzip on DC server
Run as Administrator
Select DC site that should be updated
Click Process

the application will handle both UNC and Azure stored assets, but the user that runs the application needs read access to the unc storage area (normally true)

SQL used to identify assets that should be processed

select
	a.assetid, 
	a.asset_type,
	al.destinationid,
	al.location 
from 
	dbo.asset a 
inner join 
	dbo.asset_location al on a.assetid = al.assetid 
where
    al.location_state = 111001 
	and a.deleted=0
	and a.asset_type in (4,15,16)
	and (
		a.OrigMimeType in ('image/psd','image/photoshop') 
		or al.location like '%.psd'
	)
	and (
		nullif(a.image_height,0) is null 
		or nullif(a.image_width,0) is null
	)
order by a.assetid