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