Reference for Network Load Balancer

SELECT BS.BACKEND_SET_NAME, BS.NETWORK_LOAD_BALANCER_ID, L.TIME_CREATED, L.COMPARTMENT_ID, L.REGION, L.LIFECYCLE_STATE
FROM OCIRA.NLB_BACKEND_SET_DIM_V BS
INNER JOIN OCIRA.NLB_NETWORK_LOAD_BALANCER_DIM_V L
ON BS.OCIRA_NETWORK_LOAD_BALANCER_KEY = L.OCIRA_NETWORK_LOAD_BALANCER_KEY;

SELECT B.BACKEND_NAME, L.ID, L.TIME_CREATED, L.COMPARTMENT_ID, L.REGION, L.LIFECYCLE_STATE
FROM OCIRA.NLB_BACKEND_DIM_V B
INNER JOIN OCIRA.NLB_BACKEND_SET_DIM_V BS
ON B.OCIRA_BACKEND_SET_KEY = BS.OCIRA_BACKEND_SET_KEY
INNER JOIN OCIRA.NLB_NETWORK_LOAD_BALANCER_DIM_V L
ON BS.OCIRA_NETWORK_LOAD_BALANCER_KEY = L.OCIRA_NETWORK_LOAD_BALANCER_KEY;

SELECT H.HEALTH_CHECKER_NAME, L.TIME_CREATED, L.COMPARTMENT_ID, L.REGION, L.LIFECYCLE_STATE
FROM OCIRA.NLB_HEALTH_CHECKER_DIM_V H
INNER JOIN OCIRA.NLB_BACKEND_SET_DIM_V BS
ON H.OCIRA_BACKEND_SET_KEY = BS.OCIRA_BACKEND_SET_KEY
INNER JOIN OCIRA.NLB_NETWORK_LOAD_BALANCER_DIM_V L
ON BS.OCIRA_NETWORK_LOAD_BALANCER_KEY = L.OCIRA_NETWORK_LOAD_BALANCER_KEY;

SELECT LS.LISTENER_NAME, L.ID, L.TIME_CREATED, L.COMPARTMENT_ID, L.REGION, L.LIFECYCLE_STATE
FROM OCIRA.NLB_LISTENER_DIM_V LS
INNER JOIN OCIRA.NLB_BACKEND_SET_DIM_V BS
ON LS.OCIRA_DEFAULT_BACKEND_SET_KEY = BS.OCIRA_BACKEND_SET_KEY
INNER JOIN OCIRA.NLB_NETWORK_LOAD_BALANCER_DIM_V L
ON BS.OCIRA_NETWORK_LOAD_BALANCER_KEY = L.OCIRA_NETWORK_LOAD_BALANCER_KEY;

SELECT F.NLB_ID, D.DISPLAY_NAME
FROM OCIRA.NLB_FACT_V F
LEFT JOIN OCIRA.NLB_NETWORK_LOAD_BALANCER_DIM_V D
ON F.OCIRA_NLB_KEY = D.OCIRA_NETWORK_LOAD_BALANCER_KEY
WHERE F.LIFECYCLE_STATE IN ('FAILED');

SELECT F.NLB_ID, BS.BACKEND_SET_NAME, B.BACKEND_NAME
FROM OCIRA.NLB_FACT_V F
LEFT JOIN OCIRA.NLB_BACKEND_SET_DIM_V BS
ON F.OCIRA_NLB_KEY = BS.OCIRA_NETWORK_LOAD_BALANCER_KEY
LEFT JOIN OCIRA.NLB_BACKEND_DIM_V B
ON BS.OCIRA_BACKEND_SET_KEY = B.OCIRA_BACKEND_SET_KEY;

SELECT F.NLB_ID, H.BACKEND_SET_NAME, H.HEALTH_CHECKER_NAME, H.INTERVAL_IN_MILLIS, H.PORT, 
H.PROTOCOL, H.RESPONSE_BODY_REGEX, H.RESPONSE_DATA, H.RETRIES, H.RETURN_CODE, 
H.TIMEOUT_IN_MILLIS, H.URL_PATH
FROM OCIRA.NLB_FACT_V F
LEFT JOIN OCIRA.NLB_HEALTH_CHECKER_DIM_V H
ON H.OCIRA_NETWORK_LOAD_BALANCER_KEY = H.OCIRA_NETWORK_LOAD_BALANCER_KEY;

SELECT F.NLB_ID, F.SUBNET_ID, S.DISPLAY_NAME
FROM OCIRA.NLB_FACT_V F
LEFT JOIN OCIRA.VCN_SUBNET_DIM_V S
ON F.OCIRA_SUBNET_KEY = S.OCIRA_SUBNET_KEY;

SELECT F.NLB_ID, T.TAG_TYPE, T.TAG_KEY_NAME, T.TAG_VALUE
FROM OCIRA.NLB_FACT_V F
LEFT JOIN OCIRA.TAGS_DIM_V T
ON F.NLB_ID = T.RESOURCE_ID;