ERP 2.50:Developers Guide/Database Model/org.openbravo.model.ad.system/AD Heartbeat Log
AD_Heartbeat_Log
- Name:ADHeartbeatLog
- Classname:HeartbeatLog
This table contains the following columns:
| Name | Nullable | Data Type | Description |
| AD_Heartbeat_Log_ID | N | VARCHAR2(32) | null |
| AD_Client_ID | N | VARCHAR2(32) | Client for this installation. |
| AD_Org_ID | N | VARCHAR2(32) | Organizational entity within client |
| IsActive | N | CHAR(1) | A flag indicating whether this record is available for use or de-activated. |
| Created | N | DATE | The date that this record is completed. |
| Createdby | N | VARCHAR2(32) | User who created this records |
| Updated | N | DATE | x not implemented |
| Updatedby | N | VARCHAR2(32) | User who updated this records |
| System_Identifier | Y | VARCHAR2(60) | Unique ID identying this instance of Openbravo. |
| Isheartbeatactive | Y | CHAR(1) | Disable Heartbeat process |
| Isproxyrequired | Y | CHAR(1) | Proxy configuration required to access internet. |
| Proxy_Server | Y | NVARCHAR2(100) | Proxy server used to access the internet. |
| Proxy_Port | Y | NUMBER(10, 0) | Proxy port on the proxy server used to access the internet. |
| Activity_Rate | Y | NUMBER | The rate of activity within the system. |
| Complexity_Rate | Y | NUMBER | The rate of complexity within the system. |
| Os | Y | NVARCHAR2(60) | The type of Operating System. |
| OS_Version | Y | NVARCHAR2(100) | The version of Operating System. |
| Db | Y | NVARCHAR2(20) | The database in use by the system. |
| DB_Version | Y | NVARCHAR2(20) | The version of database. |
| Servlet_Container | Y | NVARCHAR2(20) | The type of servlet container Openbravo runs in. |
| Servlet_Container_Version | Y | NVARCHAR2(20) | The version of Servlet Container Openbravo runs in. |
| Webserver | Y | NVARCHAR2(20) | The Web Server being used by Openbravo |
| Webserver_Version | Y | NVARCHAR2(20) | The version of Web Server |
| Java_Version | Y | NVARCHAR2(20) | Java Version |
| ANT_Version | Y | NVARCHAR2(20) | The version of Ant used to build the application. |
| OB_Version | Y | NVARCHAR2(20) | The version of Openbravo. |
| OB_Installmode | Y | NVARCHAR2(20) | The method used to install Openbravo. |
| NUM_Registered_Users | Y | NUMBER(10, 0) | Number of registered users. |
| Code_Revision | Y | VARCHAR2(60) | The code revision of the installed system |
| Beat_Type | Y | VARCHAR2(60) | Type of beat |
| DB_Identifier | Y | VARCHAR2(10) | Unique Identifier of the instance's database |
| MAC_Identifier | Y | VARCHAR2(10) | Mac Address Identifier |
| Installed_Modules | Y | CLOB(4000) | List of the modules installed in the instance |
| Obps_Identifier | Y | VARCHAR2(10) | It is an identifier for activation key |
| First_Login | Y | DATE | Date of first login in the application |
| Last_Login | Y | DATE | Date of last login in the application |
| Total_Logins | Y | NUMBER | Total number of logins |
| Total_Logins_Month | Y | NUMBER | Total number of logins during last 30 days |
| Avg_Concurrent_Usr | Y | NUMBER | Average number of concurrent users during last 30 days |
| Usage_Percentage | Y | NUMBER | Percentage of time the instance has been in use (at least one session active) during last 30 days. |
| MAX_Concurrent_Users | Y | NUMBER | Maximum number of concurrent users during last 30 days |
| Client_Number | Y | NUMBER | Total number of clients in the instance. |
| Org_Number | Y | NUMBER | Total number of organizations in the instance. |
| Is_Usage_Audit_Enabled | Y | CHAR(1) | Is Usage Audit Enbled |
| Instance_Purpose | Y | VARCHAR2(60) | null |
| Rejected_Logins_Due_Conc_Users | Y | NUMBER | null |
| InstanceNo | Y | NUMBER | Professional Edition Instance Number |
| IsCustomQueryEnabled | Y | CHAR(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
- AD_HEARTBEAT_LOG_KEY
Columns
AD_Heartbeat_Log_ID
- Physical column name: AD_Heartbeat_Log_ID
- Property Name: id
- Reference: ID
Client
- Physical column name: AD_Client_ID
- Property Name: client
- Reference: TableDir
- Default value: @AD_CLIENT_ID@
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@)
Organization
- Physical column name: AD_Org_ID
- Property Name: organization
- Reference: TableDir
- Default value: @AD_ORG_ID@
Foreign key column to AD_Org table, (column: AD_Org_ID)
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.
- Physical column name: IsActive
- Property Name: active
- Reference: YesNo
- Default value: Y
Creation Date
The Created field indicates the date that this record was created.
- Physical column name: Created
- Property Name: creationDate
- Reference: DateTime
- Default value: SYSDATE
- This column is part of the table's identifier
Created By
- Physical column name: Createdby
- Property Name: createdBy
- Reference: Search
Foreign key column to AD_User table, (column: AD_User_ID)
Updated
The Updated field indicates the date that this record was updated.
- Physical column name: Updated
- Property Name: updated
- Reference: DateTime
- Default value: SYSDATE
Updated By
- Physical column name: Updatedby
- Property Name: updatedBy
- Reference: Search
Foreign key column to AD_User table, (column: AD_User_ID)
System Identifier
Unique ID identying this instance of Openbravo.
- Physical column name: System_Identifier
- Property Name: systemIdentifier
- Reference: String
- This column is part of the table's identifier
Enable Heartbeat
Disable Heartbeat process
- Physical column name: Isheartbeatactive
- Property Name: enableHeartbeat
- Reference: YesNo
Proxy Required
Proxy configuration required to access internet.
- Physical column name: Isproxyrequired
- Property Name: proxyRequired
- Reference: YesNo
Proxy Server
Proxy server name.
- Physical column name: Proxy_Server
- Property Name: proxyServer
- Reference: String
Proxy Port
Proxy port on the proxy server.
- Physical column name: Proxy_Port
- Property Name: proxyPort
- Reference: Integer
Activity Rate
The rate of activity within the system.
- Physical column name: Activity_Rate
- Property Name: activityRate
- Reference: Number
Complexity Rate
The rate of complexity within the system.
- Physical column name: Complexity_Rate
- Property Name: complexityRate
- Reference: Number
Operating System
The type of Operating System.
- Physical column name: Os
- Property Name: operatingSystem
- Reference: String
Operating System Version
The version of Operating System.
- Physical column name: OS_Version
- Property Name: operatingSystemVersion
- Reference: String
Database
The database in use by the system.
- Physical column name: Db
- Property Name: database
- Reference: String
Database Version
The version of database.
- Physical column name: DB_Version
- Property Name: databaseVersion
- Reference: String
Servlet Container
The type of servlet container Openbravo runs in.
- Physical column name: Servlet_Container
- Property Name: servletContainer
- Reference: String
Servlet Container Version
The version of Servlet Container Openbravo runs in.
- Physical column name: Servlet_Container_Version
- Property Name: servletContainerVersion
- Reference: String
Web Server
The Web Server being used by Openbravo
- Physical column name: Webserver
- Property Name: webServer
- Reference: String
Web Server Version
The version of Web Server
- Physical column name: Webserver_Version
- Property Name: webServerVersion
- Reference: String
Java Version
Java Version
- Physical column name: Java_Version
- Property Name: javaVersion
- Reference: String
Ant Version
The version of Ant used to build the application.
- Physical column name: ANT_Version
- Property Name: antVersion
- Reference: String
Openbravo Version
The version of this installed Openbravo instance
- Physical column name: OB_Version
- Property Name: openbravoVersion
- Reference: String
- This column is part of the table's identifier
Openbravo Install Mode
The method used to install Openbravo.
- Physical column name: OB_Installmode
- Property Name: openbravoInstallMode
- Reference: String
Number of Registered Users
Number of registered users
- Physical column name: NUM_Registered_Users
- Property Name: numberOfRegisteredUsers
- Reference: Integer
Code Revision
The code revision of the installed system
- Physical column name: Code_Revision
- Property Name: codeRevision
- Reference: String
- Default value: 0
Beat_Type
The different type of beats: enabling heartbeat, disabling heartbeat, scheduled beat, unknown
- Physical column name: Beat_Type
- Property Name: beatType
- Reference: List
- Default value: U
List values: AD_Heartbeat - Type of beat
The allowed values for this list are:
- CQ (Custom Query): Used to return the results of the custom queries
- D (Disabling heartbeat): Used when disabling the process
- DEC (Decline)
- DEF (Defer)
- E (Enabling heartbeat): Used when enabling the process
- S (Scheduled beat): Used by the process to report a scheduled beat
- U (Unknown): Unknown type of beat (used for old beats)
Database Identifier
Unique Identifier of the instance's database, calculated based on the identifier provided by the database itself.
- Physical column name: DB_Identifier
- Property Name: databaseIdentifier
- Reference: String
Mac Identifier
Mac Address Identifier of the server hosting the instance.
- Physical column name: MAC_Identifier
- Property Name: macIdentifier
- Reference: String
Installed Modules
List of the modules installed in the instance
- Physical column name: Installed_Modules
- Property Name: installedModules
- Reference: Text
Activation Key Identifier
Activation Key Identifier is a CRC of Activation Key
- Physical column name: Obps_Identifier
- Property Name: activationKeyIdentifier
- Reference: String
First Login
Date of first login in the application
- Physical column name: First_Login
- Property Name: firstLogin
- Reference: Date
Last Login
Date of last login in the application
- Physical column name: Last_Login
- Property Name: lastLogin
- Reference: Date
Total Logins
Total number of logins
- Physical column name: Total_Logins
- Property Name: totalLogins
- Reference: Integer
Total Logins Last Month
Total number of logins during last 30 days
- Physical column name: Total_Logins_Month
- Property Name: totalLoginsLastMonth
- Reference: Integer
Concurrent Users Average
Average number of concurrent users during last 30 days
- Physical column name: Avg_Concurrent_Usr
- Property Name: concurrentUsersAverage
- Reference: Number
Usage Percentage
Percentage of time the instance has been in use (at least one session active) during last 30 days.
- Physical column name: Usage_Percentage
- Property Name: usagePercentage
- Reference: Number
Maximum Concurrent Users
Maximum number of concurrent users during last 30 days
- Physical column name: MAX_Concurrent_Users
- Property Name: maximumConcurrentUsers
- Reference: Integer
Number of Clients
Total number of clients in the instance.
- Physical column name: Client_Number
- Property Name: numberOfClients
- Reference: Integer
Number of Organizations
Total number of organizations in the instance.
- Physical column name: Org_Number
- Property Name: numberOfOrganizations
- Reference: Integer
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.
- Physical column name: Is_Usage_Audit_Enabled
- Property Name: usageAuditEnabled
- Reference: YesNo
- Default value: N
Instance Purpose
Determines which is the purpose of the Openbravo ERP instance
- Physical column name: Instance_Purpose
- Property Name: instancePurpose
- Reference: String
Rejected_Logins_Due_Conc_Users
Number of rejected logins due to concurrent users limit on the last 30 days
- Physical column name: Rejected_Logins_Due_Conc_Users
- Property Name: rejectedLoginsDueConcUsers
- Reference: Integer
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.
- Physical column name: InstanceNo
- Property Name: instanceNumber
- Reference: Integer
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.
- Physical column name: IsCustomQueryEnabled
- Property Name: enableCustomQueries
- Reference: YesNo
- Default value: Y
Related tables
Tables that link this table: