From: Mohr James (james.mohrelaxy.com)
Date: Fri Oct 07 2005 - 12:55:44 CDT

• Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]

Hi All!

We have an automated script that regular checks the Site Protector
database to see if the server sensor is OK. If not, (i.e in one of
several different states), the script sends a message.

I removed a node from the system, but it is apparently still in the
database somewhere, which is somewhat understandable. The query I use
looks like this:

select SensorName, status, LastModifiedAt, EventCollectorID from
dbo.Component where deleted=0

Since I am looking only for nodes that are not deleted. But I expect it
to have been deleted. However, running the query directly, I still see
the node that should have been deleted. It has a status of 1, whereas
all of the other nodes have a status of 7. I cannot find to which table
the status field of the Components table relates, so I am not sure if I
can simply say "where status <> 1".

Any info would be greatly appreaciated.

Regards,

Jim Mohr

_______________________________________________
ISSForum mailing list
ISSForumiss.net

TO UNSUBSCRIBE OR CHANGE YOUR SUBSCRIPTION, go to https://atla-mm1.iss.net/mailman/listinfo/issforum

To contact the ISSForum Moderator, send email to mod-issforumiss.net

The ISSForum mailing list is hosted and managed by Internet Security Systems, 6303 Barfield Road, Atlanta, Georgia, USA 30328.

• Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]