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
