Top
Systemwalker Service Quality Coordinator User's Guide (WebsiteManagement Functions Edition)
Systemwalker

15.3.1 Report data file

The Service Level Reporter can be used to download the data used for creating reports as a CSV file.

See

Refer to "12.5.3 Report contents" for the download procedure.

The following explains the format of the CSV files.


15.3.1.1 Report data file format

This explains the format of the CSV files which are downloadable from reports.

Summary

Column position

Content

1

Time (UTC base)

2

Internal control information

3

"summary"

4 to 5

Internal control information

6

Total number of sessions

7

Internal control information

8

Total number of requests

9

Internal control information

10

Total traffic (byte)

11

Internal control information

12

Number of hits

13

Internal control information

14

Number of hits (client)

15

Internal control information

16

Number of hits (server)

17

Internal control information

18

Number of hits (remote)

19

Internal control information

20

Number of errors


Session report (by time segment)

Column position

Content

1

Time (UTC base)

2

Internal control information

3

"session"

4 to 5

Internal control information

6

Period

7

Internal control information

8

Number of sessions (count)


Session report (by other report type)

Request report (by time segment)

Column position

Content

1

Time (UTC base)

2

Internal control information

3

"request"

4 to 5

Internal control information

6

Period

7

Internal control information

8

Number of requests (count)

9

Internal control information

10

Request average (milliseconds)

11

Internal control information

12

Total traffic (byte)


Request report (by other report type)

Traffic report (by time segment)

Column position

Content

1

Time (UTC base)

2

Internal control information

3

"traffic"

4 to 5

Internal control information

6

Period

7

Internal control information

8

Total traffic (byte)

9

Internal control information

10

Number of requests (count)

11

Internal control information

12

Request average (milliseconds)


Traffic report (by other report type)

Cache report

Column position

Content

1

Time (UTC base)

2

Internal control information

3

"cache"

4 to 5

Internal control information

6

Occurrence location

7

Internal control information

8

Number of hits (count)

9

Internal control information

10

Number of successful requests (count)

11

Internal control information

12

Total successful traffic (byte)

13

Internal control information

14

Successful request average (milliseconds)

15

Internal control information

16

Percentage (%)


Error report (by error location)

Column position

Content

1

Time (UTC base)

2

Internal control information

3

"error"

4 to 5

Internal control information

6

Occurrence location

7

Internal control information

8

Number of errors (count)

9

Internal control information

10

Percentage (%)


Error report (by error record)

Column position

Content

1

Time (UTC base)

2

Internal control information

3

"error"

4 to 5

Internal control information

6

Error code

7

Internal control information

8

Number of errors (count)

9

Internal control information

10

Percentage (%)


Response report

Column position

Content

1

Time (UTC base)

2

Internal control information

3

"response"

4 to 5

Internal control information

6

Value corresponding to the report type (such as URL)

7

Internal control information

8

Average response time (milliseconds)

9

Internal control information

10

Maximum response time (milliseconds)

11

Internal control information

12

Minimum response time (milliseconds)


Page navigation report

Column position

Content

1

Time (UTC base)

2

Internal control information

3

"pagenavi"

4 to 5

Internal control information

6

URL

7

Internal control information

8

Number of requests (count)

9

Internal control information

10

Staying time (seconds)

11

Internal control information

12

Percentage (%)

* Records are output for each URL in descending order of frequently accessed paths.


Number of actually visiting users

Column position

Content

1

Date (local time base)

2

Time (local time base)

3

Client host name

4

Client IP address

5

Authentication user name

6

Remote host name

7

Remote IP address

8

URL

9

Entry request count

10

Exit request count

11

Number of sessions (count)

12

Access ID