> #### Content of the configuration tables

> Table 3–2 provides a listing of each configuration table's contents.

> Table 3–2: Configuration table contents
> Table name | Table contents | Description
> --- | --- | ---
> Alert_Detail | Historical alert information | Stores data about generated alerts.
> Resrc | Resource identification | Stores data about each resource that can be viewed and/or monitored.
> Sample | Sample master table | Stores data about any created samples, regardless of the resource.
> Site | Site master table | Stores data about each configured site.
> Status | Resource table status | Stores historical status changes of resources.
> Task_Detail | Task execution history | Stores data about each executed task.

> Table 3–3 lists field names and data types for each configuration table. For more information on the filename prefix, see Table 3–1.

> Table 3–3: Configuration table details
> Filename | Field name | Data type | Description
> --- | --- | --- | ---
> Cf_Alert_Detail | Alert_ID | Integer | Sequential identification number of the alert.
> Cf_Alert_Detail | Alert_Resrc_ID | Integer | Standard resource identification number.
> Cf_Alert_Detail | Alert_Date | Character | Standard site identification number.
> Cf_Alert_Detail | Alert_Time | Integer | Date when the alert was generated.
> Cf_Alert_Detail | Alert_Message | Character | Message generated for the alert.
> Cf_Alert_Detail | Alert_Severity | Integer | Severity of the alert.
> Cf_Alert_Detail | Alert_Threshold | Decimal | Threshold value that was broken.
> Cf_Alert_Detail | Alert_Value | Decimal | Value that broke the threshold.
> Cf_Alert_Detail | Alert_Who | Character | Name of the person who generated the alert.
> Cf_Alert_Detail | Alert_Name | Character | Name of the alert.
> Cf_Alert_Detail | Alert_Number | Integer | Number of the alert (that corresponds to the `promsgs` number).
> Cf_Alert_Detail | Alert_ClearDate | Date | Date on which the alert was cleared.
> Cf_Alert_Detail | Alert_ClearWho | Character | Name of the person who cleared the alert.
> Cf_Alert_Detail | Alert_User1 | Character | User-definable field.
> Cf_Alert_Detail | Alert_ClearTime | Integer | Time when the alert was cleared.
> Cf_Alert_Detail | Alert_ClearNote | Character | Specific note for the cleared alert.
> Cf_Resrc | Resrc_Desc | Character | Description of the resource.
> Cf_Resrc | Resrc_Host | Character | Fully qualified domain name of the resource's host machine.
> Cf_Resrc | Resrc_ID | Integer | Sequential identification number of the resource.
> Cf_Resrc | Resrc_IP | Character | IP address of the resource.
> Cf_Resrc | Resrc_Loc | Character | Location of the resource.
> Cf_Resrc | Resrc_Loc_Type | Character | Location type (directory, URL, or port).
> Cf_Resrc | Resrc_Name | Character | Name of the resource.
> Cf_Resrc | Resrc_Port | Integer | Port number of the resource.
> Cf_Resrc | Resrc_Type | Character | Type of resource to be monitored.
> Cf_Resrc | Site_ID | Character | Identification for the site containing the resource.
> Cf_Sample | Resrc_ID | Integer | Sequential identification number of the resource.
> Cf_Sample | Sample_Date | Date | Date when the sample interval was taken.
> Cf_Sample | Sample_ID | Integer | Sequential identification number of the sample.
> Cf_Sample | Sample_Len | Integer | Length, in seconds, of the sample interval.
> Cf_Sample | Sample_Time | Integer | Time when the sample was gathered.
> Cf_Sample | Sample_Trans | Integer | Number of transactions committed during the sample interval.
> Cf_Sample | Sample_Type | Integer | Indicates the type of resource sampled. Possible values are: 1 - Unknown 3 - File Monitor 5- TCP Port 6 - UDP Port 8 - Web Site 11 - Database 13 - DNS Device 15 - FTP Site 16 - ICMP Port 19 - Log File 22- Job 23 - CPU 24 - Memory 25 - Disk 26 - File System 27 - User 28 - Email Action 29 - Command Action 30 - Log Action 31 - Report 32 - Search String 33 - Compound Action
> Cf_Sample | Site_ID | Character | The ID given to the site (usually the host name).
> Cf_Site | Site_ID | Character | Identification number for the site containing the resource.
> Cf_Site | Site_PRGS_Vers | Character | OpenEdge release number.
> Cf_Site | Site_Serial | Integer | OpenEdge serial number.
> Cf_Site | Site_Machine_Name | Character | Machine name of site machine.
> Cf_Site | Site_IP | Character | IP address of the site.
> Cf_Status | Resrc_ID | Integer | Resource ID of the database for this site.
> Cf_Status | Site_ID | Character | Site ID for the database.
> Cf_Status | Status_ID | Integer | Sequential number generated by Fathom.
> Cf_Status | Status_Date | Date | Date that the status change occurred.
> Cf_Status | Status_Time | Integer | Time that the status change occurred.
> Cf_Status | Status_Status | Character | The new status in effect.
> Cf_Task_Detail | Site_ID | Character | Standard site identification number.
> Cf_Task_Detail | Task_ID | Integer | Sequential identification number of the task that is used for storage.
> Cf_Task_Detail | Task_Type | Integer | Type of task executed (22 indicates a user-defined task and 31 indicates a Fathom report).
> Cf_Task_Detail | Task_Name | Character | Name of the task.
> Cf_Task_Detail | Task_Desc | Character | Description of the task.
> Cf_Task_Detail | Task_Command | Character | Command for the task.
> Cf_Task_Detail | Task_Args | Character | Arguments passed to the task.
> Cf_Task_Detail | Task_WorkDir | Character | Working directory for the task.
> Cf_Task_Detail | Task_InFile | Character | Input file for the task. This file, if needed, is redirected into the command.
> Cf_Task_Detail | Task_OutFile | Character | Standard output file for the task.
> Cf_Task_Detail | Task_ErrFile | Character | Standard error file for the task.
> Cf_Task_Detail | Task_StartDate | Date | Start date for the task.
> Cf_Task_Detail | Task_StartTime | Integer | Start time for the task.
> Cf_Task_Detail | Task_EndDate | Date | End date for the task.
> Cf_Task_Detail | Task_EndTime | Integer | End time for the task.
> Cf_Task_Detail | Task_ExitCode | Integer | Exit code passed back to Fathom. Zero denotes success; nonzero denotes failure.

Copyright © 2004 Progress Software Corporation www.progress.com Voice: (781) 280-4000 Fax: (781) 280-4095