SiteMeter Reporting Module Read.Me Contents

Installing SiteMeter Reporting Module

Using BTRIEVE

About SiteMeter's Reporting Module
	What Is SiteMeter's Reporting Module?
	How Does It Work?

Using the SiteMeter Reporting Module
	Accessing the Reporting Module
	Exporting Files
	Generating Reports
	The Report Screen
	Printing From SREPORT

SREPORT's Reporting Options
	Report Types
	Metering Definitions Report
	Application Summary Report
	Application with User Detail Report
	Application with User Summary Report
	User Summary Report
	User with Application Detail Report
	User with Application Summary Report
	File Integrity Activity Report
	SPA Compliance Report
	Software Purchase Forecast Report
	Upgrade Purchase Forecast Report


Installing SiteMeter's Reporting Module

Uncompress the REPORT.EXE (a self-extracting ZIP file) that you 
have either downloaded from CompuServe or received from Brightwork 
Development, Inc. Technical Support.  The result of the uncompress 
operation will be 44 files which should be copied to your SiteMeter 
directory and a READ.ME file in text format with installation and 
usage information for SREPORT.

Use the standard Windows procedure for creating an icon for
SREPORT on your Windows desktop--Program Manager/File/New/Program Item.

NOTE:  SREPORT must be run from a networked drive.  It cannot run from a 
local drive.

Using BTRIEVE

SREPORT uses Novell's BTRIEVE as a database access method.  If you want 
SREPORT to employ the "server-based" flavor of Btrieve (i.e., the Btrieve 
NLM), then BREQUEST.EXE must be loaded at the workstation prior to running 
Windows. BRQ.BAT (which is included in this package) will load BREQUEST with 
parameters.  Using BREQUEST in conjunction with the Btrieve NLM will speed 
up the reports and take up less memory at the workstation.  If you do not 
have BREQUEST.EXE, it can be found in the Novell Libraries on Compuserve (GO 
NOVLIB, Library 7, Filename: BTRREQ.EXE).

If you'd rather use the "local" flavor of Btrieve (i.e., BTRIEVE.EXE), 
there is no need to load a TSR prior to running Windows.  However, you 
will need to:

    (1) add the following Btrieve section to your WIN.INI:

        [btrieve]
        options=/p:3072 /f:22 /t:btr.trn /e

    (2) disable the "Btrieve requestor for Windows" (WBTRCALL.DLL) by 
        renaming it to something else (e.g., "rename wbtrcall.dll 
        wbtrcall.brq").  The version of WBTRCALL.DLL that ships with this 
        package has a size of 10,987 bytes.

Please note that the local flavor of Btrieve (BTRIEVE.EXE) is much slower 
than the server-based version (BREQUEST/BTRIEVE NLM).


If you plan to use the Btrieve NLM, the following tasks must be 
performed at the file server console (or use RCONSOLE):

At the : prompt type:

     MODULES

This checks to see if BTRIEVE.NLM and the BSPXCOM.NLM are loaded.
You must make sure that any other users that are using the .NLM's close
their applications before you go any further.

Then, type:

     BSTOP

This is an .NCF file that should be in the SYS:SYSTEM directory.  It unloads 
the BSPXCOM.NLM first and then BTRIEVE.NLM.  It is very important that the
.NLM files are unloaded in this order.

Then, type:

   LOAD BSETUP

This menu application allows you to set the configurations for the 
BTRIEVE.NLM and the BSPXCOM.NLM.  The following minimum values must appear
in the configuration fields:

     Number of open files     22
     Number of transaction     1
     Largest record size   17000
     Largest page size      4096
     Number of sessions       15

Then, ESCape and save.

Then, type:

     BSTART

This is an .NCF file that should be in the SYS:SYSTEM directory.  It loads
the BTRIEVE.NLM first and then the BSPXCOM.NLM.  It is very important that
the .NLM files are loaded in this order.

NOTE:  The new configurations will not take effect until BTRIEVE.NLM and
BSPXCOM.NLM are unloaded and reloaded.

Then, exit from RCONSOLE.

To unload BTRIEVE TSR or BREQUEST from the PC memory, once out of Windows,
type,

     ENDBTRV
			 
About SiteMeter's Reporting Module

What Is SiteMeter's Reporting Module?

The SiteMeter Reporting Module, SREPORT, is a flexible tool designed to 
help you generate reports based on SiteMeter activity.  It puts important 
information about application usage and software security at your 
fingertips.  

Using its simple Windows interface, you can generate the report you need 
quickly and easily.  SREPORT offers a variety of report types and formats, 
so you can choose the one best-suited to your business needs.  For 
example, run a report on a single user to see what applications he or she is 
using, or run a report on all network applications that you meter to see 
which applications are being used the most to determine additional 
software needs.  All of this flexibility is at your fingertips with SREPORT.

SREPORT also lets you export coded data into standard database formats.  
You can choose the database format best-suited to your needs.

How Does It Work?

SREPORT has two components--exporting files and generating reports.  
Once you access the reporting console, you can choose either of these two
features.

If you choose to export files, the Reporting Module prompts you for the 
source, format and destination of the desired files.  Once you specify all 
of this information, SREPORT exports the file(s) to the desired location.

If you choose to generate a report, SREPORT requests information about 
the source files, report type, report filters and report destination.  Once 
you specify all of this information, SREPORT generates the report to the 
desired location.

Using the SiteMeter Reporting Module

Accessing the Reporting Module

Follow these steps to access SREPORT:
1.      Run Windows.
2.      Access the Reporting Module by double clicking on the SREPORT 
	icon.

The SiteMeter Report main menu appears.

The menu bar in this window offers the following options:
File:    Export coded data into standard database format, print 
	 reports and exit SREPORT
Reports: Generate a report on software usage or security data
Window:  Standard Windows dialog box for manipulating open windows
Help:    Access SREPORT's on-line help utility

Exporting Files

SREPORT allows you to export coded data to a standard database format.

To export a file, do the following:

1.      From the SREPORT main menu, choose File.
2.      Choose the Export command.

The Export dialog box appears.

3.      From the Current Server list box, specify the server from which 
	you wish to export the coded file.

The current server automatically displays in the list box.  You can also 
attach to and detach from different file servers. Choose the Attach button 
to attach to another file server. The Login to File Server dialog box 
appears if you are not already attached to that file server. Enter your 
login name and password (if applicable) and choose the OK button. Choose 
the Detach button to detach from a file server.

4.      Select one of the input options to specify the source of the data 
	you are exporting.

The options are:  Sitedata, Virusdta, Metering or Security Definitions.  
Sitedata and Virusdta are the files where SiteMeter stores its information. 
The Metering and Security Definitions options retrieve the information 
directly from the bindery. To select an option, simply click on the 
appropriate radio button. 

NOTE:
If you choose Sitedata or Virusdta, the Default and Browse push buttons are 
enabled.  The Filename text box automatically displays the default filename.
You can also specify a different filename (if Sitedata or Virusdta was 
stored in a different place) by entering a filename or by choosing the 
Browse button. Choosing the Browse button produces the standard Windows 
Browse dialog box. Once you select the desired file and choose the OK 
button, the filename you selected appears in the Filename text box. 

Because the Definitions options communicate directly with the bindery to 
access information, these filename options are not needed and therefore are 
not enabled.


5.      Choose the format for the exported data from the Format list box.

The available formats include:
	Lotus 123 2.1                               .WK1
	Lotus 123 3.x                               .WK3
	Quattro                                     .WKQ
	Lotus 123 1.x                               .WKS
	Symphony 1.1-2.2                            .WR1
	Symphony 1.0                                .WRK
	Excel 2.0                                   .XL2
	Excel 3.0                                   .XL3
	dBase II                                    .DBF
	dBase III                                   .DBF
	dBase III Plus                              .DBF
	dBase IV                                    .DBF
	Data Interchange Format                     .DIF
	ASCII (Tab delimited)                       .TAB
	ASCII (Tab delimited-guess numeric values)  .TXT
	ASCII (comma delimited-min quoted)          .CSV
	ASCII (comma delimited- strings quoted)     .QSV
	ASCII (comma delimited-guess number values) .ISV
	Btrieve                                     .DAT

6.      Specify the filename for the output file.

Enter the desired filename in the Filename text box or choose the Save 
As button. Choosing the Save As button produces the standard 
Windows Save As dialog box. Once you specify the path and filename 
and choose the OK button, you are returned to the Export dialog box. 
The name you specified appears in the Filename text box.

7.      Once you have specified all the above information, choose the OK 
	button.

The Export Status dialog box appears.  This dialog box tells you:
	Server
	Input Source
	Input File
	Output File
	Output Format

NOTE:
If SiteMeter needs to read data from more than one file server to complete
the export process, then all of the above information will change to 
reflect the current file server being read.  The information in the other 
fields will also be updated to reflect the export currently taking place.

During the export, you can choose the Abort button to halt the exporting. 
This button changes to Close once the export is complete. By choosing 
Close, the output file is put into the current directory.

Generating Reports

To generate a report in SREPORT, follow these steps:
1.      Choose 'Reports' from the main menu.
2.      Choose 'Choose Report'

The SiteMeter Reports dialog box appears.
This dialog box offers the following information:
	Current Server
	Report Type
	Source
	Print Destination
	Activity Data Range
	Filter Criteria

The dialog box also has Attach, Detach, OK, and Cancel push buttons.
The functionality of all these options is explained in the following steps.

3.      From the Choose Server list box, select the server from which you 
	wish to generate a report.

The Current Server list box automatically displays your current server. 
You can select another server by choosing one from the drop down list 
box.

You can also use the Attach and Detach buttons to attach to/detach 
from other file servers.  To attach to another file server, choose the 
Attach button. The Attach to Server dialog box appears.  Choose the 
desired server from the drop down list box, enter your username and 
your password (if applicable).  When finished, choose the OK button.

4.      From the Report Types list box, select a report type.

The list box provides these options:

*       Metering Definitions 
*       File Integrity Activity (based on authorized files usage)

These reports are based on application usage:
*       Application Summary 
*       Application with User Detail
*       Application with User Summary
*       SPA Compliance
*       Software Purchase Forecast
*       Upgrade Purchase Forecast

These reports are based on user information:
*       User Summary 
*       User with Application Detail 
*       User with Application Summary 

Your report selection drives the source filename, the activity 
date range and the filter criteria.  Based on what you choose here, 
default values will appear in these three sections in the dialog box.

5.      Specify the source of the report in the Filename text box.

If the report type you selected in Step 4 uses data from a file, the file 
automatically appears in this list box.  You can choose another file by 
either directly entering one in the text box or by using the Browse 
button. The Browse button produces the standard Windows Browse 
dialog box. Once you select the path and filename and choose the OK 
button, you are returned to the Reports dialog box.  The selected file 
name appears in the Filename text box.  Choose the Default button to 
define the default file as the report source. 

6.      In the Print Destination section of the dialog box, specify where 
	you want to send the report.

The three options are Print to Window, Print to Printer, and Print to 
File. 

If you want to send the report to a file, select the appropriate file from 
the File list box.  The options are:  Space separated
				      Tab separated

7.      Set the Activity Data Range.

The From: and To: fields list the default data range (which is the entire 
date range of the file that you have specified as the source of the data). 
To change either date to view a particular range of data, double-click in 
the field. The Date Selection dialog box appears. 

The title of this box reflects the date currently set. Underneath this is 
a bar listing the year; the arrows at either end of the date bar allow you 
to go forward and backward to find a different year. Underneath that is a 
similar bar with the month. Underneath that are buttons-- one for each 
day of the month. Simply choose a button to select the appropriate 
date. 

As you change the date, the title bar changes to reflect the new date 
you are specifying. Choose the OK button to save your changes and exit 
out of the calendar; otherwise choose the Cancel button to exit without 
saving.

The new dates appear in the Reports dialog box.

NOTE:   There is no date range for Metering Definitions.

8.      In the Filter Criteria list box, specify the filter criteria you 
	wish to use for your report.

The options include Users and Applications. You can select either one 
specific user or all users; you can select one application or all 
applications. The default filter type will appear based on the report type 
you selected in Step 4.  The list in Step 4 specifies if the default will 
be based on application data, user data, or authorized files data.

9.      Once you have completed the above steps, choose the OK button.

The Export Status dialog box appears.
This dialog box tells you:
	Server
	Input Source
	Input File
	Output File
	Output Format

NOTE:
If SiteMeter needs to read data from more than one file server to 
complete the export process, then all the above information will change 
to reflect the current file server being read. The information in the 
other fields will also be updated to reflect the export currently taking 
place.

During the export, you can choose the Abort button to halt the 
exporting. This button changes to Close once the export is complete. 
By choosing Close, the output file is put into the current directory.

10.     When you close this dialog box, a window appears with the report
	name in the title bar. 

The Report Screen

Once the Export dialog box closes, the SiteMeter Report Screen appears. 
This section describes the parts of the report screen.

While the report is being generated on this screen, a ribbon of buttons 
displays to the left. The two left most buttons are arrows pointing to the 
left. The left-most sends you to the beginning of the report the other is 
previous page. The next two buttons are arrows pointing right. The first 
goes to the next page, and the other to the end of the report. The fourth 
button is the stop button. Once the first page of the report is generated, 
this button becomes enabled.  You can use it to halt the report generation 
at that point.  After that there are two additional buttons.  The first 
is page view; the second is a print button which prints the report. Most 
of these buttons are grayed during report generation. 

The next section is a box displaying the following: READ (indicating the 
files read in the database), SELECTED (indicating those files in the 
specified date range or meeting other criteria), TOTAL (indicating the 
total files in the database), and % (indicating the percentage of the 
report which is completed). All of these fields except Total change to 
reflect the real time report generation. The Next box tells you which page 
you are on, for example 1 of 18 or 2 of 18.  Beneath all of this is the 
actual report.  

Printing from SREPORT

With SREPORT, you have three options to print a generated report:
	Print to Window
	Print to Printer
	Print to File

To print a file from the SiteMeter Reporting Module, follow these steps:

1.      From the File menu, choose Print Setup.

The Print dialog box appears. 
This dialog box lets you customize the following information:
	Printer
	Print Range
	Paper Size and Source

Choose the Options button to produce the standard Windows Print Setup 
dialog box to specify additional options.  The Cancel button exits this 
dialog box without changing the setup.

2.      Specify any of the above criteria to customize your print job.
3.      If you did not choose to print to a file, you can choose from the 
	following two methods to send a print job to a printer:

*       To print to a printer, choose Reports in the Reports menu bar and 
	then choose the Printer from the Print Destinations.
*       To print to a window, choose Reports in the Report menu bar and 
	select print to window.  Once the report is generated on the screen 
	and the print button becomes enabled, choose the Print button to 
	print.

SREPORT's Reporting Options

Report Types

SREPORT offers a number of different report types for application usage 
and software security information.  Choose the report type best suited to 
your business and decision-making needs.

The following report types are offered:
*       Metering Definitions
*       Application Summary
*       Application with User Detail
*       Application with User Summary
*       User Summary
*       User with Application Detail
*       User with Application Summary
*       File Integrity Activity
*       SPA Compliance
*       Software Purchase Forecast
*       Upgrade Purchase Forecast

Metering Definitions Report

The following describes the report generated if you chose Metering 
Definitions as your report type:

The report heading details:
*       Date of report generation
*       Report type (i.e., Metering Definitions, etc.)
*       Applications on which report was generated

The report provides the following information about each application:
*       Application description (the actual path/filename being metered)
*       Metered Application Name
*       Number of licenses available
*       Length of the queue back time
*       Whether or not a password is required for this metered application

Application Summary Report

The following describes the report generated if you chose Application 
Summary as your report type:

The report heading details:
*       Date of report generation
*       Report type
*       Date range for which report was generated
*       The server on which the report was generated
*       The users on which the report was generated (either one user name or 
	All)

The report provides the following details about each application:
*       Application description (the actual path/filename being metered)
*       Metered Application Name
*       Number of licenses available
*       Peak number of concurrent users
*       Peak number of queued users
*       Total number of users
*       Total usage time 
*       Total queued users 
*       Percent utilization

This report also provides a grand summary of each of the above categories 
for all the applications included in the report.

Application with User Detail

The following describes the report generated if you chose Application 
with Usage Detail as your report type:

The report heading details:
*       Date of report generation
*       Report type
*       Date range for which report was generated
*       The server on which the report was generated
*       The users on which the report was generated (either one user name or 
	All)

The report provides the following information for each application included 
in the report:
*       Application description (the actual path/filename being metered)
*       The Metered Application Name
*       Number of licenses available
*       Peak number of concurrent users
*       Peak number of queued users
*       Total number of users
*       Total usage time 
*       Total queued users 
*       Percent utilization

Beneath all of the above information about each application, the following 
detailed information is provided about each user who used the application:
*       Date and time of usage
*       User name
*       Status (whether the user was granted access or queued)
*       Total time in minutes of usage

NOTE: The above information above is provided for every time a user 
accesses the application.

Application with User Summary

The following describes the report generated if you chose Application 
with Usage Summary as your report type:

The report heading details:
*       Date of report generation
*       Report type
*       Date range for which report was generated
*       The server on which the report was generated
*       The users on which the report was generated (either one user name or 
	All)

The report provides the following information for each application included 
in the report:

Beneath all of the above information about each application, the following 
summary information is provided about each user who used the 
application:
*       User name
*       Peak usage
*       Peak queued
*       Total usage
*       Total usage time
*       Total number of times queued
*       Total average queue time
*       Percent utilization

User Summary

The following describes the report generated if you chose User Summary 
as your report type:

The report heading details:
*       Date of report generation
*       Report type
*       Date range for which report was generated
*       The server on which the report was generated
*       The users on which the report was generated (either one user name or 
	All)

The report provides the following information about each user on which 
the report was generated:
*       User name
*       Total number of times queued
*       Total usage time in minutes
*       Percent utilization

This report also provides a grand summary for each of the above categories 
for each user included in the report.

User with Application Detail

The following describes the report generated if you chose User with 
Application Detail as your report type:

The report heading details:
*       Date of report generation
*       Report type
*       Date range for which report was generated
*       The server on which the report was generated
*       The users on which the report was generated (either one user name or 
	All)

The report provides the following information about each user on which 
the report was generated:
*       User name
*       Total number of times queued
*       Total usage time in minutes
*       Percent utilization

Beneath all of the above information about each user, the following 
detailed information is provided about each application this user used:
*       Date and time of usage
*       Application name
*       Status (whether the user was granted access or queued)
*       Total time in minutes of usage

NOTE: The information above is provided for every time the user accesses 
an application.

User with Application Summary

The following describes the report generated if you chose User Summary 
with Application Summary as your report type:

The report heading details:
*       Date of report generation
*       Report type
*       Date range for which report was generated
*       The server on which the report was generated
*       The users on which the report was generated (either one user name or 
	All)

The report provides the following information about each user on which 
the report was generated:
*       User name
*       Total number of times queued
*       Total usage
*       Total usage time in minutes
*       Percent utilization

Beneath all of the above information about each user, the following 
summary information is provided about each application the user accessed:

*       The full name of the application
*       The metered application name
*       The defined limit of the number of concurrent users
*       Total number of times queued
*       Total usage time 
*       Total usage time
*       Percent utilization

File Integrity Activity

The following describes the report generated if you chose File Integrity 
Activity as your report type:

The report heading details:
*       Date of report generation
*       Report type
*       Date range for which report was generated
*       The server on which the report was generated
*       The applications on which the report was generated (either one 
	application name or All)

This report provides the following information about the software security 
violations:
*       Filename
*       User name
*       Action detected
*       Date and time
*       Network name
*       Station

SPA Compliance Report

The following describes the report generated if you chose SPA Compliance 
as your report type:

The report heading details:
*       Date of report generation
*       Report type
*       The server on which the report was generated
*       The applications on which the report was generated (either one 
	application name or All)

The report details:
*       Metered application name
*       Filename
*       Number of licenses available
*       Peak queued
*       Peak usage

Software Purchase Forecast

The following describes the report generated if you chose Software 
Purchase Forecast as your report type:

The report heading details:
*       Date of report generation
*       Report type
*       The server on which the report was generated
*       The applications on which the report was generated (either one 
	application name or All)

The report provides the following information about each application on 
which the report was generated:
*       Metered Application Name
*       Path/Filename of metered application
*       Number of licenses installed
*       Number of surplus licenses
*       10% Surplus Recommendation
*       20 % Surplus Recommendation

Upgrade Purchase Forecast

The following describes the report generated if you chose Upgrade Purchase 
Forecast as your report type:

The report heading details:
*       Date of report generation
*       Report type
*       The server on which the report was generated
*       The applications on which the report was generated (either one 
	application name or All)

The report provides the following information about each application on 
which the report was generated:
*       Metered application name
*       Filename
*       Number of licenses installed
*       Number of surplus licenses
*       10% Surplus Recommendation
*       20% Surplus Recommendation


*******************************************************************************

   User Feedback Department
*******************************************************************************

   Send written comments to:            Brightwork Development, Inc.
					766 Shrewsbury Avenue
					Tinton Falls, N.J. 07724

   Fax:                                 (908) 576-8867

   Or by Internet                       Customer_Service@Brightwork.com

   Or by Compuserve                     Mail Box:   75300,1415
					Forum:      GO BRIGHT

   Or call technical support at:        (908) 530-9650
   from 9:00 AM to 7:00 PM, 
   Monday - Friday, Eastern Time

*******************************************************************************
