Products
Solutions
Support & Services
Company
How To Buy
Skip to main content (Press Enter).
Sign in
Skip auxiliary navigation (Press Enter).
Register
Skip main navigation (Press Enter).
Toggle navigation
Search Options
Home
Communities
All Communities
Enterprise Software
Mainframe Software
Symantec Enterprise
Blogs
All Blogs
Enterprise Software
Mainframe Software
Symantec Enterprise
Events
Enterprise Software
Mainframe Software
Symantec Enterprise
VMware
Water Cooler
Groups
Enterprise Software
Mainframe Software
Symantec Enterprise
Clarity
Private Community
Community Home
Threads
Library
Events
Members
Back to discussions
Expand all
|
Collapse all
sort by most recent
sort by thread
Reports on Reports
Anon Anon
Jan 24, 2012 04:35 PM
Is there a way to get reports on recent report activity? That is, which reports have been run, by whom, ...
Deactivated User
Jan 24, 2012 05:03 PM
If they are launched from Clarity they should appear with other "jobs" in cmn_sch_job_runs table. ...
Anon Anon
Jan 25, 2012 02:03 AM
Hi Mush, Even you can see in CMS history as well for the particular report, the following information ...
Anon Anon
Jan 25, 2012 03:48 AM
Yep CMN_SCH_JOB_RUNS contains the run details (and CMN_SCH_JOBS / CMN_SCH_JOB_DEFINITIONS the details ...
Anon Anon
Jan 25, 2012 02:10 PM
Thank you both. I took a quick look at the tables and think that they will work. Thanks again.
1.
Reports on Reports
0
Recommend
Anon Anon
Posted Jan 24, 2012 04:35 PM
Reply
Reply Privately
Options Dropdown
Is there a way to get reports on recent report activity? That is, which reports have been run, by whom, and how long they took to run? We are using Business Objects, on a separate server, and are running Clairty V12.
Thank you.
2.
RE: Reports on Reports
1
Recommend
Deactivated User
Posted Jan 24, 2012 05:03 PM
Reply
Reply Privately
Options Dropdown
If they are launched from Clarity they should appear with other "jobs" in cmn_sch_job_runs table.
Martti K.
3.
RE: Reports on Reports
1
Recommend
Anon Anon
Posted Jan 25, 2012 02:03 AM
Reply
Reply Privately
Options Dropdown
Hi Mush,
Even you can see in CMS history as well for the particular report, the following information you will get: Start time,End Time, Duration....etc.
Regards,
Abhishek Jain
4.
RE: Reports on Reports
0
Recommend
Anon Anon
Posted Jan 25, 2012 03:48 AM
Reply
Reply Privately
Options Dropdown
Yep CMN_SCH_JOB_RUNS contains the run details (and CMN_SCH_JOBS / CMN_SCH_JOB_DEFINITIONS the details of what was job/report was run).
You can also get the user parameter information from CMN_SCH_JOB_RUN_PARAMS if you need it.
The info gets "tidied up" of CMN_SCH_JOBS_RUNS (depending on your system housekeeping settings); so you might like to archive off the report dataerm statistics/analysis / summary of the report data as a regular interval if you are trying to keep long-term statistics/analysis over your report usage.
5.
RE: Reports on Reports
0
Recommend
Anon Anon
Posted Jan 25, 2012 02:10 PM
Reply
Reply Privately
Options Dropdown
Thank you both. I took a quick look at the tables and think that they will work. Thanks again.
×
New Best Answer
This thread already has a best answer. Would you like to mark this message as the new best answer?
Skip Navigation Links
Footer
Copyright 2023. All rights reserved.
Powered by Higher Logic