Re: SQL command
2002-03-06 19:11:02
This actually isn't a very easy question to answer, and I'm not sure how
useful this data would be. Files from a single node can be bound to
multiple management classes, so you would have to check each file. If you
really want to let your TSM database grind away for a while, you can try
this, but be warned, it'll take quite a while. I've occasionally crashed
TSM servers with big queries, and that might happen with this one.
select class_name, node_name from backups group by class_name, node_name
I _THINK_ that'll work, but I didn't want to try it on my server.
Good luck.
Alex Paschal
Storage Administrator
Freightliner, LLC
(503) 745-6850 phone/vmail
|
<Prev in Thread] |
Current Thread |
[Next in Thread>
|
- SQL command, Wholey, Joseph (TGA\MLOL)
- Re: SQL command, Prather, Wanda
- Re: SQL command, Williams, Tim P {PBSG}
- Re: SQL command, Williams, Tim P {PBSG}
- Re: SQL command,
Alex Paschal <=
- Re: SQL command, Seay, Paul
- SQL command, TGAMLOL
- SQL command, TGAMLOL
- Re: SQL command, Prather , Wanda [mailto:Wanda.Prather
|
|
|