  | Administrator Handbook | TOC |
You can make your database queries from the LoriotPro WEB interface. This interface uses PHP script embedded in html page for performing the queries.
The DataBase access allows you to perform queries on the SQL Tables of the Database.
There are 4 tables.
The PHP scripts dedicated to the Loriotpro Table queries are available in the directory bin/www/www.
Warning : The PHP interpreter should be installed and
configured else this option will not work. Install PHP before using
The home page of the LoritoPro WEB server has a menu with the option Database. Clicking on it will displays the Query tool.
Database
access from a WEB navigator
A new window is open with 4 buttons that gives you access to the various tables.
LoriotPro WEB access window
The Host table that contains the Hosts defined in the directory. This table is filled by the Import tool.
If we choose the Host button a frame is added to the window with a multi criterium selection.
If you perfom a query without changing any options, you will see the first 50 records of the Host table. By default the Table display the IP address, the host name and the MAC address.
The result is displayed in the third frame.
You can also apply a filter on the column contents. You can select a filter based on IP address, Host name and MAC address.
Example with a filter on the Host name
If you perfom a query without changing any options, you will see the first 50 records of the Network table.
The Network table provides the following columns
| l_network_id | IP address of the network |
| l_mask | IP Network Mask |
| l_name | Network Name define in the directory |
| l_ifdesc | Interface Description (router on which the network is attached) |
| l_iftype | Network type |
| l_speed | Speed of the link in bits/s |
You can also apply a filter on the column contents.
The Event table that contains the events received since the LoriotPro and ODBC starting.
If we choose the Events button a frame is added to the window with a multi criterium selection.
If you perfom a query without changing any options, you will see the first 50 records of the Event table.
By default the table provides the time and date of the event, the level (severity), the description of the event (l_string), the LoriotPro IP address the has generated the events.
The level is also provided at the begining of the l_string field under its numeric format.
The Netflow table provide flow statistics collected by the Netflow Collector Plug-in.
Using this table is described in the following document.
www.loriotpro.com |
|