SAP B1 User Sessions Test

User sessions serve as good indicators of the workload on a SAP Business One system. By tracking the user logins/sessions to the target SAP Business One, administrators can understand how actively the system is being used and accordingly plan the capacity of the system. In addition, failed login attempts can also be isolated, thus turning the spotlight on unauthorized accesses and malicious attacks. This is why, eG Enterprise periodically executes the SAP B1 User Sessions test.

For every source and process combination, this test reports the number of sessions initiated by the users, measures the activity level of the users, and reports login failures. This way, the test indicates how well the processes of the SAP Business One are being utilized, proactively reveals a consistent rise in user activity on the system, and pre-emptively points to dubious login attempts. Using this test, administrators can figure out the process that is most actively accessed by the users.

Target of the test : A SAP Business One

Agent deploying the test : An internal/remote agent

Outputs of the test : One set of results for each Source: Process executing on the target SAP Business One being monitored.

Configurable parameters for the test
Parameter Description

Test Period

How often should the test be executed

Host

The host for which the test is to be configured.

Port

Enter the port to which the specified host listens.

Database Type

By default, SAP Business One runs either on SAP HANA or Microsoft SQL Database server i.e., the backend database of SAP Business One is either SAP HANA or Microsoft SQL Database server. If the target SAP Business One runs on SAP HANA, choose HANA from the Database Type list. By default, MsSQL option will be chosen from this list indicating that the target SAP Business One runs on Microsoft SQL Database server.

Database Host

Specify the IP address of the host on which the database (i.e., the SAP HANA or Microsoft SQL Database server) of the target SAP Business One is installed.

Database Port

Specify the port at which the specified Database Host listens to. The default Database Port is 1433, if the target Business One runs on Microsoft SQL Database server and 30015, if the target Business One runs on SAP HANA.

Database User

If the target SAP Business One runs on Microsoft SQL Server 2005 or above, provide the name of a SQL user with all of the privileges outlined in User Privileges Required for Monitoring Microsoft SQL server in this text box. If the target SAP Business One runs on SAP HANA database server, then, a special database user account with Monitoring privileges has to be created on the SAP HANA database server of the target SAP Business One that requires monitoring. The syntax of the script that is used for user creation is discussed in Pre-requisites for Monitoring the SAP HANA Database Server. Specify the name of this user against the Database User parameter.

Password

Here, specify the password of the specified Database User.

Confirm Password

Confirm the password by retyping it here.

Database Name

To collect metrics from the logs of the target SAP Business One, the eG agent should connect to the SAP Business One database and other common databases such as RSP, B1if, SBO-COMMON etc. For this, you need to specify the name of the SAP Business One database corresponding to the target SAP Business One being monitored against the Database Name parameter. To know how to figure out the database name, refer to How to Find the Name of the SAP Business One Database?

Instance

This is set to default by default. This implies that the eG agent automatically discovers the instance name at run time. 

Domain

This parameter is applicable only if MsSQL option is chosen from the Database Type list.

By default, none is displayed in the DOMAIN text box. If the ‘SQL server and Windows’ authentication has been enabled for the server being monitored, then the DOMAIN can continue to be none. On the other hand, if ‘Windows only’ authentication has been enabled, then, in the DOMAIN text box, specify the Windows domain in which the managed Microsoft SQL server exists. Also, in such a case, the USER name and PASSWORD that you provide should be that of a user authorized to access the Microsoft SQL database server of the target SAP Business One.

DD Frequency

Refers to the frequency with which detailed diagnosis measures are to be generated for this test. The default is 1:1. This indicates that, by default, detailed measures will be generated every time this test runs, and also every time the test detects a problem. You can modify this frequency, if you so desire. Also, if you intend to disable the detailed diagnosis capability for this test, you can do so by specifying none against DD frequency.

Detailed Diagnosis

To make diagnosis more efficient and accurate, the eG Enterprise embeds an optional detailed diagnostic capability. With this capability, the eG agents can be configured to run detailed, more elaborate tests as and when specific problems are detected. To enable the detailed diagnosis capability of this test for a particular server, choose the On option. To disable the capability, click on the Off option.

The option to selectively enable/disable the detailed diagnosis capability will be available only if the following conditions are fulfilled:

  • The eG manager license should allow the detailed diagnosis capability
  • Both the normal and abnormal frequencies configured for the detailed diagnosis measures should not be 0.
Measurements made by the test
Measurement Description Measurement Unit Interpretation

Total sessions

Indicates the total number of sessions initiated by the users to access this process during the last measurement period.

Number

This measure is a good indicator to identify the session load on SAP Business One.

New sessions

Indicates the total number of sessions initiated by the users who logged in to access this process during the last measurement period.

Number

The detailed diagnosis of this measure lists the name of the user, Session ID, Client IP, Time stamp, Duration, PID, Windows User and the Reason.

Compare the value of this measure across processes to figure out the process that was most accessed by the users in the sessions that were initiated.

Login failures

Indicates the number of times users failed to login while accessing this process during the last measurement period.

Number

The detailed diagnosis of this measure lists the name of the user who failed to login, Session ID, Client IP, Time stamp, Duration, PID, Windows User and the Reason.

Compare the value of this measure across processes to figure out the process that the user attempted to use while encountering login failures.

Logged-out sessions

Indicates the number of sessions that were logged out after execution of this process during the last measurement period.

Number

The detailed diagnosis of this measure lists the name of the user who logged out of the session, Session ID, Client IP, Time stamp, Duration, PID, Windows User and the Reason.

New session rate

Indicates the rate at which new sessions were established to access this process during the last measurement period.

Sessions/min

 

Login failure rate

Indicates the rate at which user logins failed while accessing this process during the last measurement period.

Sessions/min