I have been at this all day and tried various things from this forum; I’m just not finding what I need. My V.P. has tasked me with tagging all Rapid7 Assets with a Custom Tag, Location Tag and Owner Tag. I have this query working and getting me the Assets that have an Owner assigned to them. <a name="select-daip_address-as-ip-address-dahost_name-as-host-name-dttag_name-as-tag-name-from-dim_tag_asset-dta-join-dim_asset-da-on-daasset_id-dtaasset_id-join-dim_tag-dt-on-dttag_id-dtatag_id-where-dttag_type-owner-order-by-dahost_name-asc-1" class="anchor" href="#select-daip_address-as-ip-address-dahost_name-as-host-name-dttag_name-as-tag-name-from-dim_tag_asset-dta-join-dim_asset-da-on-daasset_id-dtaasset_id-join-dim_tag-dt-on-dttag_id-dtatag_id-where-dttag_type-owner-order-by-dahost_name-asc-1"> SE…

Thanks John! I think I had some subtle differences in the two questions, however at the end of the day, the query you posted in the other post solves the problem that I was struggling with! Many thanks!

SQL Query - Assets without a Tag

InsightVM

john_hartman (John Hartman) December 30, 2022, 3:36pm 2

Hey, I think this question was answered in your other post here: