Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.
Comment: Reverted from v. 8

When the reporting section is opened the user is presented with a list of report definitions. As with in other sections the list can be filtered and searched.

Image RemovedImage Added

Generate Report

By double clicking on one of the report definitions in the list or by clicking the the Generate button button (or or Generate report in in the task list in the inspector bar) the user can open a wizard for an existing report definition.

...

Select one of the existing report definition to generate a report from or use as a basis for your new report definition.

Image RemovedImage Added

If the user double clicked one of the rows in the report definition list this step in the wizard is skipped.

...

In the second step the user has the option of editing the filter. She might want to make some adjustments of the fields in the filter of the selected report definition, for example extending a time span or selecting a different username. But there also nothing stopping her from changing the filter completely and defining her own report.

Image RemovedImage Added

Conditions and parenthesis:

...

It is possible to add parenthesis to create subconditions with a different operator. The report definition shown in the screenshot here above can be read as follows: "Last seen must must be less than one month ago,  lost must must be true and either either claimed or  or usage must must be true". I.e. shown me hosts that have not answered during discovery in the last month that are either claimed or in us.

...

StringNumber, Timespan, DateBoolean, Pick-list, Object
equals
doesn't equal
contains
doesn't contain
starts with
doesn't start with
ends with
doesn't end with
matches regex
doesn't match regex
=
!=
<
>
<=
>=
is
is not

 

Step 3: Select columns

Then the user can select which columns to include in the output.

Image RemovedImage Added

All available columns are selected by default.

Step 4: Run report

Image RemovedImage Added

Press the Finish button to run the report and get the results.

...

If the report definition provided gives results the user is presented with a preview (at maximum the first hundred records).

Image RemovedImage Added

The results can then be downloaded by pressing the download button. The dropdown offers a number of file formats to select from.

Image RemovedImage Added

Sylk and CSV are handy for importing the data into a spreadsheet application for further processing.

...

As is there are 24 report definitions in the list under Reporting. Twelve of those are what might be called base report sources, either sources that allow the user to query one particular object type in the system (e.g.  Activity) or or more sources that give access to a particular data relation in the system (e.g.   Host discovery). The other twelve report definition are derivatives of the base report sources showing the specification possibilities they offer,  Zone creation/deletion building upon  building upon Activity and  and IP reconciliation building upon  building upon Host discovery.

BaseDerivatives

Activity



Access*
Address space merge conflicts*
DHCP lease activity
Discovered hardware addresses with multiple addresses*
DNS records

DNS zones
Host discovery*

IP ranges
Lease hardware address with multiple IP addresses*
Men & Mice suite messages
SOA Records

Administrator login
New users added
Range creation/deletion
Zone creation/deletion




Address records
Multi-labeled hosts
Enabled DNS zones of type slave
IP reconciliation
Discovered devices



SOA records with abnormal minimum TTL value
SOA records with abnormal refresh value

...

<datetime> ::= <date> <time>
<time> ::= HH:MM[:SS[:TTT]][ AM|PM]
<date> ::= [yy]yy-mm-dd
| dd.mm.yy[yy]
| mm/dd/yy[yy]

Timestamps formatted according to RFC3339.

...

To include more than one value for a particual field the field has to be added again to the filter with a Or condition. The Address records is an example of that, where the record type field has to be either A or AAAA.

Image RemovedImage Added