

-- get the full names of all predicates
-- for use in CREATE/ALTER EVENT SESSION

-- predicate sources
-- 29 rows affected
select p.name + '.' + o.name as [Full Name], 
       o.description 
from sys.dm_xe_objects o
join sys.dm_xe_packages p on o.package_guid = p.guid
where o.object_type = 'pred_source' order by p.name, o.name

-- predicate compare
-- 111 rows affected
select p.name + '.' + o.name as [Full Name], 
       o.description 
from sys.dm_xe_objects o
join sys.dm_xe_packages p on o.package_guid = p.guid
where o.object_type = 'pred_compare' order by p.name, o.name