Retrieve File Size of an Asset

Hello,
I am trying to get filesize of assets, to help monitor the system usage.

The filesize data is not stored by default (for some reason) in the SQL Server database, so I need to get it some other way (?).

If anyone else has come across this issue and has a solution etc I would love to get some help or pointers.

Thank you,
Brian Heisler
New Balance

Find more posts tagged with

Comments

Migrateduser_427

I would suggest opening a support ticket with the question. If they don't have a way, request a Feature Request. Granted it may take a while (if ever) to come to a product release.

There might be an easier way, but you could script a match against the asset ID and the size of the stored asset file in the MB Repository drive.

Would also be nice if they added more to reporting and a user interface instead of having us run queries to the DB report views (or am I missing something here?). There is a lot more analytics requests these days to show ROI and this would help with that.

Migrateduser

Well, here at New Balance, I guess we are not a big enough fish in their large pond, so we cannot seem to get help on a simple request (from a business standpoint - to get ROI, which is kinda huge to justify this tool) like this.

We are just about to move away and to a cloud service. We have had Media Bin long enough, and 'lived with' what is offered - common support, bad service and even worse capabilities for solutions that are not out of the box.

I have asked this in a ticket; the answers I get are laughable for what we pay in support. And Virage is no better - just deeper search. And if you don't do big video, it's overkill.

Bill Klish

Brian,

To get the file size of an asset, you can leverage the MediaBin API available via web service. There are a ton of things you can do in the API besides this, but all you need to do is get the MBAsset object for the image in question and call the getFilesize() method.

DisplayUser.zip

Migrateduser

Thanks Bill.