SiteScope Log File Columns

When SiteScope runs a monitor instruction to test the avialability of components in the infrastructure, the monitor results are written to data log files. In the default configuration, these log files are tab-delimited text files. Understanding the order and content of these files is useful for examining particular monitor results or for porting the SiteScope monitor results to another database.

This chapter describes:

Common Data Log Content
Monitor Specific Log Column Content

Common Data Log Content

top

The first six columns of each log entry in a SiteScope monitor data log are the same for each monitor type. The following tabledescribes the content of these columns. As noted, the columns in each log file are written as tab-delimited text.

Common Data Log Columns


Column	Data in Column
1	time and date the sample was recorded
2	category (for example, `good`, `error`,`warning`, `nodata`)
3	monitor group name where the monitor defined (also called ownerID)
4	monitor title text
5	stateString (this is the status string that shows up on the Monitor Group Detail Page)
6	id:sample number (a unique ID for this monitor where group + id is a unique key for a monitor). Thesample number is a unique sample number for that monitor.

The following is an example of the first six columns of data results as recorded in a SiteScope data log for four different monitors. The results are from monitor runsbetween 3:43 p.m. and 4:13 p.m. on September 16th, 2003. The results for these runs were recorded as good.

Monitor Specific Log Column Content

top

After the first six columns of each log entry, the content of each column may vary according to the monitor type. The following tables the data written to the monitor results log for the indicated monitor types.

Monitor Type: Apache Server


Column	Data in Column
1	`date`
2	`category`
3	`ownerID`
4	`Title`
5	`stateString`
6	`_id`
7	`Counter 1 Value`
8	`Counter 2 Value`
9	`Counter 3 Value`
10	`Counter 4 Value`
11	`Counter 5 Value`
12	`Counter 6 Value`
13	`Counter 7 Value`
14	`Counter 8 Value`
15	`Counter 9 Value`
16	`Counter 10 Value`

Monitor Type: ASP Server


Column	Data in Column
1	`date`
2	`category`
3	`ownerID`
4	`Title`
5	`stateString`
6	`_id`

Monitor Type: Formula Composite


Column	Data in Column
1	`date`
2	`category`
3	`ownerID`
4	`Title`
5	`stateString`
6	`_id`
7	`Result`
8	`status`

Monitor Type: Browsable Windows Performance Counters


Column	Data in Column
1	`date`
2	`category`
3	`ownerID`
4	`Title`
5	`stateString`
6	`_id`
7	`counters in error`

Monitor Type: SNMP by MIB


Column	Data in Column
1	`date`
2	`category`
3	`ownerID`
4	`Title`
5	`stateString`
6	`_id`
7	`counters in error`

Monitor Type: BroadVision Application Server


Column	Data in Column
1	`date`
2	`category`
3	`ownerID`
4	`Title`
5	`stateString`
6	`_id`
7	`counters in error`

Monitor Type: CheckPoint Firewall-1


Column	Data in Column
1	`date`
2	`category`
3	`ownerID`
4	`Title`
5	`stateString`
6	`_id`
7	`Counter 1 Value`
8	`Counter 2 Value`
9	`Counter 3 Value`
10	`Counter 4 Value`
11	`Counter 5 Value`
12	`Counter 6 Value`
13	`Counter 7 Value`
14	`Counter 8 Value`

Monitor Type: Cisco Works


Column	Data in Column
1	`date`
2	`category`
3	`ownerID`
4	`Title`
5	`stateString`
6	`_id`
7	`counters in error`

Monitor Type: Citrix Server


Column	Data in Column
1	`date`
2	`category`
3	`ownerID`
4	`Title`
5	`stateString`
6	`_id`
7	`counters in error`

Monitor Type: ColdFusion Server


Column	Data in Column
1	`date`
2	`category`
3	`ownerID`
4	`Title`
5	`stateString`
6	`_id`

Monitor Type: Composite


Column	Data in Column
1	`date`
2	`category`
3	`ownerID`
4	`Title`
5	`stateString`
6	`_id`
7	`% items OK`
8	`% items in error`
9	`% items in warning`
10	`items in error`
11	`items in warning`
12	`items OK`
13	`items checked`

Monitor Type: CPU Utilization


Column	Data in Column
1	`date`
2	`category`
3	`ownerID`
4	`Title`
5	`stateString`
6	`_id`
7	`utilization`

Monitor Type: Database Query


Column	Data in Column
1	`date`
2	`category`
3	`ownerID`
4	`Title`
5	`stateString`
6	`_id`
7	`status`
8	`round trip time`
9	`result column 1`
10	`result column 2`
11	`rows`
12	`content match`

Monitor Type: DB2


Column	Data in Column
1	`date`
2	`category`
3	`ownerID`
4	`Title`
5	`stateString`
6	`_id`
7	`counters in error`

Monitor Type: DHCP


Column	Data in Column
1	`date`
2	`category`
3	`ownerID`
4	`Title`
5	`stateString`
6	`_id`
7	`round trip time`
8	`Leased IP Address`

Monitor Type: Directory


Column	Data in Column
1	`date`
2	`category`
3	`ownerID`
4	`Title`
5	`stateString`
6	`_id`
7	`number of files`
8	`total of file sizes`
9	`directory exists`
10	`access permitted`
11	`time since modified`

Monitor Type: Disk Space


Column	Data in Column
1	`date`
2	`category`
3	`ownerID`
4	`Title`
5	`stateString`
6	`_id`
7	`percent full`
8	`MB free`

Monitor Type: DNS


Column	Data in Column
1	`date`
2	`category`
3	`ownerID`
4	`Title`
5	`stateString`
6	`_id`
7	`status`
8	`round trip time`
9	`statusText`

Monitor Type: Dynamo Application Server


Column	Data in Column
1	`date`
2	`category`
3	`ownerID`
4	`Title`
5	`stateString`
6	`_id`
7	`Counter 1 Value`
8	`Counter 2 Value`
9	`Counter 3 Value`
10	`Counter 4 Value`
11	`Counter 5 Value`
12	`Counter 6 Value`
13	`Counter 7 Value`

Monitor Type: eBusiness Chain


Column	Data in Column
1	`date`
2	`category`
3	`ownerID`
4	`Title`
5	`stateString`
6	`_id`
7	`% items OK`
8	`% items in error`
9	`% items in warning`
10	`items in error`
11	`items in warning`
12	`items OK`
13	`items checked`

Monitor Type: F5 Big-IP


Column	Data in Column
1	`date`
2	`category`
3	`ownerID`
4	`Title`
5	`stateString`
6	`_id`
7	`counters in error`

Monitor Type: File


Column	Data in Column
1	`date`
2	`category`
3	`ownerID`
4	`Title`
5	`stateString`
6	`_id`
7	`size`
8	`file age`
9	`content match`

Monitor Type: FTP


Column	Data in Column
1	`date`
2	`category`
3	`ownerID`
4	`Title`
5	`stateString`
6	`_id`
7	`status`
8	`round trip time`
9	`size`

Monitor Type: Health of SiteScope Server


Column	Data in Column
1	`date`
2	`category`
3	`ownerID`
4	`Title`
5	`stateString`
6	`_id`
7	`counters in error`

Monitor Type: Health of SiteScope Server


Column	Data in Column
1	`date`
2	`category`
3	`ownerID`
4	`Title`
5	`stateString`
6	`_id`
7	`Counter 1 Value`
8	`Counter 2 Value`
9	`Counter 3 Value`
10	`Counter 4 Value`
11	`Counter 5 Value`
12	`Counter 6 Value`
13	`Counter 7 Value`
14	`Counter 8 Value`
15	`Counter 9 Value`
16	`Counter 10 Value`
17	`Counter 11 Value`
18	`Counter 12 Value`
19	`Counter 13 Value`
20	`Counter 14 Value`
21	`Counter 15 Value`
22	`Counter 16 Value`
23	`Counter 17 Value`
24	`Counter 18 Value`
25	`Counter 19 Value`
26	`Counter 20 Value`

Monitor Type: History Health Monitor


Column	Data in Column
1	`date`
2	`category`
3	`ownerID`
4	`Title`
5	`stateString`
6	`_id`
7	`numErrors`

Monitor Type: IIS Server


Column	Data in Column
1	`date`
2	`category`
3	`ownerID`
4	`Title`
5	`stateString`
6	`_id`

Monitor Type: LDAP


Column	Data in Column
1	`date`
2	`category`
3	`ownerID`
4	`Title`
5	`stateString`
6	`_id`
7	`status`
8	`round trip time`

Monitor Type: Link Check


Column	Data in Column
1	`date`
2	`category`
3	`ownerID`
4	`Title`
5	`stateString`
6	`_id`
7	`link errors`
8	`total links`
9	`total graphics`
10	`average`

Monitor Type: Log Event Health Monitor


Column	Data in Column
1	`date`
2	`category`
3	`ownerID`
4	`Title`
5	`stateString`
6	`_id`
7	`Counter 1 Value`
8	`Counter 2 Value`
9	`Counter 3 Value`
10	`Counter 4 Value`
11	`Counter 5 Value`
12	`Counter 6 Value`
13	`Counter 7 Value`
14	`Counter 8 Value`
15	`Counter 9 Value`
16	`Counter 10 Value`
17	`Counter 11 Value`
18	`Counter 12 Value`
19	`Counter 13 Value`
20	`Counter 14 Value`
21	`Counter 15 Value`
22	`Counter 16 Value`
23	`Counter 17 Value`
24	`Counter 18 Value`
25	`Counter 19 Value`
26	`Counter 20 Value`

Monitor Type: Log File


Column	Data in Column
1	`date`
2	`category`
3	`ownerID`
4	`Title`
5	`stateString`
6	`_id`
7	`matches/min`
8	`lines/min`

Monitor Type: Mail


Column	Data in Column
1	`date`
2	`category`
3	`ownerID`
4	`Title`
5	`stateString`
6	`_id`
7	`round trip time`
8	`status`
9	`content match`
10	`Send time`
11	`Receive time`

Monitor Type: MAPI


Column	Data in Column
1	`date`
2	`category`
3	`ownerID`
4	`Title`
5	`stateString`
6	`_id`
7	`Round Trip`

Monitor Type: Master Health Monitor


Column	Data in Column
1	`date`
2	`category`
3	`ownerID`
4	`Title`
5	`stateString`
6	`_id`
7	`numErrors`

Monitor Type: Memory


Column	Data in Column
1	`date`
2	`category`
3	`ownerID`
4	`Title`
5	`stateString`
6	`_id`
7	`percent used`
8	`MB free`
9	`pages/sec`

Monitor Type: MG Health Monitor


Column	Data in Column
1	`date`
2	`category`
3	`ownerID`
4	`Title`
5	`stateString`
6	`_id`
7	`numErrors`

Monitor Type: Monitor Load Monitor


Column	Data in Column
1	`date`
2	`category`
3	`ownerID`
4	`Title`
5	`stateString`
6	`_id`
7	`Counter 1 Value`
8	`Counter 2 Value`
9	`Counter 3 Value`
10	`Counter 4 Value`
11	`Counter 5 Value`
12	`Counter 6 Value`
13	`Counter 7 Value`
14	`Counter 8 Value`
15	`Counter 9 Value`
16	`Counter 10 Value`
17	`Counter 11 Value`
18	`Counter 12 Value`
19	`Counter 13 Value`
20	`Counter 14 Value`
21	`Counter 15 Value`
22	`Counter 16 Value`
23	`Counter 17 Value`
24	`Counter 18 Value`
25	`Counter 19 Value`
26	`Counter 20 Value`

Monitor Type: iPlanet Server


Column	Data in Column
1	`date`
2	`category`
3	`ownerID`
4	`Title`
5	`stateString`
6	`_id`
7	`Counter 1 Value`
8	`Counter 2 Value`
9	`Counter 3 Value`
10	`Counter 4 Value`
11	`Counter 5 Value`
12	`Counter 6 Value`
13	`Counter 7 Value`
14	`Counter 8 Value`
15	`Counter 9 Value`
16	`Counter 10 Value`

Monitor Type: Network Bandwidth


Column	Data in Column
1	`date`
2	`category`
3	`ownerID`
4	`Title`
5	`stateString`
6	`_id`
7	`counters in error`

Monitor Type: Network


Column	Data in Column
1	`date`
2	`category`
3	`ownerID`
4	`Title`
5	`stateString`
6	`_id`
7	`bytes/sec received`
8	`bytes/sec sent`
9	`packet errors/sec`
10	`Active connections`

Monitor Type: News


Column	Data in Column
1	`date`
2	`category`
3	`ownerID`
4	`Title`
5	`stateString`
6	`_id`
7	`status`
8	`round trip time`
9	`number of articles`

Monitor Type: Windows Performance Counter


Column	Data in Column
1	`date`
2	`category`
3	`ownerID`
4	`Title`
5	`stateString`
6	`_id`
7	`Counter 1 Value`
8	`Counter 1 Percent Deviation`
9	`measurement0`
10	`lastMeasurement0`
11	`Counter 2 Value`
12	`Counter 2 Percent Deviation`
13	`measurement1`
14	`lastMeasurement1`
15	`Counter 3 Value`
16	`Counter 3 Percent Deviation`
17	`measurement2`
18	`lastMeasurement2`
19	`countersInError`

Monitor Type: Windows Dial-up


Column	Data in Column
1	`date`
2	`category`
3	`ownerID`
4	`Title`
5	`stateString`
6	`_id`
7	`total time`
8	`% monitors good`
9	`monitorCount`
10	`monitorErrorCount`
11	`monitorWarningCount`
12	`time to connect`
13	`time to authorize`

Monitor Type: Windows Event Log


Column	Data in Column
1	`date`
2	`category`
3	`ownerID`
4	`Title`
5	`stateString`
6	`_id`
7	`match count`
8	`records examined`
9	`matches in interval`

Monitor Type: Oracle9i Application Server


Column	Data in Column
1	`date`
2	`category`
3	`ownerID`
4	`Title`
5	`stateString`
6	`_id`
7	`Counter 1 Value`
8	`Counter 2 Value`
9	`Counter 3 Value`
10	`Counter 4 Value`
11	`Counter 5 Value`
12	`Counter 6 Value`
13	`Counter 7 Value`
14	`Counter 8 Value`
15	`Counter 9 Value`
16	`Counter 10 Value`

Monitor Type: Oracle Database


Column	Data in Column
1	`date`
2	`category`
3	`ownerID`
4	`Title`
5	`stateString`
6	`_id`
7	`counters in error`

Monitor Type: Windows Resources


Column	Data in Column
1	`date`
2	`category`
3	`ownerID`
4	`Title`
5	`stateString`
6	`_id`
7	`counters in error`

Monitor Type: Ping


Column	Data in Column
1	`date`
2	`category`
3	`ownerID`
4	`Title`
5	`stateString`
6	`_id`
7	`status`
8	`round trip time`
9	`% packets good`

Monitor Type: Port


Column	Data in Column
1	`date`
2	`category`
3	`ownerID`
4	`Title`
5	`stateString`
6	`_id`
7	`status`
8	`round trip time`

Monitor Type: Global Port


Column	Data in Column
1	`date`
2	`category`
3	`ownerID`
4	`Title`
5	`stateString`
6	`_id`
7	`status`
8	`round trip time`
9	`% locations good`
10	`round trip time from this server`

Monitor Type: Radius


Column	Data in Column
1	`date`
2	`category`
3	`ownerID`
4	`Title`
5	`stateString`
6	`_id`
7	`status`
8	`round trip time`

Monitor Type: Real Media Player


Column	Data in Column
1	`date`
2	`category`
3	`ownerID`
4	`Title`
5	`stateString`
6	`_id`
7	`Counter 1 Value`
8	`Counter 2 Value`
9	`Counter 3 Value`
10	`Counter 4 Value`
11	`Counter 5 Value`
12	`Counter 6 Value`
13	`Counter 7 Value`
14	`Counter 8 Value`
15	`Counter 9 Value`
16	`Counter 10 Value`
17	`Counter 11 Value`
18	`Counter 12 Value`
19	`Counter 13 Value`
20	`Counter 14 Value`
21	`Counter 15 Value`
22	`Counter 16 Value`
23	`Counter 17 Value`
24	`Counter 18 Value`
25	`Counter 19 Value`
26	`Counter 20 Value`

Monitor Type: Real Media Server


Column	Data in Column
1	`date`
2	`category`
3	`ownerID`
4	`Title`
5	`stateString`
6	`_id`

Monitor Type: RTSP


Column	Data in Column
1	`date`
2	`category`
3	`ownerID`
4	`Title`
5	`stateString`
6	`_id`
7	`status`
8	`download time`
9	`downloaded bytes`
10	`download rate (bps)`
11	`media time`
12	`start latency`
13	`download play duration`

Monitor Type: SAP


Column	Data in Column
1	`date`
2	`category`
3	`ownerID`
4	`Title`
5	`stateString`
6	`_id`
7	`counters in error`

Monitor Type: SAP Portal


Column	Data in Column
1	`date`
2	`category`
3	`ownerID`
4	`Title`
5	`stateString`
6	`_id`
7	`counters in error`

Monitor Type: Script


Column	Data in Column
1	`date`
2	`category`
3	`ownerID`
4	`Title`
5	`stateString`
6	`_id`
7	`status`
8	`round trip time`

Monitor Type: Service


Column	Data in Column
1	`date`
2	`category`
3	`ownerID`
4	`Title`
5	`stateString`
6	`_id`
7	`status`
8	`processes`
9	`cpu`
10	`memory`

Monitor Type: SilverStream Server


Column	Data in Column
1	`date`
2	`category`
3	`ownerID`
4	`Title`
5	`stateString`
6	`_id`
7	`Counter 1 Value`
8	`Counter 2 Value`
9	`Counter 3 Value`
10	`Counter 4 Value`
11	`Counter 5 Value`
12	`Counter 6 Value`
13	`Counter 7 Value`
14	`Counter 8 Value`
15	`Counter 9 Value`
16	`Counter 10 Value`

Monitor Type: SNMP


Column	Data in Column
1	`date`
2	`category`
3	`ownerID`
4	`Title`
5	`stateString`
6	`_id`
7	`status`
8	`value`

Monitor Type: SNMP Trap


Column	Data in Column
1	`date`
2	`category`
3	`ownerID`
4	`Title`
5	`stateString`
6	`_id`
7	`matches/min`
8	`matches/min`
9	`value`
10	`value2`
11	`value3`
12	`value4`

Monitor Type: SQL Server


Column	Data in Column
1	`date`
2	`category`
3	`ownerID`
4	`Title`
5	`stateString`
6	`_id`

Monitor Type: SunONE WebServer


Column	Data in Column
1	`date`
2	`category`
3	`ownerID`
4	`Title`
5	`stateString`
6	`_id`
7	`counters in error`

Monitor Type: Sybase


Column	Data in Column
1	`date`
2	`category`
3	`ownerID`
4	`Title`
5	`stateString`
6	`_id`
7	`counters in error`

Monitor Type: Tuxedo


Column	Data in Column
1	`date`
2	`category`
3	`ownerID`
4	`Title`
5	`stateString`
6	`_id`
7	`counters in error`

Monitor Type: URL Content


Column	Data in Column
1	`date`
2	`category`
3	`ownerID`
4	`Title`
5	`stateString`
6	`_id`
7	`status`
8	`round trip time`
9	`statusText`
10	`size`
11	`age`
12	`dns time`
13	`response time`
14	`download time`
15	`connect time`
16	`content match`
17	`matchValue2`
18	`matchValue3`
19	`matchValue4`
20	`matchValue5`
21	`matchValue6`
22	`matchValue7`
23	`matchValue8`
24	`matchValue9`
25	`matchValue10`

Monitor Type: URL List


Column	Data in Column
1	`date`
2	`category`
3	`ownerID`
4	`Title`
5	`stateString`
6	`_id`
7	`duration`
8	`errors`
9	`good`
10	`left`

Monitor Type: URL


Column	Data in Column
1	`date`
2	`category`
3	`ownerID`
4	`Title`
5	`stateString`
6	`_id`
7	`status`
8	`round trip time`
9	`statusText`
10	`size`
11	`age`
12	`content match`
13	`dns time`
14	`response time`
15	`download time`
16	`connect time`
17	`overall status`
18	`total errors`

Monitor Type: URL Original


Column	Data in Column
1	`date`
2	`category`
3	`ownerID`
4	`Title`
5	`stateString`
6	`_id`
7	`status`
8	`round trip time`
9	`statusText`
10	`size`
11	`age`
12	`content match`
13	`dns time`
14	`response time`
15	`download time`
16	`connect time`
17	`overall status`
18	`total errors`

Monitor Type: URL Sequence


Column	Data in Column
1	`date`
2	`category`
3	`ownerID`
4	`Title`
5	`stateString`
6	`_id`
7	`status`
8	`round trip time`
9	`statusText`

Monitor Type: WebLogic 5.x Application Server


Column	Data in Column
1	`date`
2	`category`
3	`ownerID`
4	`Title`
5	`stateString`
6	`_id`
7	`Counter 1 Value`
8	`Counter 2 Value`
9	`Counter 3 Value`
10	`Counter 4 Value`
11	`Counter 5 Value`
12	`Counter 6 Value`
13	`Counter 7 Value`
14	`Counter 8 Value`

Monitor Type: WebLogic Application Server


Column	Data in Column
1	`date`
2	`category`
3	`ownerID`
4	`Title`
5	`stateString`
6	`_id`
7	`counters in error`

Monitor Type: Web Server


Column	Data in Column
1	`date`
2	`category`
3	`ownerID`
4	`Title`
5	`stateString`
6	`_id`
7	`hits`
8	`bytes transferred`
9	`hits/min`
10	`bytes/min`

Monitor Type: Web Service


Column	Data in Column
1	`date`
2	`category`
3	`ownerID`
4	`Title`
5	`stateString`
6	`_id`
7	`status`
8	`round trip time`

Monitor Type: WebSphere Application Server


Column	Data in Column
1	`date`
2	`category`
3	`ownerID`
4	`Title`
5	`stateString`
6	`_id`
7	`counters in error`

Monitor Type: WebSphere Performance Servlet


Column	Data in Column
1	`date`
2	`category`
3	`ownerID`
4	`Title`
5	`stateString`
6	`_id`
7	`counters in error`

Monitor Type: Windows Media Server


Column	Data in Column
1	`date`
2	`category`
3	`ownerID`
4	`Title`
5	`stateString`
6	`_id`

Monitor Type: Windows Media Player


Column	Data in Column
1	`date`
2	`category`
3	`ownerID`
4	`Title`
5	`stateString`
6	`_id`
7	`Counter 1 Value`
8	`Counter 2 Value`
9	`Counter 3 Value`
10	`Counter 4 Value`
11	`Counter 5 Value`
12	`Counter 6 Value`
13	`Counter 7 Value`
14	`Counter 8 Value`
15	`Counter 9 Value`
16	`Counter 10 Value`
17	`Counter 11 Value`
18	`Counter 12 Value`
19	`Counter 13 Value`
20	`Counter 14 Value`
21	`Counter 15 Value`
22	`Counter 16 Value`
23	`Counter 17 Value`
24	`Counter 18 Value`
25	`Counter 19 Value`
26	`Counter 20 Value`

Monitor Type: Sample Directory


Column	Data in Column
1	`date`
2	`category`
3	`ownerID`
4	`Title`
5	`stateString`
6	`_id`
7	`number of files`
8	`total of file sizes`
9	`directory exists`

Monitor Type: Sample File


Column	Data in Column
1	`date`
2	`category`
3	`ownerID`
4	`Title`
5	`stateString`
6	`_id`
7	`file size`
8	`file exists`

Monitor Type: Sample Script


Column	Data in Column
1	`date`
2	`category`
3	`ownerID`
4	`Title`
5	`stateString`
6	`_id`
7	`status`
8	`round trip time`

Monitor Type: Multi-Parameter Sample


Column	Data in Column
1	`date`
2	`category`
3	`ownerID`
4	`Title`
5	`stateString`
6	`_id`
7	`myStateProperty Label`