RE: [ISSForum] SiteProtector - Sensor status query job

[MacKinnon, David (ISS Atlanta)]

Eric,

 

Here's a list that I have.  I"m not sure if the list is complete, but I hope it helps.

 

Dave

 

 

    UNUSED         = 0

    NOT_RESPONDING = 1

    AVAILABLE      = 2

    SCANNING       = 3

    UPGRADING      = 4

    UNKNOWN        = 5

    INITIALIZING   = 6

    ACTIVE         = 7

    STOPPED        = 8

    PAUSED         = 9

    UPDATING       = 10

    STARTING       = 11

    STOPPING       = 12

    PAUSING        = 13

    RESUMING       = 14

    APPLYING_POLICY= 15

    APPLYING_RESPONSE_FILE=16

    APPLYING_PROPERTY_FILE=17

    LAUCHING_XPU_INSTALL = 18

    LAUNCHING_XPU_UNINSTALL =19

    REVOKING_MASTER_STATUS = 20

    ERROR            =21

    UNKNOWN_PRODUCT_TYPE = 22

    LICENSEFAILURE                        = 23

    DISABLED             = 24

    CONNECTING           = 25

    CLOSED               = 26

    ONLINE               = 27

    OFFLINE               = 28

    IDLE            =29

---

From: [EMAIL PROTECTED] On Behalf Of Lewis, Eric
Sent: Wednesday, January 21, 2004 9:31 AM
To: [EMAIL PROTECTED]
Subject: [ISSForum] SiteProtector - Sensor status query job

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