SignonInfoDBLogTableName

Top Previous Next

×V3.1Ø

S	A	W	WS
	ü

Valid for: SetStartup

Syntax -

SetStartup SignOnInfoDBLogTableName {<Table Name>}

Where:

<Table Name> is a literal string containing the name of the database table where signon log information is stored.

Description:

SignOnInfoDBLogTable is an optional configuration that indicates the name of the database table where the log information should be stored. This table includes a link to the signon table in order to identify which sign on is being used. Each time the signon table is accessed, there is a record is added to the log table. The PC where the action occurred is logged along with the name of the script. The corresponding signon table is also logged. This is helpful if there are several pools of signons. Each pool can have its own signon table, but all of the information can still be logged to one log table if that is desirable. This table can be used to keep track of how many signons are in use at the same time, how long scripts are running, along with many other useful metrics.

The particular action is logged as follows.

Code	Action
-1	Error
0	No signon available
1	Sign on
2	Sign off

Note: The Access databases and a SQL Server database script are available for download at www.databoundhealthcare.com under Support Downloads in the Downloads menu.

Note: For more information on pooled signons, see the section on the SignOnInfoDBConnectionString.

Sample:

The following statements instruct EMUE to log sign on info to the table named LogTable.

SetStartup SignOnInfoDBLogTable "LogTable"