1 of 1 people found this helpful
You can access the information related to the tag for an entity using the PV_SYS_TAG public view. The following documentation link will take you to section at discusses the tag public view.
Here is a snippet from a tag audit view I have. (TSCO 11 - YMMV) You can change the where statement to match your agenda/target.
make it just a join statement (instead of full join) and you will only see the items with a tag.
select 'Device' as TagType
, ps.sysid as ObjectID
, ps.name as ObjectName
, ps.description as ObjectDescription
, ps.systype as ObjectType
from pv_sys_tag pst
full join pv_system ps on pst.sysid = ps.sysid