How can I know the storage locations of an asset?

You can easily know the storage locations of an asset under File Versions widget.
Different icons represent different storage locations (as mentioned below):
: Exists in Source
: Exists in Storage
: Exists in Archive
: Exists in Cloud