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 [email protected] TO UNSUBSCRIBE OR CHANGE YOUR SUBSCRIPTION, go to https://atla-mm1.iss.net/mailman/listinfo/issforum To contact the ISSForum Moderator, send email to [EMAIL PROTECTED] The ISSForum mailing list is hosted and managed by Internet Security Systems, 6303 Barfield Road, Atlanta, Georgia, USA 30328.
