Clarity: How can I determine how frequently a report is used by the user base?

book

Article ID: 51402

calendar_today

Updated On:

Products

CLARITY PPM FOR ITG CLARITY PPM FEDERAL CA Identity Manager CA Identity Governance CA Identity Portal Clarity PPM SaaS Clarity PPM On Premise

Issue/Introduction

The cmn_sch_jobs table contains information on what immediate and scheduled reports are run from Clarity. The following query will identify the number of runs of a particular report within a certain date range.

**Oracle**
select count (*) from cmn_sch_jobs 
    where name = 'Capacity vs Demand By Role'
    AND end_date between to_date ('2009/01/01', 'yyyy/mm/dd') 
    AND to_date ('2009/12/31', 'yyyy/mm/dd')
---OUTPUT------------------------------
 COUNT(*)    
 ----------- 
 12    
 
**MSSQL**
select count (*) from cmn_sch_jobs 
    where name = 'Capacity vs Demand By Role'
    AND end_date between '2007/01/01' and '2009/12/31'
--Output-----
 --- 
 3

** Replace the report name ('name' field) and end_date with the appropriate values.

This query should return the report you just ran.

Keywords: CLARITYKB, clarity8open, clarity12open, filter, query, how many, cm_sch_job_runs, report, run, actuate, bo, business objects, sql, oracle, mssql.

Environment

Release: NCSVCS05900-8.1-Clarity-Service Connect-for MS-SQL
Component: