Using the Gateway Server Status data mart

Use the Gateway Server Status data mart to view the status data of the dataflow from  agents. This data mart is available after you install it as an add-on package. After installation, the data mart is available in the Administration > Data Marts section. The data mart is automatically materialized. The data is extracted daily into the bcoee_data_visibility database table by using the Gateway Server Administration Helper system task. This table stores the last 30 days of status data.

Before this feature was introduced, the Gateway server status information was available by using the limited Self Monitoring - Gateway Data Feed Health Report BIRT report. With this data mart you can create a custom view or even combine this data with other data marts, like, SQL-based data mart or the Summary data mart.

Related topics

Managing-data-marts

Adding-and-managing-views

The following data is available through the Gateway Server Status report data mart:

Column name

Description

Dayts

Time stamp of when data collection started.

Sysid

ID of the system in BMC Helix Continuous Optimization(if available).

Sysname

Name of the system in BMC Helix Continuous Optimization (if available).

Taskid

Task ID of the ETL (if available).

Systypeid

ID of the system type.

Systypename

Name of the system type.

Bpasysname

Name of the managed system used for the data collection. 

Bpamanagerrun

Manager run that is processing this managed system.

Bpanodelist

Domain or policy list that contains this managed system.

Failurecomponentid

In case of a failure, it indicates the stage that was last processed:

  • 0 – Collect (data collected on the system)
  • 1 – Transfer (data coming back to the gateway server)
  • 2 – Processing (data being fed into the BMC - TrueSight Capacity Optimization Gateway VIS file parser ETL by the gateway server)
  • 3 – System imported through ETL
  • 4 – Success (if the processing was successful)

Additionally, the following IDs are displayed:

  • -2 – Not scheduled in a manager run
  • -1 – Scheduled in a manager run but not yet processed

Failuremessage

Message of the failure.

Failureid

ID of the failure.

Udrrepository

Gateway server file system location where data is stored.

Os

Operating system type of the managed system.

Os_version

Operating system version of the managed system.

Agent_version

Version of the Continuous Optimization agent.

Gateway_server

Gateway server that is processing the managed system.

Agent_list_name

Name of the Agent list (manager run simplified name).


 

Tip: For faster searching, add an asterisk to the end of your partial query. Example: cert*