Neohapsis is currently accepting applications for employment. For more information, please visit our website www.neohapsis.com or email email@example.com
[ISSForum] Removing Site Protector Objects
From: Mohr James (james.mohrelaxy.com)
Date: Fri Oct 07 2005 - 12:55:44 CDT
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.
ISSForum mailing list
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.