Can we get the UCM file download link in BIP

HI All,

I'd like to build a report with UCM file name and download link. SQL can extract file name and file id. But how can I get the file download link?

Thanks in advance!

Version: 24B