AJI Hits Report from DBQLObjTbl table - Query?

Analytics

AJI Hits Report from DBQLObjTbl table - Query?

Hi,

I guess we can find out the relevance/ frequency of usage of an AJI from the table DBQLObjTbl. Can someone please let me know how?

The purpose is to find out the unused or less used AJIs in the system and thereby dropping them or finding a way to use.

Appreciate any help in this matter.

Tags (2)
1 REPLY
amg
Fan

Re: AJI Hits Report from DBQLObjTbl table - Query?

Hello,  you may use QryLogObjectsV (View on DBQLObjTbl) to find the number of queries that hit each AJI.

In the simplest form the query could look like this:

select ObjectTableName, count(QueryID) as Cnt

from QryLogObjectsV

where ObjectType='JIx'

group by ObjectTableName

order by Cnt