Assets with Owner Tags

InsightVM SQL Queries
,
1

I need a SQL for report that brings back of assets, and owner tags so I can create incidents to particular owner.

2

This query should pull what you are looking for.

SELECT 
	da.ip_address
	,da.host_name
	,dt.tag_name
FROM dim_tag_asset dta
JOIN dim_asset da ON da.asset_id = dta.asset_id
JOIN dim_tag dt ON dt.tag_id = dta.tag_id
WHERE dt.tag_type = 'OWNER'
3 Likes
3

Thank You so much

1 Like