Central Governance 1.1.3 Users Guide Save PDF Selected topic Selected topic and subtopics All content How to query the Visibility database This section describes how to query the Visibility database and then create reports in the Web Dashboard. Run the following command to identify the tables in the Visibility database: select * from trackingObject; Central Governance creates a View all flows report and other pre-configured Dashboards starting with the xfbTransfer tables. Example Results from the select * from trackingObject; command: You can use the XFBTransfer trackingobject number to identify the tables that contain information about transfers as follows: Current_664943629: Contains data from the latest transfers recorded in the Visibility service. Historic_664943629 - contains data about all previous transfers The Visibility database tracks objects in Central Governance with these views containing: xcgproduct_c: Data about the currently registered products, as well as products that were removed from Central Governance xcgflow_c: Data about the existing flows, as well as flows that were removed from Central Governance For more information about creating SQL queries and reports, please refer to the Sentinel 4.2.0 Web Dashboard User Guide. Central Governance | Document Directory Related Links
How to query the Visibility database This section describes how to query the Visibility database and then create reports in the Web Dashboard. Run the following command to identify the tables in the Visibility database: select * from trackingObject; Central Governance creates a View all flows report and other pre-configured Dashboards starting with the xfbTransfer tables. Example Results from the select * from trackingObject; command: You can use the XFBTransfer trackingobject number to identify the tables that contain information about transfers as follows: Current_664943629: Contains data from the latest transfers recorded in the Visibility service. Historic_664943629 - contains data about all previous transfers The Visibility database tracks objects in Central Governance with these views containing: xcgproduct_c: Data about the currently registered products, as well as products that were removed from Central Governance xcgflow_c: Data about the existing flows, as well as flows that were removed from Central Governance For more information about creating SQL queries and reports, please refer to the Sentinel 4.2.0 Web Dashboard User Guide. Central Governance | Document Directory