Files to Query

Several scripts
Post Reply
User avatar
GNappo
Nouveau
Nouveau
Posts: 70
Joined: 03 Sep 2007 12:00
Location: Italy

Post by GNappo » 20 Jul 2009 9:13

Hi Jakep,

You can use "Reporting Facilities" through the "emreportcli" utility.

Would you please look at "CONTROL-M/Enterprise Manager User Guide" documentation.

Best Regards

Giuseppe Nappo

User avatar
philmalmaison
Nouveau
Nouveau
Posts: 1148
Joined: 08 Jun 2007 12:00
Location: Ile de France

Post by philmalmaison » 21 Jul 2009 11:16

hy,
statistics are made by controlm servers about there own jobs.
common way is to use both ctmpsm and ctmruninf utilities.

regards
philmalmaison

User avatar
th_alejandro
Nouveau
Nouveau
Posts: 188
Joined: 26 Nov 2008 12:00
Location: Bogotá

SQL of course...

Post by th_alejandro » 22 Jul 2009 12:35

Try this ....

SELECT a.nodeid||'|'||
b.applic||'|'||
b.applgroup||'|'||
a.jobname||'|'||
a.runcount||'|'||
to_date(a.startrun, 'YYYYMMDDHH24MISS')||'|'||
to_date(a.endrun, 'YYYYMMDDHH24MISS')||'|'||
trunc((to_date(a.endrun, 'YYYYMMDDHH24MISS')-to_date(a.startrun, 'YYYYMMD
DHH24MISS'))*24*60*60)||'|'
FROM ctmuser.cmr_jobinf a,
ctmuser.cmr_ajf b
WHERE a.orderno = b.orderno
AND b.odate = '&1'
AND a.oscompstat = 0
ORDER BY a.jobname, a.runcount ;


You can change oscompstat field value as you need. Replace &1 with odate required. This SQL is designed for Oracle, adjunt sintax for other database engines.

User avatar
master4usrcm
Nouveau
Nouveau
Posts: 12
Joined: 08 Mar 2010 12:00
Location: Bangalore India

Post by master4usrcm » 12 Apr 2010 5:27

You can use Select * from CMR_STATIS;...with this you can get all the details.

Post Reply