ERP/3.0/Developers Guide/Database Model/org.openbravo.model.ad.system/AD Heartbeat Log
AD_Heartbeat_Log
- Name:AD_Heartbeat_Log
- Classname:ADHeartbeatLog
This table contains the following columns:
Name | Nullable | Data Type | Description
|
AD_Heartbeat_Log_ID | No | VARCHAR (32) | |
Obps_Identifier | Yes | VARCHAR (10) | Activation Key Identifier is a CRC of Activation Key |
IsActive | No | CHAR (1) | 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. |
Activity_Rate | Yes | DECIMAL | The rate of activity within the system. |
ANT_Version | Yes | NVARCHAR (20) | The version of Ant used to build the application. |
Beat_Type | Yes | VARCHAR (60) | The different type of beats: enabling heartbeat, disabling heartbeat, scheduled beat, unknown |
AD_Client_ID | No | VARCHAR (32) | A Client is a company or a legal entity. You cannot share data between Clients. |
Complexity_Rate | Yes | DECIMAL | The rate of complexity within the system. |
Avg_Concurrent_Usr | Yes | DECIMAL | Average number of concurrent users during last 30 days |
WSC_Calls_Avg | Yes | DECIMAL | Average number of Connector calls per day in last 30 days |
WSC_Calls_Max | Yes | DECIMAL | Maximum number of Connector calls per day in last 30 days |
Createdby | No | VARCHAR (32) | The Created By field indicates the user who created this record. |
Created | No | TIMESTAMP (7) | The Created field indicates the date that this record was created. |
Db | Yes | NVARCHAR (20) | The database in use by the system. |
DB_Identifier | Yes | VARCHAR (10) | Unique Identifier of the instance's database, calculated based on the identifier provided by the database itself. |
DB_Version | Yes | NVARCHAR (20) | The version of database. |
IsCustomQueryEnabled | Yes | CHAR (1) | The Custom Queries are queries that can be sent by the Heartbeat server to be executed on the Openbravo 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. |
Isheartbeatactive | Yes | CHAR (1) | Disable Heartbeat process |
First_Login | Yes | TIMESTAMP (7) | Date of first login in the application |
Installed_Modules | Yes | CLOB | List of the modules installed in the instance |
InstanceNo | Yes | DECIMAL | Each Professional Edition license can activate multiple instances, this number is an identifier for each of the instances registered for the current license. |
Instance_Purpose | Yes | VARCHAR (60) | Determines which is the purpose of the Openbravo instance |
Java_Version | Yes | NVARCHAR (20) | Java Version |
Last_Login | Yes | TIMESTAMP (7) | Date of last login in the application |
MAC_Identifier | Yes | VARCHAR (10) | Mac Address Identifier of the server hosting the instance. |
MAX_Concurrent_Users | Yes | DECIMAL | Maximum number of concurrent users during last 30 days |
Client_Number | Yes | DECIMAL | Total number of clients in the instance. |
Org_Number | Yes | DECIMAL | Total number of organizations in the instance. |
NUM_Registered_Users | Yes | DECIMAL (10,0) | Number of registered users |
OB_Installmode | Yes | NVARCHAR (20) | The method used to install Openbravo. |
OB_Version | Yes | NVARCHAR (20) | The version of this installed Openbravo instance |
Os | Yes | NVARCHAR (60) | The type of Operating System. |
OS_Version | Yes | NVARCHAR (100) | The version of Operating System. |
AD_Org_ID | No | VARCHAR (32) | An organization is a unit of your client or legal entity - examples are store, department. You can share data between organizations. |
Proxy_Port | Yes | DECIMAL (10,0) | Proxy port on the proxy server. |
Isproxyrequired | Yes | CHAR (1) | Proxy configuration required to access internet. |
Proxy_Server | Yes | NVARCHAR (100) | Proxy server name. |
Rejected_Logins_Due_Conc_Users | Yes | DECIMAL | Number of rejected logins due to concurrent users limit on the last 30 days |
Servlet_Container | Yes | NVARCHAR (20) | The type of servlet container Openbravo runs in. |
Servlet_Container_Version | Yes | NVARCHAR (20) | The version of Servlet Container Openbravo runs in. |
System_Identifier | Yes | VARCHAR (60) | Unique ID identying this instance of Openbravo. |
Total_Logins | Yes | DECIMAL | Total number of logins |
Total_Logins_Month | Yes | DECIMAL | Total number of logins during last 30 days |
Updated | No | TIMESTAMP (7) | The Updated field indicates the date that this record was updated. |
Updatedby | No | VARCHAR (32) | The Updated By field indicates the user who updated this record. |
Is_Usage_Audit_Enabled | Yes | CHAR (1) | 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. |
Usage_Percentage | Yes | DECIMAL | Percentage of time the instance has been in use (at least one session active) during last 30 days. |
WS_Calls_Avg | Yes | DECIMAL | Average number of Web Service calls per day in last 30 days |
WS_Calls_Max | Yes | DECIMAL | Maximum number of Web Service calls per day in last 30 days |
WS_Rejected_Avg | Yes | DECIMAL | Average number of rejected Web Service calls per day in last 30 days |
WS_Rejected_Max | Yes | DECIMAL | Maximum number of Web Service rejected calls per day in last 30 days |
Webserver | Yes | NVARCHAR (20) | The Web Server being used by Openbravo |
Webserver_Version | Yes | NVARCHAR (20) | The version of Web Server |
Columns
AD_Heartbeat_Log_ID
- Physical column name: AD_Heartbeat_Log_ID
- Property Name: id
- Reference: ID
Activation Key Identifier
- Physical column name: Obps_Identifier
- Property Name: activationKeyIdentifier
- Reference: String
Active
- Physical column name: IsActive
- Property Name: active
- Reference: YesNo
- Default value: Y
Activity Rate
- Physical column name: Activity_Rate
- Property Name: activityRate
- Reference: Number
Ant Version
- Physical column name: ANT_Version
- Property Name: antVersion
- Reference: String
Beat_Type
- 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:
- D (Disabling heartbeat): Used when disabling the process
- U (Unknown): Unknown type of beat (used for old beats)
- CQ (Custom Query): Used to return the results of the custom queries
- DEF (Defer)
- S (Scheduled beat): Used by the process to report a scheduled beat
- DEC (Decline)
- E (Enabling heartbeat): Used when enabling the process
Client
- Physical column name: AD_Client_ID
- Property Name: client
- Reference: TableDir
Foreign key column to AD_Client table, (column: AD_Client_ID)
It has a validation "AD_Client Security validation", with the following code
AD_Client.AD_Client_ID in (@#User_Client@)
Complexity Rate
- Physical column name: Complexity_Rate
- Property Name: complexityRate
- Reference: Number
Concurrent Users Average
- Physical column name: Avg_Concurrent_Usr
- Property Name: concurrentUsersAverage
- Reference: Number
Connector Calls Average
- Physical column name: WSC_Calls_Avg
- Property Name: connectorCallsAverage
- Reference: Number
Connector Calls Max
- Physical column name: WSC_Calls_Max
- Property Name: connectorCallsMax
- Reference: Integer
Created By
- Physical column name: Createdby
- Property Name: createdBy
- Reference: Search
Foreign key column to AD_User table, (column: AD_User_ID)
Creation Date
- Physical column name: Created
- Property Name: creationDate
- Reference: DateTime
- Default value: SYSDATE
- This column is part of the table's identifier
Database
- Physical column name: Db
- Property Name: database
- Reference: String
Database Identifier
- Physical column name: DB_Identifier
- Property Name: databaseIdentifier
- Reference: String
Database Version
- Physical column name: DB_Version
- Property Name: databaseVersion
- Reference: String
Enable Custom Queries
- Physical column name: IsCustomQueryEnabled
- Property Name: enableCustomQueries
- Reference: YesNo
- Default value: Y
Enable Heartbeat
- Physical column name: Isheartbeatactive
- Property Name: enableHeartbeat
- Reference: YesNo
First Login
- Physical column name: First_Login
- Property Name: firstLogin
- Reference: Date
Installed Modules
- Physical column name: Installed_Modules
- Property Name: installedModules
- Reference: Text
Instance Number
- Physical column name: InstanceNo
- Property Name: instanceNumber
- Reference: Integer
Instance Purpose
- Physical column name: Instance_Purpose
- Property Name: instancePurpose
- Reference: String
Java Version
- Physical column name: Java_Version
- Property Name: javaVersion
- Reference: String
Last Login
- Physical column name: Last_Login
- Property Name: lastLogin
- Reference: Date
Mac Identifier
- Physical column name: MAC_Identifier
- Property Name: macIdentifier
- Reference: String
Maximum Concurrent Users
- Physical column name: MAX_Concurrent_Users
- Property Name: maximumConcurrentUsers
- Reference: Integer
Number of Clients
- Physical column name: Client_Number
- Property Name: numberOfClients
- Reference: Integer
Number of Organizations
- Physical column name: Org_Number
- Property Name: numberOfOrganizations
- Reference: Integer
Number of Registered Users
- Physical column name: NUM_Registered_Users
- Property Name: numberOfRegisteredUsers
- Reference: Integer
Openbravo Install Mode
- Physical column name: OB_Installmode
- Property Name: openbravoInstallMode
- Reference: String
Openbravo Version
- Physical column name: OB_Version
- Property Name: openbravoVersion
- Reference: String
- This column is part of the table's identifier
Operating System
- Physical column name: Os
- Property Name: operatingSystem
- Reference: String
Operating System Version
- Physical column name: OS_Version
- Property Name: operatingSystemVersion
- Reference: String
Organization
- Physical column name: AD_Org_ID
- Property Name: organization
- Reference: TableDir
Foreign key column to AD_Org table, (column: AD_Org_ID)
Proxy Port
- Physical column name: Proxy_Port
- Property Name: proxyPort
- Reference: Integer
Proxy Required
- Physical column name: Isproxyrequired
- Property Name: proxyRequired
- Reference: YesNo
Proxy Server
- Physical column name: Proxy_Server
- Property Name: proxyServer
- Reference: String
Rejected_Logins_Due_Conc_Users
- Physical column name: Rejected_Logins_Due_Conc_Users
- Property Name: rejectedLoginsDueConcUsers
- Reference: Integer
Servlet Container
- Physical column name: Servlet_Container
- Property Name: servletContainer
- Reference: String
Servlet Container Version
- Physical column name: Servlet_Container_Version
- Property Name: servletContainerVersion
- Reference: String
System Identifier
- Physical column name: System_Identifier
- Property Name: systemIdentifier
- Reference: String
- This column is part of the table's identifier
Total Logins
- Physical column name: Total_Logins
- Property Name: totalLogins
- Reference: Integer
Total Logins Last Month
- Physical column name: Total_Logins_Month
- Property Name: totalLoginsLastMonth
- Reference: Integer
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)
Usage Audit Enabled
- Physical column name: Is_Usage_Audit_Enabled
- Property Name: usageAuditEnabled
- Reference: YesNo
- Default value: N
Usage Percentage
- Physical column name: Usage_Percentage
- Property Name: usagePercentage
- Reference: Number
WS Calls Average
- Physical column name: WS_Calls_Avg
- Property Name: wSCallsAverage
- Reference: Number
WS Calls Maximum
- Physical column name: WS_Calls_Max
- Property Name: wSCallsMaximum
- Reference: Integer
WS Rejected Average
- Physical column name: WS_Rejected_Avg
- Property Name: wSRejectedAverage
- Reference: Number
WS Rejected Maximum
- Physical column name: WS_Rejected_Max
- Property Name: wSRejectedMaximum
- Reference: Integer
Web Server
- Physical column name: Webserver
- Property Name: webServer
- Reference: String
Web Server Version
- Physical column name: Webserver_Version
- Property Name: webServerVersion
- Reference: String
Other Info
![]() | Back to org.openbravo.model.ad.system |