Tooltip Usage Assessment

Because tooltips are not stored as macros, it is not possible to track them from the Macro Usage screen or using CQL. The following SQL query should work on any database engine and will return a list of pages likely containing tooltips:

SQL

select c.contentid, c.contenttype, s.spacename, s.spacekey, c.title 
from BODYCONTENT bc 
join content c on bc.contentid = c.contentid 
join spaces s ON c.spaceid = s.spaceid  
where body like '%tooltip=%'
 and c.prevver is null
  and c.content_status = 'current'
order by s.spacekey, c.title;