Can we get a query for asset ID?

Can someone create a query to look for asset IDs? Perhaps to put out a list of assets and include the asset ID.

SELECT * FROM dim_asset