List Scratch Tapes from Standalone and send a report

Dear Experts,

I am planning to automate Scratch request of Standalone tapes to be recalled from DR.

I use the below query to fetch the Scratch from Standalone.

vmquery -pn Scratch -b | grep "NONE"

The Output lists Media Id but We need Barcode of all these media as our media Id and Barcodes are not similar, how can i achieve this.