Planification (TSM)

Fiche express
Tables SQL	associations, client_schedules
Rôle	Sauvegardes automatiques pilotées par l'ordonnanceur interne TSM
Voir aussi	Nœud (TSM) · Dsmc

Les schedules permettent d'associer des nœuds à des sauvegardes automatiques pilotées par l'ordonnanceur interne de TSM. Leur usage n'est pas obligatoire : l'ordonnancement peut aussi être délégué à un outil externe (cron, etc.).

Nœuds sans schedule associé

SELECT node_name FROM nodes WHERE node_name NOT IN (SELECT node_name FROM associations)

-- Nombre de nœuds sans schedule associé
SELECT COUNT(*) FROM nodes WHERE node_name NOT IN (SELECT node_name FROM associations)

Nœuds avec schedule associé

SELECT node_name FROM nodes WHERE node_name IN (SELECT node_name FROM associations)

Nombre de nœuds par schedule

SELECT domain_name, schedule_name, count(*) FROM associations GROUP BY domain_name, schedule_name

Détail schedules et associations

SELECT associations.domain_name, associations.node_name, associations.schedule_name,
  client_schedules.description, client_schedules.action, client_schedules.options,
  client_schedules.objects, client_schedules.starttime FROM associations,
  client_schedules WHERE associations.domain_name = client_schedules.domain_name
  AND associations.schedule_name = client_schedules.schedule_name ORDER BY associations.domain_name,
  associations.node_name, associations.schedule_name

Détail complet (nœud, association, schedule)

SELECT associations.domain_name, associations.node_name, associations.schedule_name,
  client_schedules.description, client_schedules.action, client_schedules.options,
  client_schedules.objects, client_schedules.priority, client_schedules.startdate,
  client_schedules.starttime, client_schedules.duration, client_schedules.durunits,
  client_schedules.period, client_schedules.perunits, client_schedules.dayofweek,
  client_schedules.expiration, client_schedules.chg_time, client_schedules.chg_admin,
  client_schedules.profile, client_schedules.sched_style, client_schedules.enh_month,
  client_schedules.dayofmonth, client_schedules.weekofmonth FROM associations,
  client_schedules WHERE associations.domain_name = client_schedules.domain_name
  AND associations.schedule_name = client_schedules.schedule_name ORDER BY associations.node_name,
  associations.domain_name, associations.schedule_name

Voir aussi

• Nœud (TSM) · Dsmc · Journal (TSM)