I've played around with this select before and I've never been able to get it
perfected.
I'm looking for something that will tell me the information below for the
active policy set and default management class
associations.node_name
client_schedules.schedule_name
client_schedules.startdate
client_schedules.starttime
client_schedules.period
client_schedules.perunits
client_schedules.dayofweek
bu_copygroups.domain_name
bu_copygroups.class_name
bu_copygroups.verexists
bu_copygroups.verdeleted
bu_copygroups.retextra
bu_copygroups.retonly
This is the closest I've gotten with a select, the problem is it returned bogus
information for other domains. I know it's wrong I just have no idea how to
correct it or if it's possible with the TSM SQL engine. If any of you SQL
wizards have an idea or even an alternate better solution to get this
information I'd greatly appreciate hearing what you have.
select associations.node_name, client_schedules.schedule_name,
client_schedules.startdate, client_schedules.starttime,
client_schedules.period, client_schedules.perunits, client_schedules.dayofweek,
domains.domain_name, domains.defmgmtclass, bu_copygroups.verexists,
bu_copygroups.verdeleted, bu_copygroups.retextra, bu_copygroups.retonly from
client_schedules, domains, bu_copygroups, associations associations where
client_schedules.schedule_name=associations.schedule_name and
bu_copygroups.class_name=domains.defmgmtclass
|