show schedules only with some Expiration date

[rogwall]

I want to see what client schedules have some value for the Expiration field.

One way is to run TSM> q sched type-client f=d, and the save it to a text file and run a grep on that. The file is too long so I dont want to/can't do that.



Is there a way to do it within TSM admin client to query such schedules only?



thanks in advance.

:-o

 

[crazymad]

You can just use following select:



select * from client_schedules where expiration is not null



quering such schedules is not possible (by the query command).

 

[rogwall]

that fully did what I needed.



thanks much.