I think it’s doable in a single query, it’s just a matter of how long it takes to execute. If you’re doing it on a subset of your assets then it might be better (depending on the size of that subset). The data you’re looking to get is also pretty broad, and we tend to recommend having separate queries that tackle asset-centric vs. vulnerability-centric data, for example. Doing it that way is a little cleaner and could help you avoid lots of duplicate data in your results.
But it is possible to merge the queries I posted above into one, and join with any other tables you need to get what you’re looking for. To get the service details you listed, I believe you can use dim_asset_service.
There’s also an example from another topic here that shows you how to get the owner tags. If you look at the start of the query it has the WITH owner_tags bit.
Let us know if there are any particular fields you’re having trouble finding, but in general this is a good place to help you find what you’re looking for and figure out which tables you need to use in your query.