SAPSQL Technical Guide
Midnight Technologies Corp.

(C) Midnight Technologies Corp. 1994,1995
NetWare is a registered trademark of Novell, Inc.

Table of Contents
^^^^^^^^^^^^^^^^^
 Product Overview
 SAPSQL Installation
 SAPSQL Usage
 Contacting Midnight Technologies Corp.

Product Overview
^^^^^^^^^^^^^^^^
SAPSQL is a NetWare Loadable Module(NLM) designed to assist network 
administrators in managing the protocol traffic on their Local Area 
Networks(LANs) and Wide-Area Networks(WANs).  When loaded it will report 
extensive information on services advertised with Novell's Service 
Advertising Protocol(SAP). With the resulting information, administrators
can analyze which advertisements can be allowed to pass to local network 
segments and which can be filtered from wide area networks.  Novell and
other third party software can then be used to filter those services.

Novell NetWare has a service list command, display servers.  SAPSQL takes
advantage of this list and adds value by giving extended information about 
each service.  In addition to the server name that NetWare provides, SAPSQL
adds the network address, hop count, application name, company name, contact
name, and telephone number.

SAPSQL allows the network administrator to issue specific queries to 
customize which services are displayed.  The resulting information can be 
filtered by different criteria,  and then sorted for best use.  SAPSQL also
allows for this information to be exported to a text file.

SAPSQL Installation
^^^^^^^^^^^^^^^^^^^
SAPSQL was designed to run on NetWare versions 3.11, 3.12, 4.0, 4.01, 4.02, 
and 4.10.  Testing has shown that the software will not function properly on 
SFT III implementations of NetWare software.

The file size of SAPSQL.NLM is 102,553 bytes in this release.  The amount of 
memory used on the NetWare server is dependent on the version of NetWare.  
However, the memory used is minimal.  In addition, SAPSQL is automatically 
unloaded when you finish listing the information and releases all memory 
according to NetWare APIs.

Each copy of SAPSQL.NLM is licensed to one server and should be copied to 
the SYS:SYSTEM directory of that server for easiest loading.  If you desire, 
you can create a subdirectory for the NLM and copy the file to that 
directory.  For ease of loading it is then recommended to add that directory 
to the search path of the server.  For example, if the file were copied into 
the SYS:SYSTEM\SAPSQL directory, add the statement 
SEARCH ADD SYS:SYSTEM\SAPSQL to the AUTOEXEC.NCF file for that server.

Note:  The shareware version of SAPSQL will delete itself after 
initial usage.  It will then be necessary to register with Midnight 
Technologies Corp. to purchase the software.  Recopying the software 
each time will allow additional usages.  However, the NLM will delete
itself with each usage.  We hope this inconvenience will encourage you
to register your software.

SmartSAP Usage
^^^^^^^^^^^^^^
The simplest usage of the SAPSQL NLM is to load it without any of the 
optional parameters. 

	:load sys:system\sapsql.nlm
	Loading module SAPSQL.NLM
	  Querying tool to view NetWare internet services (94122001)
	  Version 1.03    December 20, 1994
	  Copyright (C) 1994, Midnight Technologies. All rights reserved

The screen will clear and the following message will appear:

	SAPSQL.NLM: Reading and sorting SAP entries.  Please wait 
        (ESC to quit) ... / 

Then a screen listing the services known to that server will be displayed.  The default order is 
alphabetical by server name.  The following is a sample entry:

	Server : 08000955E2AC0081HPJETD-HPLJ4SI
	Service: Quick Silver
	Company: Hewlett Packard - Boise        Contact: Phil Magnuson
	Address: 11101110 08000955E2AC 400C  Hops: 4  Type: 030C  Ph: 2083235004
	<Press ESC to quit or any key to continue>                                      

The following keys can then be used to nagivate the listing: PgDn, PgUp, 
UpArrow, DnArrow, t (top), e (end), ESC (quit).

A series of additional parameters can be used to customize the output.
SAPSQL syntax is as follows:

 [ -f[=[<vol>]:[<path>]\\file>] ] [ -s=field[,field[,..] ] [ -v ]
 [ -r=operator,[,operator[,..]]] [ -d=field[,field[,..]] ] [ -h ]

 -f output to file SYS:SYSTEM\\SAPLIST.TXT or <vol:path\\file>.
	The file is exactly like the screen output and will contain
	all entries the server is aware of.  The file name can be changed
	to redirect to floppy or network drive.  Please be sure to include
	the double back slashes between directory names.  For example
	A:\\TEMP\\SAPLIST.DOC
 -s sort on field(s) in this order <<field>,<field>,..>
	For example:  load sys:system\sapsql -s=type,address
	to sort the listing by SAP type and then by network address.
	The following is a list of field names and descriptions:
	  name		Name of the service as configured on the server
	  service	Description of the service type (see below)
	  type		Hexadecimal value of the SAP Type
	  company	Company who registered SAP Type with Novell
	  contact	Contact person at company (above)
	  phone		Phone number of contact (above)
	  hops		Decimal number of network hops away of the service
	  address	Network address of the service
				format is NETWORK NODE SOCKET
 -r restrict output to conditional(s) <<operator>,<operator>,..>
	This option can be very useful for displaying just NetWare 
	servers or just services dependent on type or name.  For example:
		load sys:system\sapsql -r=type=0004,hops<=3
	will restrict the output to just NetWare servers (SAP Type 0004) and 
	no more than 3 network hops away. More than one restriction operator 
	are anded not ored.  Ored operators can be obtained by running 
	SAPSQL more than once.  The format of the operator is 
	<field><compare><value>. The compare would be =>,<,=,>=,<=.  
	Remember that the values for type is hexadecimal, for hops is 
	decimal, and all else is string.  There can be no spaces in the 
	string values.  If spaces are needed or desired substitute 
	semicolons for the spaces.  For example:
		load sys:system\sapsql -r=name='Computer;Corp'
	would find all server names equal to "Computer Corp".
 -d do not display field(s) or 'totals' (default is all fields) 
 -v sort in descending order (default is ascending).
 -h print this information.

Contacting Midnight Technologies Corp.
^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
For licensing information you can fill out the accompanying form,
FORM.TXT, and E-Mail it to:
	CompuServe: 	76451,1527
	Internet:	76451.1572@Compuserve.COM

You may also mail the form to our address:
      Midnight Technologies Corp.
      1158 East 11740 South
      Sandy, UT  84094-7437

Pricing for the NLM is as follows:
    US$29.95 Single Server
    US$1,995.00 Multi-Server license (50-99 servers)
    US$3,295.00 Site Licence (100+ servers)