From: Lewis, Eric (Eric.Lewismail.va.gov)
Date: Wed Jan 21 2004 - 08:30:41 CST

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

I am trying to setup a SQL Agent Job to run a query that looks for sensor
status changes since ISS hasn't included such a basic service into
SiteProtector. I have found the status field in the dbo.Component table in
the SiteProtector schema but I can't find the corresponding table for the
numeric values in the Status column. I believe that 7=Active, 28=Offline,
24=Not Managed, and 29=Idle but I can't find the table that lists all the
values.

My plan is to set the job to run a query every 5 minutes, looking for status
changes in Status column, and then email/page me. I would of thought ISS
would've built this in but it should be easy enough to create if I can find
out what all of the Status integer values correspond to in the Console
status display.

If anyone has any ideas please let me know.

Eric

_______________________________________________
ISSForum mailing list
ISSForumiss.net

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

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