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

can you be a little bit more specific of what you are trying to pull and/or accomplish that may give you some better responses.