KM: reporting and extracting documents

hi,

We are trying to create one report from KM which lists: Supplier name, Supplier ID, Room name, Room ID, Room URL, Document name, document ID, Document link, document type. So far we've tried some metada export and some inventory report, but none of those provide all the fields.

The business unit would then pick the documents to be xtracted from KM. So far, not sure either how to extract the documents.

Anyone any ideas?