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

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

This article is protected against manual editing because it is automatically generated from Openbravo meta-data. Learn more about writing and translating such documents.
Back button.png   Back to ERP/3.0/Developers Guide/Database Model/org.openbravo.model.ad.system


Contents

AD_Heartbeat_Log

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



top


Activation Key Identifier



top


Active



top


Activity Rate



top


Ant Version



top


Beat_Type


List values: AD_Heartbeat - Type of beat

The allowed values for this list are:

top


Client


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@)

top


Complexity Rate



top


Concurrent Users Average



top


Connector Calls Average



top


Connector Calls Max



top


Created By


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

top


Creation Date


top


Database



top


Database Identifier



top


Database Version



top


Enable Custom Queries



top


Enable Heartbeat



top


First Login



top


Installed Modules



top


Instance Number



top


Instance Purpose



top


Java Version



top


Last Login



top


Mac Identifier



top


Maximum Concurrent Users



top


Number of Clients



top


Number of Organizations



top


Number of Registered Users



top


Openbravo Install Mode



top


Openbravo Version


top


Operating System



top


Operating System Version



top


Organization


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

top


Proxy Port



top


Proxy Required



top


Proxy Server



top


Rejected_Logins_Due_Conc_Users



top


Servlet Container



top


Servlet Container Version



top


System Identifier


top


Total Logins



top


Total Logins Last Month



top


Updated



top


Updated By


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

top


Usage Audit Enabled



top


Usage Percentage



top


WS Calls Average



top


WS Calls Maximum



top


WS Rejected Average



top


WS Rejected Maximum



top


Web Server



top


Web Server Version



top


Other Info

Back button.png   Back to org.openbravo.model.ad.system

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

This page has been accessed 6,002 times. This page was last modified on 22 August 2023, at 09:33. Content is available under Creative Commons Attribution-ShareAlike 2.5 Spain License.