RE: [SA-list] SQL column values

[Dirk Bulinckx]

SA can populate the db.  If you want to create a report from that db, you'll need a report writer.   Dirk Bulinckx.   From: Servers Alive Discussion List [mailto:[EMAIL PROTECTED] On Behalf Of Farrell,Bob Sent: Saturday, November 04, 2006 7:16 PM To: Servers Alive Discussion List Subject: RE: [SA-list] SQL column values Is there any documentation on how to create reports ( other than executive alerts ) that I could email each morning to show uptime, downtime, duration of outage, etc.? Can I do it with JUST Servers Alive and a backend DB, or do I need another reporting tool to extract the data?   Regards, Bob Farrell   From: Servers Alive Discussion List [mailto:[EMAIL PROTECTED] On Behalf Of Dirk Bulinckx Sent: Friday, September 29, 2006 4:21 AM To: Servers Alive Discussion List Subject: RE: [SA-list] SQL column values   The column names are not 100% correct in your mail.   Host:    prettyname OR hostname UniqueID: unique ID given by SA status: current status (1=down, 3=unavailable,4=maintenance, 5=up) previosustatus: previousstatus laststatuschange: when did it change from previousstatus to status previousstatuschange: when did it change to previousstatus timing: time it was on previousstatus       Dirk Bulinckx. If you think "Servers Alive" should get the Epsilon-award, then vote for us on: http://voting.euroconference.org/poll.html     From: Servers Alive Discussion List [mailto:[EMAIL PROTECTED] On Behalf Of Divya Nanjappa Sent: Thursday, September 28, 2006 9:36 PM To: Servers Alive Discussion List Subject: [SA-list] SQL column values Hi – I’m a bit confused about certain columns that Salive creates and logs in SQL: Could someone clear up the exact meanings of these fields?   Table:  salivestats Columns:  statuschange, laststatuschange, previousstatuschange, timing, uniqueid, hostid     Thanks, Div   To unsubscribe send a message with UNSUBSCRIBE as subject to salive@woodstone.nu If you use auto-responders (like out-of-the-office messages), then make sure that they are not send to the list nor to the individual members of the list that send a message. Doing this will get you removed from the list. To unsubscribe send a message with UNSUBSCRIBE as subject to salive@woodstone.nu If you use auto-responders (like out-of-the-office messages), then make sure that they are not send to the list nor to the individual members of the list that send a message. Doing this will get you removed from the list. To unsubscribe send a message with UNSUBSCRIBE as subject to salive@woodstone.nu If you use auto-responders (like out-of-the-office messages), then make sure that they are not send to the list nor to the individual members of the list that send a message. Doing this will get you removed from the list. To unsubscribe send a message with UNSUBSCRIBE as subject to salive@woodstone.nu If you use auto-responders (like out-of-the-office messages), then make sure that they are not send to the list nor to the individual members of the list that send a message. Doing this will get you removed from the list.