Custom XML Reports

Introduction

Many of the Network Monitor products available today include pre-formatted, standard reports, and custom reports can be desinged on demand.

ActiveXperts has a different approach by providing XML/XSL based reports. XML files are used for describing the report data, while XSL Stylesheets are used for formatting the report. If you are used to HTML, formatting a report through XSL will be pretty easy.

The 'Availability Reports' and 'Detail Report' can be customized only when using the XML-based Report format, with an XSL Stylesheet linked to it.

All customizations are made by modifying the XSL Stylesheets, like:

• Including/excluding checks from the report;
• Different sorting in the report;
• Including/excluding columns from the report;
• Changing HTML tags, like titles, tables, colors, sizes, etc.

By default, two XSL Report Stylesheets are delivered with the product:

• AvailabilityReport.xsl - default XSL Stylesheet for XML based 'Availability Report';
• DetailReport.xsl - default XSL Stylesheet for XML based 'Detail Report'.

Use a normal Text editor to make changes to the XSL Stylesheets. The default AvailabilityDetails.xsl and AvailabilitySummary.xsl stylesheets can be found in the \Server\XmlReports directory.

For those who are new to XML and XSL, it's recommended to visit the W3Schools Online Web Tutorials site and read the XML and XSL chapters.

Tags in the 'Availability' Report

The following tags are defined in the 'Availability Report' XML report and can be used in the related XSL Stylesheet file:

Tag	Description
<from-secs>	Begin time of report, in seconds after 01/01/1970
<from-date>	Begin time of report, in date format (i.e. mm/dd/yyyy)
<to-secs>	End time of report, in seconds after 01/01/1970
<to-date>	End time of report, in date format (i.e. mm/dd/yyyy)
<description>	Description of the Report
<check/id>	ID of the check, as it is used throughout the whole program
<check/displayname>	DisplayName of the check, as it is used throughout the whole program
<check/check>	Check Type. See below for all possible values
<check/folder>	Folder where the check is located
<check/uncertain-secs>	Total amount of time (in seconds) that check had status: Uncertain
<check/uncertain-hrsmin>	Total amount of time (in hh:mm format) that check had status: Uncertain
<check/uncertain-pct>	Total amount of time (in percentage of total Report time) that check had status: Uncertain
<check/success-secs>	Total amount of time (in seconds) that check had status: Success
<check/success-hrsmin>	Total amount of time (in hh:mm format) that check had status: Success
<check/success-pct>	Total amount of time (in percentage of total Report time) that check had status: Success
<check/failure-secs>	Total amount of time (in seconds) that check had status: Failure
<check/failure-hrsmin>	Total amount of time (in hh:mm format) that check had status: Failure
<check/failure-pct>	Total amount of time (in percentage of total Report time) that check had status: Failure
<check/maintenance-secs>	Total amount of time (in seconds) that check had status: Maintenance
<check/maintenance-hrsmin>	Total amount of time (in hh:mm format) that check had status: Maintenance
<check/maintenance-pct>	Total amount of time (in percentage of total Report time) that check had status: Maintenance
<check/onhold-secs>	Total amount of time (in seconds) that check had status: On Hold
<check/onhold-hrsmin>	Total amount of time (in hh:mm format) that check had status: On Hold
<check/onhold-pct>	Total amount of time (in percentage of total Report time) that check had status: On Hold
<check/depfailure-secs>	Total amount of time (in seconds) that check had status: Dependee Failure
<check/depfailure-hrsmin>	Total amount of time (in hh:mm format) that check had status: Dependee Failure
<check/depfailure-pct>	Total amount of time (in percentage of total Report time) that check had status: Dependee Failure
<check/notprocessed-secs>	Total amount of time (in seconds) that check had status: Not Processed
<check/notprocessed-hrsmin>	Total amount of time (in hh:mm format) that check had status: Not Processed
<check/notprocessed-pct>	Total amount of time (in percentage of total Report time) that check had status: Not Processed

Tags in the 'Detail' Report

The following tags are defined in the 'Detail Report' XML report and can be used in the related XSL Stylesheet file:

Tag	Description
<from-secs>	Begin time of report, in seconds after 01/01/1970
<to-secs>	End time of report, in seconds after 01/01/1970
<from-date>	Begin time of report, in date format (i.e. mm/dd/yyyy)
<to-date>	End time of report, in date format (i.e. mm/dd/yyyy)
<description>	Description for this report
<check/id>	ID of the check, as it is used throughout the whole program
<check/displayname>	DisplayName of the check, as it is used throughout the whole program
<check/checktype>	Type of check (friendly string). For possible values, see below
<check/checktype-id>	Type of check (number). For possible values, see below
<check/folder>	Name of the folder where the check is located
<check/event/from-secs>	Begin time of the event, in seconds after 01/01/1970
<check/event/from-date>	Begin time of the event, in date format (i.e. mm/dd/yyyy)
<check/event/from-time>	Begin time of the event, in time format (i.e. hh:mm:ss)
<check/event/to-secs>	End time of the event, in seconds after 01/01/1970
<check/event/to-date>	End time of the event, in date format (i.e. mm/dd/yyyy)
<check/event/to-time>	End time of the event, in time format (i.e. hh:mm:ss)
<check/event/result>	The last result of the check (friendly string). For possible values, see below
<check/event/result-id>	The last result of the check (number). For possible values, see below
<check/event/duration-secs>	Duration of the event, in seconds
<check/event/duration>	Duration of the event, formatted as: 'xx hrs yy min'
<check/event/duration-pct>	Duration of the event (percent)
<check/event/reason>	Reason for the result of this check

---

Network Monitor Check Types

ActiveXperts Network Monitor defines the following Check Types:

Type ID	Description
0	<UNDEFINED TYPE>
1	<FOLDER>
10	Icmp
11	TraceRoute
20	Disk Space
30	Tcp/Ip
31	Pop3
32	Smtp
33	Http(s)
34	Ftp
35	Rsh
36	Dns
37	Snmp Get
38	Nntp
39	IMAP
40	Ntp
41	Temperature
42	Snmp Trap Receive
43	Ssh
44	Citrix ICA
45	DHCP
50	Service
60	File
61	Registry
70	Anti-Virus/Anti-Spam
71	MS Active Directory
72	MS Hyper-V Server
73	MS Exchange Server
74	MS IIS Server
75	MS ISA Server
76	MS SharePoint Server
77	MS SQL Server
78	Windows Defender
79	MS BizTalk
80	MS Index Server
81	Citrix XenApp
82	MS Forefront TMG
83	MS Dynamics
90	Event Log (Classic)
100	VBScript
110	ODBC
111	ADO/SQL
112	Oracle
120	MS Terminal Server
130	Cpu
140	Directory
150	Disk
160	Floppy
170	Memory
180	Printer
190	Process
200	Humidity
201	Power
202	Light
203	Motion
204	Smoke
205	Door
206	Resistance
207	SwitchNC
208	SwitchNO
210	Wetness
220	Scheduled Task (NT)
221	Scheduled Task
230	WinLogon
240	SMTP to POP3
250	MSMQ
270	TFTP
280	Remote Command
290	PowerShell
300	Radius
310	Sftp
320	WMI Counters
321	Performance Counters
330	Removable Drives
340	Smpp
350	Vmware
360	XenServer

---

Network Monitor Result Types

ActiveXperts Network Monitor defines the following Results:

Result ID	Description
0	Uncertain
1	Success
2	Error
3	Failure
4	Maintenance
5	On Hold
6	Dependee Error
7	Dependee Failure
99	Not Processed