...
select * from gis.assetlife.asset
Using the Data Source SQL Tool for Debugging
This tool is useful if you're not getting the results you were expecting in a search, data grid, etc. Use it to run the SQL command that is being sent to Weave (and has been constructed from the content of your XML files) and then check the results of this query.
...