You are viewing an old version of this page. View the current version.

Compare with Current View Page History

Version 1 Next »

Introduction

NOTE - Page under revision for v2.0.

How Does it Work?

Summaries are designed to group items by a particular matching column and then to provide a link to individual devices. In the preV2 days, this was a report and subreport. We have now separated these into what we call Summaries.

Summaries have a different 'collection' template to the other resources within Open-AudIT. This template shows the Summary as you would expect and also shows buttons with counts of other resources. This page is designed to be the HomePage of Open-AudIT.

Creating a Summaries Entry

A summary can be created using the web interface if a user has a role that contains the summaries::create permission. Go to menu -> Resources -> Summaries -> Create. There is also a create button on the collection page.

When viewing a summary, a default set of columns are provided - name, count, and view. The Name column is the name of the column you are grouping devices by. IE - In the Manufacturer Summary, the name column would be the system.manufacturer column from the database. The count is the number of devices with this attribute and the view is a button to view those particular devices.

There is also an option to provide additional columns for viewing. In the case of the Software Summary, you can see we also provide the software name and version. These are not shown on the initial summary page but rather added to the list of attributes shown when viewing the next page. IE - Show me the actual devices with MS Office installed. This page will also show the are name and version in addition to the default columns.

View Summary Details

Go to menu -> Admin -> Summaries -> List Summaries.

You will see a list of summaries. You can view a summary by clicking on the ID (in green).

You can execute the summary and see the results by clicking the Execute icon in blue.

You can also edit or delete the summary.

Database Schema

The schema for the database is below. It can also be found in the application is the user has database::read permission by going to menu -> Admin -> Database -> List, then clicking on the summaries table.

CREATE TABLE `summaries` (
`id` int(10) unsigned NOT NULL AUTO_INCREMENT,
`name` varchar(100) NOT NULL DEFAULT '',
`org_id` int(10) unsigned NOT NULL DEFAULT '1',
`table` varchar(100) NOT NULL DEFAULT '',
`column` varchar(100) NOT NULL DEFAULT '',
`extra_columns` text NOT NULL,
`edited_by` varchar(200) NOT NULL DEFAULT '',
`edited_date` datetime NOT NULL DEFAULT '2000-01-01 00:00:00',
PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=13 DEFAULT CHARSET=utf8;

A typical entry looks as below.

           id: 6
         name: Manufacturers
       org_id: 1
        table: system
       column: manufacturer
extra_columns: system.model
    edited_by: system
  edited_date: 2000-01-01 00:00:00
  • No labels