I have a very large domain, 800+ clients, where the owner would like his
reports broken out by schedule, starting with the not used in last 30 day
report. I think the appropriate select should look something like:
select associations.schedule_name,associations.node_name from asso
ciations where associations.node_name in (select nodes.node_name from nodes
wher
e (((30 < days(current_timestamp) - days(backup_end)) or backup_end is null and
domain_name='SSD')) group by associations.schedule_name
I'm at the point where I'm getting the 'additional tokens needed' message,
which usually denotes unbalanced parentheses, but I can't see where. All
help greatly appreciated.
Fred Johanson
ITSM Administrator
University of Chicago
773-702-8464
|