remaining useful lives

in asset master AS03, the original asset got useful lives 7 years, expired 2 years 1 month, what's the remaining year and month if using double decline method?

any report or table directly show this?

I need to submit asset remaining useful lives for nearly 1000 assets, any efficent way? we use a lot of depreciation methods, thus difficult for me to manually calculate one by one