ADSM-L

Re: good books on queries

2006-10-20 07:27:50
Subject: Re: good books on queries
From: Matthew Warren <Matthew.Warren AT DIGICA DOT COM>
To: ADSM-L AT VM.MARIST DOT EDU
Date: Fri, 20 Oct 2006 12:26:34 +0100
Hi Avy,

Have a look at the SELECT statement, and find out about the available
TSM database tables for query.

There are lots of useful select statements to search for in this list.

Matt. 

> -----Original Message-----
> From: ADSM: Dist Stor Manager [mailto:ADSM-L AT VM.MARIST DOT EDU] 
> On Behalf Of Avy Wong
> Sent: 19 October 2006 21:38
> To: ADSM-L AT VM.MARIST DOT EDU
> Subject: [ADSM-L] good books on queries
> 
> hello,
>       Can anyone refer me  to some good books or links on 
> Tivoli commands?
> I understand IBM site themselves have some reference to it , 
> but the query
> commands are not quite enough to do what I would like to do, 
> may be I need
> to find more information about complex query . I appreciate 
> if anyone can
> send me to the right direction. Currently the simple ones I 
> am using are
> ........
> 
> q actlog begint=-36 search=UCONNEPIC01
> 
> run qevent
> 
> q session
> 
> q mount
> 
> q script
> 
> q assoc * *
> 
> q node * format=detailed
> 
> Question: What if I want to know only specific information 
> i.e. 'Days Since
> Last Access' instead of all the details, how do I go about 
> doing that? Will
> a regular sequel select statement do?
> 
> Thank you for your help.
> 
> Avy Wong
> Business Continuity Administrator
> Mohegan Sun
> 1 Mohegan Sun Blvd
> Uncasville, CT 06382
> ext 28164
> 
> 
> **************************************************************
> ************************************
> The information contained in this message may be privileged 
> and confidential and
> protected from disclosure. If the reader of this message is 
> not the intended recipient, or
> an employee or agent responsible for delivering this message 
> to the intended recipient,
> you are hereby notified that any dissemination, distribution, 
> or copy of this
> communication is strictly prohibited. If you have received 
> this communication in error,
> please notify us immediately by replying to the message and 
> deleting it from your
> computer.
> **************************************************************
> ************************************
> 
> 
>  
> 


This email is confidential and may be privileged. If you are not the intended 
recipient please notify the sender immediately and delete the email from your 
computer. 

You should not copy the email, use it for any purpose or disclose its contents 
to any other person.
Please note that any views or opinions presented in this email may be personal 
to the author and do not necessarily represent the views or opinions of Digica.
It is the responsibility of the recipient to check this email for the presence 
of viruses. Digica accepts no liability for any damage caused by any virus 
transmitted by this email.

UK: Phoenix House, Colliers Way, Nottingham, NG8 6AT UK
Reception Tel: + 44 (0) 115 977 1177
Support Centre: 0845 607 7070
Fax: + 44 (0) 115 977 7000
http://www.digica.com

SOUTH AFRICA: Building 3, Parc du Cap, Mispel Road, Bellville, 7535, South 
Africa
Tel: + 27 (0) 21 957 4900
Fax: + 27 (0) 21 948 3135
http://www.digica.com

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