HI Guys I'm struggling with the Operational Reporter again.
Why, oh why, if the fact that the summary table data is known to be unreliable, do so many scripts in the Operational Reporter query the summary table? I'm now sitting with management jumping up and down because their report states that several servers were not backed up, when in fact they were. If I query the summary table for one of the nodes, the last entry is as follows: START_TIME: 2003-12-09 21:30:21.000000 END_TIME: 2003-12-09 22:32:41.000000 ACTIVITY: BACKUP NUMBER: 1132 ENTITY: SERVER1 COMMMETH: Tcp/Ip ADDRESS: 112.123.132.132:-26552 SCHEDULE_NAME: UNIX_DAILY EXAMINED: 201373 AFFECTED: 7445 FAILED: 1 BYTES: 0 IDLE: 0 MEDIAW: 0 PROCESSES: 1 SUCCESSFUL: YES VOLUME_NAME: DRIVE_NAME: LIBRARY_NAME: LAST_USE: COMM_WAIT: Querying the activity log for the same node, I get the following: 10-12-2003 22:41:49 ANE4952I (Session: 1643, Node: SERVER1) Total number of objects inspected: 190,453 10-12-2003 22:41:49 ANE4954I (Session: 1643, Node: SERVER1) Total number of objects backed up: 9,697 10-12-2003 22:41:49 ANE4958I (Session: 1643, Node: SERVER1) Total number of objects updated: 0 10-12-2003 22:41:49 ANE4960I (Session: 1643, Node: SERVER1) Total number of objects rebound: 0 10-12-2003 22:41:49 ANE4957I (Session: 1643, Node: SERVER1) Total number of objects deleted: 0 10-12-2003 22:41:49 ANE4970I (Session: 1643, Node: SERVER1) Total number of objects expired: 17,850 10-12-2003 22:41:49 ANE4959I (Session: 1643, Node: SERVER1) Total number of objects failed: 0 10-12-2003 22:41:49 ANE4961I (Session: 1643, Node: SERVER1) Total number of bytes transferred: 28.06 GB 10-12-2003 22:41:49 ANE4963I (Session: 1643, Node: SERVER1) Data transfer time: 632.31 sec 10-12-2003 22:41:49 ANE4966I (Session: 1643, Node: SERVER1) Network data ransfer rate: 46,536.74 KB/sec 10-12-2003 22:41:49 ANE4967I (Session: 1643, Node: SERVER1) Aggregate data transfer rate: 6,846.09 KB/sec 10-12-2003 22:41:49 ANE4968I (Session: 1643, Node: SERVER1) Objects compressed by: 0% 10-12-2003 22:41:49 ANE4964I (Session: 1643, Node: SERVER1) Elapsed processing time: 01:11:38 10-12-2003 22:41:49 ANR2507I Schedule UNIX_DAILY for domain UNIXDOM started at 10-12-2003 21:30:00 for node SERVER1 completed successfully at 10-12-2003 22:41:49. Hmm. What happened to the summary data for the 10th? Is there any way to clear the contents of the summary table, and start afresh? Or will the final version of the Operational Reporter not use an unreliable data source? Leigh. This communication is subject to specific restrictions and disclaimers. Details are contained at the following link: http://www.omam.com/OMAMSA_E-mail_Disclosure/