1 of 1 people found this helpful
Presume this is the same for your Service Desk but on ours this guid is linked to the table.attribute md_query_template.md_guid
Besides this giving you a handy list of queries and there shortcuts how are you determining usage?
thanks for the fast reply.
I also thought that this table is the right one, but this statement is not working:
select m.md_title from md_query_template m
inner join ui_shortcut_item u on m.md_guid = sys.xmltype(u.ui_data).extract('/QueryResultsViewInit/DefinitionGuid/text()').getStringVal()
where u.ui_component = 'QueryTool';
I don't want to know how often the query is used, but how often it is linked on a shortcut bar and on which.