Getting the ObjectIds of assets in MediaBin

I am trying to get a list of the objectID of assets in MediaBin.

My environment is as follows;

MediaBin 4.5.1.
Using VB with the scriptModel api.

The tables in the MediaBin database(in SQL server) does not have the objectID field I am looking for.

Any help would be appreciated

Find more posts tagged with

Comments

Migrateduser

From the api the only way to get the id (GUID) of an asset is to get that asset object (Asset.Identifier). Actually, it would be a short script to list out the MediaBin path and GUID of every asset. However it could take a very long time to run depending on the size of your repository.

lyman

If you are using MS SQL Server and or if you have Oracle and are using the newly release 4.6, you can use the predefined report views documented in Appendix D of MediaBin Asset Server Administration Guide. The view ReportAssetList will give you more or less precisely what you are requesting (among other columns).

Cheers,

Lyman Hurd