Create report for queries by category - tactical, ad-hoc, short, medium,tactical etc

Database
Junior Supporter

Create report for queries by category - tactical, ad-hoc, short, medium,tactical etc

Hi,

i want to create a report with number of queries running in the different categories i.e adhoc short,long,tactical etc.

We find this classification in the 'Workload' column in the viewpoint.

which dbc table or viewpoint option can i use to create this report. I can get the query info from from

DBQLObjTbl

DBQLOGTbl

DBQLSQLTBL

tables and querry logging is enabled.

Its little urgent, so early reply is highly apprciated