Let's start with something like ...

mminfo -s server -q "invalid,savetime>1 day ago" -r client,name |sort -u 

Increase the range by increasing day count in above query.

HTH

Th 

-----Original Message-----
From: EMC NetWorker discussion [mailto:NETWORKER AT LISTSERV.TEMPLE DOT EDU] On
Behalf Of Stan Horwitz
Sent: mercredi 30 juillet 2008 21:36
To: NETWORKER AT LISTSERV.TEMPLE DOT EDU
Subject: [Networker] Query for failed backups

Rather then trying to reinvent the wheel, I am wondering if anyone here has
a query that will give me a list of clients who's backups failed. This is
for NetWorker 7.4.1 on Solaris 10.

To sign off this list, send email to listserv AT listserv.temple DOT edu and 
type
"signoff networker" in the body of the email. Please write to
networker-request AT listserv.temple DOT edu if you have any problems with this
list. You can access the archives at
http://listserv.temple.edu/archives/networker.html or via RSS at
http://listserv.temple.edu/cgi-bin/wa?RSS&L=NETWORKER

To sign off this list, send email to listserv AT listserv.temple DOT edu and 
type "signoff networker" in the body of the email. Please write to 
networker-request AT listserv.temple DOT edu if you have any problems with this 
list. You can access the archives at 
http://listserv.temple.edu/archives/networker.html or
via RSS at http://listserv.temple.edu/cgi-bin/wa?RSS&L=NETWORKER