SQL Enterprise Views

Contact Info

View enterprise contacts using the SQL view QUSRBRM.ENTERPRISE_CONTACT_INFO.

Example:

SELECT * FROM QUSRBRM.ENTERPRISE_CONTACT_INFO

Hub Info

View enterprise hub attributes using the SQL view QUSRBRM.ENTERPRISE_HUB_INFO.

Example:

SELECT * FROM QUSRBRM.ENTERPRISE_HUB_INFO

Node Info

View the nodes that are part of the enterprise network using the SQL view QUSRBRM.ENTERPRISE_NODE_INFO.

Example:

SELECT * FROM QUSRBRM.ENTERPRISE_NODE_INFO

Network Info

View the enterprise network health that are part of the enterprise network using the SQL view QUSRBRM.ENTERPRISE_NETWORK_INFO.

Example:

SELECT * FROM QUSRBRM.ENTERPRISE_NETWORK_INFO

Report Definition Info

View the report definitions defined for the enterprise network using the SQL view QUSRBRM.ENTERPRISE_REPORT_DEFINITION_INFO.

Example:

SELECT * FROM QUSRBRM.ENTERPRISE_REPORT_DEFINITION_INFO

Report Output

View the results of reports run on an enterprise node using the SQL view QUSRBRM.ENTERPRISE_REPORT_OUTPUT.

Example:

SELECT * FROM QUSRBRM.ENTERPRISE_REPORT_OUTPUT

Report Status

View the current status of report definitions run on an enterprise node using the SQL view QUSRBRM.ENTERPRISE_REPORT_STATUS.

Example:

SELECT * FROM QUSRBRM.ENTERPRISE_REPORT_STATUS