ADSM-L

Operation Report customized by contact question

2005-09-21 18:22:16
Subject: Operation Report customized by contact question
From: Ryan Cooper <Ryan.Cooper AT LAWSON DOT COM>
To: ADSM-L AT VM.MARIST DOT EDU
Date: Wed, 21 Sep 2005 17:07:02 -0500
Hey got a few questions.
First my goal is to deliver a report that contains Client Schedules, and
Files missed to each person who is listed as a contact for a node.  This
report must only include data for nodes that they are a contact for.

So I create a Report with the following.
Client Schedule Status  Select node_name from nodes where contact like
'%%Contact name%%'
Then I added a new item with the following statement select
nodename,substr(char(date_time), 1, 16) as "TME",message from actlog where
(msgno=4005 or msgno=4007 or msgno=4018 or msgno=4037 or msgno=4987) and
(date_time between current_timestamp - 24 hours and current_timestamp) and
nodename in (select node_name from nodes where contact like '%contact
name%') order by nodename asc

This works great but I'm wondering A: is this the best way to get this
report done?  B: If this one report takes 15 minutes to run what is going
to happen to the server if I run 25 of these reports at about the same
time?

Also does anyone know what process name this shows up on the server as.

TSM Version 5.2 Level 4.1 On AIX
Thanks for any help or input.
Ryan Cooper

<Prev in Thread] Current Thread [Next in Thread>