View source | Discuss this page | Page history | Printable version   

ERP 2.50:Developers Guide/Database Model/org.openbravo.model.ad.system/AD Heartbeat Log

ERP 2.50:Developers Guide/Database Model/org.openbravo.model.ad.system

Index

Contents

AD_Heartbeat_Log

This table contains the following columns:

Name Nullable Data Type Description
AD_Heartbeat_Log_ID NVARCHAR2(32)null
AD_Client_ID NVARCHAR2(32)Client for this installation.
AD_Org_ID NVARCHAR2(32)Organizational entity within client
IsActive NCHAR(1)A flag indicating whether this record is available for use or de-activated.
Created NDATEThe date that this record is completed.
Createdby NVARCHAR2(32)User who created this records
Updated NDATEx not implemented
Updatedby NVARCHAR2(32)User who updated this records
System_Identifier YVARCHAR2(60)Unique ID identying this instance of Openbravo.
Isheartbeatactive YCHAR(1)Disable Heartbeat process
Isproxyrequired YCHAR(1)Proxy configuration required to access internet.
Proxy_Server YNVARCHAR2(100)Proxy server used to access the internet.
Proxy_Port YNUMBER(10, 0)Proxy port on the proxy server used to access the internet.
Activity_Rate YNUMBERThe rate of activity within the system.
Complexity_Rate YNUMBERThe rate of complexity within the system.
Os YNVARCHAR2(60)The type of Operating System.
OS_Version YNVARCHAR2(100)The version of Operating System.
Db YNVARCHAR2(20)The database in use by the system.
DB_Version YNVARCHAR2(20)The version of database.
Servlet_Container YNVARCHAR2(20)The type of servlet container Openbravo runs in.
Servlet_Container_Version YNVARCHAR2(20)The version of Servlet Container Openbravo runs in.
Webserver YNVARCHAR2(20)The Web Server being used by Openbravo
Webserver_Version YNVARCHAR2(20)The version of Web Server
Java_Version YNVARCHAR2(20)Java Version
ANT_Version YNVARCHAR2(20)The version of Ant used to build the application.
OB_Version YNVARCHAR2(20)The version of Openbravo.
OB_Installmode YNVARCHAR2(20)The method used to install Openbravo.
NUM_Registered_Users YNUMBER(10, 0)Number of registered users.
Code_Revision YVARCHAR2(60)The code revision of the installed system
Beat_Type YVARCHAR2(60)Type of beat
DB_Identifier YVARCHAR2(10)Unique Identifier of the instance's database
MAC_Identifier YVARCHAR2(10)Mac Address Identifier
Installed_Modules YCLOB(4000)List of the modules installed in the instance
Obps_Identifier YVARCHAR2(10)It is an identifier for activation key
First_Login YDATEDate of first login in the application
Last_Login YDATEDate of last login in the application
Total_Logins YNUMBERTotal number of logins
Total_Logins_Month YNUMBERTotal number of logins during last 30 days
Avg_Concurrent_Usr YNUMBERAverage number of concurrent users during last 30 days
Usage_Percentage YNUMBERPercentage of time the instance has been in use (at least one session active) during last 30 days.
MAX_Concurrent_Users YNUMBERMaximum number of concurrent users during last 30 days
Client_Number YNUMBERTotal number of clients in the instance.
Org_Number YNUMBERTotal number of organizations in the instance.
Is_Usage_Audit_Enabled YCHAR(1)Is Usage Audit Enbled
Instance_Purpose YVARCHAR2(60)null
Rejected_Logins_Due_Conc_Users YNUMBERnull
InstanceNo YNUMBERProfessional Edition Instance Number
IsCustomQueryEnabled YCHAR(1)Send Custom Queries to Heartbeat

Other Info

Indexes

These are the indexes for this table (for each index there is a list of all the columns included within it):

Unique

top

Columns

AD_Heartbeat_Log_ID

top

Client

Foreign key column to AD_Client table, (column: AD_Client_ID)


Validation Rule AD_Client Security validation: Clients with user access rights. With the following code:

 
AD_Client.AD_Client_ID IN (@#User_Client@)

top

Organization

Foreign key column to AD_Org table, (column: AD_Org_ID)

top

Active

There are two methods of making records unavailable in the system: One is to delete the record, the other is to de-activate the record. A de-activated record is not available for selection, but available for reporting. There are two reasons for de-activating and not deleting records:
(1) The system requires the record for auditing purposes.
(2) The record is referenced by other records. E.g., you cannot delete a Business Partner, if there are existing invoices for it. By de-activating the Business Partner you prevent it from being used in future transactions.

top

Creation Date

The Created field indicates the date that this record was created.

top

Created By

Foreign key column to AD_User table, (column: AD_User_ID)

top

Updated

The Updated field indicates the date that this record was updated.

top

Updated By

Foreign key column to AD_User table, (column: AD_User_ID)

top

System Identifier

Unique ID identying this instance of Openbravo.

top

Enable Heartbeat

Disable Heartbeat process

top

Proxy Required

Proxy configuration required to access internet.

top

Proxy Server

Proxy server name.

top

Proxy Port

Proxy port on the proxy server.

top

Activity Rate

The rate of activity within the system.

top

Complexity Rate

The rate of complexity within the system.

top

Operating System

The type of Operating System.

top

Operating System Version

The version of Operating System.

top

Database

The database in use by the system.

top

Database Version

The version of database.

top

Servlet Container

The type of servlet container Openbravo runs in.

top

Servlet Container Version

The version of Servlet Container Openbravo runs in.

top

Web Server

The Web Server being used by Openbravo

top

Web Server Version

The version of Web Server

top

Java Version

Java Version

top

Ant Version

The version of Ant used to build the application.

top

Openbravo Version

The version of this installed Openbravo instance

top

Openbravo Install Mode

The method used to install Openbravo.

top

Number of Registered Users

Number of registered users

top

Code Revision

The code revision of the installed system

top

Beat_Type

The different type of beats: enabling heartbeat, disabling heartbeat, scheduled beat, unknown

List values: AD_Heartbeat - Type of beat

The allowed values for this list are:

top

Database Identifier

Unique Identifier of the instance's database, calculated based on the identifier provided by the database itself.

top

Mac Identifier

Mac Address Identifier of the server hosting the instance.

top

Installed Modules

List of the modules installed in the instance

top

Activation Key Identifier

Activation Key Identifier is a CRC of Activation Key

top

First Login

Date of first login in the application

top

Last Login

Date of last login in the application

top

Total Logins

Total number of logins

top

Total Logins Last Month

Total number of logins during last 30 days

top

Concurrent Users Average

Average number of concurrent users during last 30 days

top

Usage Percentage

Percentage of time the instance has been in use (at least one session active) during last 30 days.

top

Maximum Concurrent Users

Maximum number of concurrent users during last 30 days

top

Number of Clients

Total number of clients in the instance.

top

Number of Organizations

Total number of organizations in the instance.

top

Usage Audit Enabled

In case Usage Audit is enabled, the beat will send information about how much each of the installed modules has been used during last 30 days.

top

Instance Purpose

Determines which is the purpose of the Openbravo ERP instance

top

Rejected_Logins_Due_Conc_Users

Number of rejected logins due to concurrent users limit on the last 30 days

top

Instance Number

Each Professional Edition license can activate multiple instances, this number is an identifier for each of the instances registered for the current license.

top

Enable Custom Queries

The Custom Queries are queries that can be sent by the Heartbeat server to be executed on the Openbravo ERP instance. This queries are used the get more extended information about the usage of the instance.

By disabling this option standard beats will be sent to HeartBeat server, but not these Custom Queries.

top

Related tables

Tables that link this table:

top

Retrieved from "http://wiki.openbravo.com/wiki/ERP_2.50:Developers_Guide/Database_Model/org.openbravo.model.ad.system/AD_Heartbeat_Log"

This page has been accessed 4,024 times. This page was last modified on 14 June 2011, at 11:03. Content is available under Creative Commons Attribution-ShareAlike 2.5 Spain License.