View source | Discuss this page | Page history | Printable version   
Toolbox
Main Page
Upload file
What links here
Recent changes
Help

PDF Books
Add page
Show collection (0 pages)
Collections help

Search

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)
AD_Client_ID No VARCHAR (32) A Client is a company or a legal entity. You cannot share data between Clients.
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.
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.

Created No TIMESTAMP (7) The Created field indicates the date that this record was created.
Createdby No VARCHAR (32) The Created By field indicates the user who created this record.
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.
System_Identifier Yes VARCHAR (60) Unique ID identying this instance of Openbravo.
Isheartbeatactive Yes CHAR (1) Disable Heartbeat process
Isproxyrequired Yes CHAR (1) Proxy configuration required to access internet.
Proxy_Server Yes NVARCHAR (100) Proxy server name.
Proxy_Port Yes DECIMAL (10,0) Proxy port on the proxy server.
Activity_Rate Yes DECIMAL The rate of activity within the system.
Complexity_Rate Yes DECIMAL The rate of complexity within the system.
Os Yes NVARCHAR (60) The type of Operating System.
OS_Version Yes NVARCHAR (100) The version of Operating System.
Db Yes NVARCHAR (20) The database in use by the system.
DB_Version Yes NVARCHAR (20) The version of database.
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.
Webserver Yes NVARCHAR (20) The Web Server being used by Openbravo
Webserver_Version Yes NVARCHAR (20) The version of Web Server
Java_Version Yes NVARCHAR (20) Java Version
ANT_Version Yes NVARCHAR (20) The version of Ant used to build the application.
OB_Version Yes NVARCHAR (20) The version of this installed Openbravo instance
OB_Installmode Yes NVARCHAR (20) The method used to install Openbravo.
NUM_Registered_Users Yes DECIMAL (10,0) Number of registered users
Code_Revision Yes VARCHAR (60) The code revision of the installed system
Beat_Type Yes VARCHAR (60) The different type of beats: enabling heartbeat, disabling heartbeat, scheduled beat, unknown
DB_Identifier Yes VARCHAR (10) Unique Identifier of the instance's database, calculated based on the identifier provided by the database itself.
MAC_Identifier Yes VARCHAR (10) Mac Address Identifier of the server hosting the instance.
Installed_Modules Yes CLOB List of the modules installed in the instance
Obps_Identifier Yes VARCHAR (10) Activation Key Identifier is a CRC of Activation Key
First_Login Yes TIMESTAMP (7) Date of first login in the application
Last_Login Yes TIMESTAMP (7) Date of last login in the application
Total_Logins Yes DECIMAL Total number of logins
Total_Logins_Month Yes DECIMAL Total number of logins during last 30 days
Avg_Concurrent_Usr Yes DECIMAL Average number of concurrent users 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.
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.
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.
Instance_Purpose Yes VARCHAR (60) Determines which is the purpose of the Openbravo ERP instance
Rejected_Logins_Due_Conc_Users Yes DECIMAL Number of rejected logins due to concurrent users limit on the last 30 days
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.
IsCustomQueryEnabled Yes CHAR (1) 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.

WS_Calls_Max Yes DECIMAL Maximum number of Web Service calls per day in last 30 days
WS_Calls_Avg Yes DECIMAL Average number of Web Service calls per day in last 30 days
WSC_Calls_Max Yes DECIMAL Maximum number of Connector calls per day in last 30 days
WSC_Calls_Avg Yes DECIMAL Average number of Connector 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
WS_Rejected_Avg Yes DECIMAL Average number of rejected Web Service calls per day in last 30 days

Columns

AD_Heartbeat_Log_ID



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


Organization


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

top


Active



top


Creation Date


top


Created By


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

top


Updated



top


Updated By


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

top


System Identifier


top


Enable Heartbeat



top


Proxy Required



top


Proxy Server



top


Proxy Port



top


Activity Rate



top


Complexity Rate



top


Operating System



top


Operating System Version



top


Database



top


Database Version



top


Servlet Container



top


Servlet Container Version



top


Web Server



top


Web Server Version



top


Java Version



top


Ant Version



top


Openbravo Version


top


Openbravo Install Mode



top


Number of Registered Users



top


Code Revision



top


Beat_Type


List values: AD_Heartbeat - Type of beat

The allowed values for this list are:

top


Database Identifier



top


Mac Identifier



top


Installed Modules



top


Activation Key Identifier



top


First Login



top


Last Login



top


Total Logins



top


Total Logins Last Month



top


Concurrent Users Average



top


Usage Percentage



top


Maximum Concurrent Users



top


Number of Clients



top


Number of Organizations



top


Usage Audit Enabled



top


Instance Purpose



top


Rejected_Logins_Due_Conc_Users



top


Instance Number



top


Enable Custom Queries



top


WS Calls Maximum



top


WS Calls Average



top


Connector Calls Max



top


Connector Calls Average



top


WS Rejected Maximum



top


WS Rejected Average



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 1,817 times. This page was last modified on 1 August 2016, at 11:00. Content is available under Creative Commons Attribution-ShareAlike 2.5 Spain License.