[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
RE: [ISSForum] SiteProtector - Sensor status query job
Here's a list that I have. I"m not sure if the list
is complete, but I hope it helps.
NOT_RESPONDING = 1
AVAILABLE = 2
SCANNING = 3
UPGRADING = 4
INITIALIZING = 6
UPDATING = 10
STARTING = 11
STOPPING = 12
RESUMING = 14
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.