Could be that you wrote the class_name in lower case instead of higher case
?

René Lambelet
Nestec S.A. / Informatique du Centre 
55, av. Nestlé  CH-1800 Vevey (Switzerland) 
*+41'21'924'35'43  7+41'21'924'28'88  * K4-117
email rene.lambelet AT nestle DOT com
Visit our site: http://www.nestle.com

        This message is intended only for the use of the addressee and 
        may contain information that is privileged and confidential.



> -----Original Message-----
> From: Gina Glenewinkel [SMTP:gglenewi AT CSC DOT COM]
> Sent: Tuesday, April 17, 2001 5:18 PM
> To:   ADSM-L AT VM.MARIST DOT EDU
> Subject:      finding unused mgmt classes - why didn't this work?
> 
> Some time ago I posted to this list a question about how to find out if my
> old management classes are still managing any client data.  A couple of
> you
> responded suggesting this select statement:   select * from archives where
> class_name='classname'   and the same for backups.  I ran this on several
> management classes and got "no match found for this query".  Thinking that
> meant there was no data found governed by that management class, I deleted
> it and got the expected message about any data will be rebound to the
> default management class.  I did not expect any data to be rebound.  Turns
> out, I deleted some active management classes by mistake because I thought
> they weren't being used.
> 
> Can anyone tell me why my select statement didn't work as expected?
> 
> /gina