1. In Ae, remove unused footage, then collect files and check generate report only. The resulting .txt file will contain a list of all used footage elements.
2. In Ae, File > Export > Adobe Premiere Pro project. Open the resulting .prproj in Premiere and export XML.