Table of Contents
- List of Tables
- Title and Copyright Information
- Preface
- 1 Introducing Management Repository Views
- 2 Blackout Views
- 3 Chargeback Views
-
4
Compliance Views
- MGMT$COMPLIANCE_STANDARD_RULE
- MGMT$COMPLIANCE_STANDARD
- MGMT$COMPLIANCE_STANDARD_GROUP
- MGMT$CS_EVAL_SUMMARY
- MGMT$COMPOSITE_CS_EVAL_SUMMARY
- MGMT$CS_RULE_EVAL_SUMMARY
- MGMT$CS_GROUP_EVAL_SUMMARY
- MGMT$CS_TARGET_ASSOC
- MGMT$CSR_CURRENT_VIOLATION
- MGMT$CSR_VIOLATION_CONTEXT
- MGMT$EM_RULE_VIOL_CTXT_DEF
- MGMT$RULE_KEYWORD
- MGMT$CS_KEYWORD
- MGMT$CS_GROUP_KEYWORD
- MGMT$CS_RULE_ATTRS
- MGMT$CS_HIERARCHY
- MGMT$CS_RQS_HIERARCHY
- MGMT$CS_RULEFOLDER
- MGMT$CSG_HIERARCHY
- MGMT$CSG_SUBGROUP
- MGMT$CSR_TARGET_ASSOC
- MGMT$CSRF_TARGET_ASSOC
- MGMT$REPO_RULE_CHK_DETAILS
- MGMT$REPOSITORY_RULE_BIND_VARS
- MGMT$REPOSITORY_RULE_PARAMS
- MGMT$CS_TGT_ASSOC_TXF_REQ
- MGMT$EM_CS_RULE_EVENT_ERROR
- MGMT$COMPLIANT_TARGETS
- MGMT$COMPLIANCE_SUMMARY
- MGMT$COMPLIANCE_TREND
- MGMT$CCC_DIAG_ANALYTICS
- MGMT$CCC_DIAG_QUEUEBACKLOG
- MGMT$RULES_EVALUATED_PER_DAY
- 5 Configuration Management Views
- 6 Events Views
- 7 Hardware Views
-
8
Inventory Views
- Inventory Views
- Oracle Home Directory Patching Views
-
Oracle Home Directory Views
- MGMT$OH_HOME_INFO
- MGMT$OH_DEP_HOMES
- MGMT$OH_CRS_NODES
- MGMT$OH_CLONE_PROPERTIES
- MGMT$OH_COMPONENT
- MGMT$OH_COMP_INST_TYPE
- MGMT$OH_COMP_DEP_RULE
- MGMT$OH_PATCHSET
- MGMT$OH_VERSIONED_PATCH
- MGMT$OH_PATCH
- MGMT$OH_PATCHED_COMPONENT
- MGMT$OH_PATCH_FIXED_BUG
- MGMT$OH_PATCHED_FILE
- MGMT$OH_FILE
- MGMT$PA_RECOM_METRIC_SOURCE
- MGMT$OH_INV_SUMMARY
- MGMT$OH_INSTALLED_TARGETS
- 9 Job Views
- 10 Linux Patching Views
- 11 Management Template Views
- 12 Metric Views
-
13
Middleware Management Views
- Application Deployment Views
- Glassfish Views
-
Oracle WebLogic Server Views
- MGMT$WEBLOGIC_APPLICATIONS
- MGMT$WEBLOGIC_EJBCOMPONENT
- MGMT$WEBLOGIC_FILESTORE
- MGMT$WEBLOGIC_JDBCDATASOURCE
- MGMT$WEBLOGIC_JDBCMULTIDS
- MGMT$WEBLOGIC_JMSCONNFACTORY
- MGMT$WEBLOGIC_JMSQUEUE
- MGMT$WEBLOGIC_JMSSERVER
- MGMT$WEBLOGIC_JMSTOPIC
- MGMT$WEBLOGIC_JOLTCONNPOOL
- MGMT$WEBLOGIC_JVMSYSPROPS
- MGMT$WEBLOGIC_MACHINE
- MGMT$WEBLOGIC_NETWORK_CHANNELS
- MGMT$WEBLOGIC_NODEMANAGER
- MGMT$WEBLOGIC_RACONFIG
- MGMT$WEBLOGIC_RAOUTBOUNDCONFIG
- MGMT$WEBLOGIC_RESOURCECONFIG
- MGMT$WEBLOGIC_SERVER
- MGMT$WEBLOGIC_STARTSHUTCLASSES
- MGMT$WEBLOGIC_VIRTUALHOST
- MGMT$WEBLOGIC_WEBAPPCOMPONENT
- MGMT$WEBLOGIC_WORKMANAGER
- MGMT$WEBLOGIC_WSCONFIG
- MGMT$WEBLOGIC_WSPORTCONFIG
- Oracle WebLogic Domain Views
- Oracle WebLogic Cluster View
- 14 Monitoring Views
- 15 Operating System Views
-
16
Security Views
- MGMT$ESA_ALL_PRIVS_REPORT
- MGMT$ESA_ANY_DICT_REPORT
- MGMT$ESA_ANY_PRIV_REPORT
- MGMT$ESA_AUDIT_SYSTEM_REPORT
- MGMT$ESA_BECOME_USER_REPORT
- MGMT$ESA_CATALOG_REPORT
- MGMT$ESA_CONN_PRIV_REPORT
- MGMT$ESA_CREATE_PRIV_REPORT
- MGMT$ESA_DBA_GROUP_REPORT
- MGMT$ESA_DBA_ROLE_REPORT
- MGMT$ESA_DIRECT_PRIV_REPORT
- MGMT$ESA_EXMPT_ACCESS_REPORT
- MGMT$ESA_KEY_OBJECTS_REPORT
- MGMT$ESA_OH_OWNERSHIP_REPORT
- MGMT$ESA_OH_PERMISSION_REPORT
- MGMT$ESA_POWER_PRIV_REPORT
- MGMT$ESA_PUB_PRIV_REPORT
- MGMT$ESA_SYS_PUB_PKG_REPORT
- MGMT$ESA_TABSP_OWNERS_REPORT
- MGMT$ESA_TRC_AUD_PERM_REPORT
- MGMT$ESA_WITH_ADMIN_REPORT
- MGMT$ESA_WITH_GRANT_REPORT
- MGMT$ESM_COLLECTION_LATEST
- MGMT$ESM_FILE_SYSTEM_LATEST
- MGMT$ESM_PORTS_LATEST
- MGMT$ESM_SERVICE_LATEST
- MGMT$ESM_STACK_LATEST
- 17 Storage Reporting Views
- 18 Target Views
-
19
Virtualization Views
- MGMT$VT_VM_CONFIG
- MGMT$VT_VM_SW_CFG
- MGMT$VT_VM_VNIC
- MGMT$VT_VM_VNIC_QOS
- MGMT$VT_VM_EM_CFG
- MGMT$VT_VM_VDISKS
- MGMT$VT_VM_VDISK_QOS
- MGMT$VT_EXA_CTRL_VSERVER_TAGS
- MGMT$VT_VSP_CONFIG
- MGMT$VT_VS_HW_CFG
- MGMT$VT_VS_HYPERVISOR
- MGMT$VT_VS_PROCESSORS
- MGMT$VT_VS_SW_CFG
- MGMT$VT_VS_ATTRIBUTES
- MGMT$VT_VS_FS_MOUNTS
- MGMT$VT_VS_NET_DEVICE
- MGMT$VT_VS_FILESERVERS
- MGMT$VT_VS_REPOS
- MGMT$VT_VS_ABILITIES
- MGMT$VT_ZONE_CONFIG
-
20
Examples
- Blackout Views
-
Compliance Views
- How do I view a list of all the compliance rules?
- How do I view the monitoring compliance rules only?
- How do I view all the repository compliance rules for a specific author?
- How do I view a list of all the compliance standards?
- How do I view all compliance standards owned by a specific user
- How do I view a list of all the compliance standard groups?
- How do I view all compliance standard groups in production?
- How do I query results for compliance standards with no included standards
- How do I obtain the results for compliance standards with included standards?
- How do I obtain the results for compliance standard rules in a compliance standard for a target?
- How do I obtain the results for compliance standard groups?
- How do I obtain association information for compliance standards and targets?
- How do I obtain the violation ID for an active violation of a compliance rule?
- How do I obtain the violation column information?
- How do I access the compliance rule violation context definition-related metadata?
- How do I find all bundles that are in violation?
- How do I find all observations (all states) for all bundles in violation?
- How do I get a list of all the actions that occurred on all targets during a specific time range?
- How do I get a list of all actions that occurred on a single target during a specific time range?
- How do I get a list of all the file changes that occurred on a single target during a specific time range?
- How do I get a list of all unauthorized actions that occurred during a specific time range?
- How do I get a list of all occurrences of sudo?
-
Enterprise Configuration Management Views
- How do I view a list of all the Enterprise Configuration Management snapshots visible to the current Enterprise Manager user, including both current and saved snapshots?
- How do I get a list of all current configuration snapshots and limit the access to the snapshots based on the logged in user?
- How do I view the targets involved in a comparison?
- How do I view the latest comparison job results for a first target, second target combination?
- How do I view all the comparison jobs that ran for a first target, second target combination?
- How do I view the number of comparison differences for each configuration item in a comparison?
- How do I view the comparison CCS data source information, such as CCS file name and difference status?
- How do I view comparison CCS data source detail information?
- How do I retrieve the comparison CCS data?
- How do I get a list of all the CCS data sources or collected CCS files visible to the current Enterprise Manager user?
- How do I get a list of the current CCS data sources or collected CCS files visible to current Enterprise Manager user?
- How do I view the CCS-parsed data visible to the current Enterprise Manager user?
- How do I view the current CCS-parsed data?
- Hardware Views
-
Inventory Views
- How do I get the number of targets for a metric?
- How do I get the number of Management Agents for a version?
- How do I get a list of all the Agent-side targets?
- How do I get a list of the secure and unsecure Management Agents for each operating system?
- How do I get a list of the Management Agents with the most discovered targets of a given target type?
- How do I get a list of all the Management Agent-side targets that are discovered today?
- How do I get the number of broken targets for each host?
- How do I get the number of discovered systems for each operating system?
- How do I get the maximum number of targets of the same type that are discovered on a single system?
- How do I get the listener port for each database?
- How do I get the number of databases for each category version?
- How do I get the number of databases for each category version and CPU count?
- How do I get the number of databases for each category version and OS platform?
- How do I find the number of hosts grouped by operating system?
- How do I view a list of targets used in the Oracle Enterprise Manager Cloud Control website definition?
- How do I find the number of targets grouped for each type for the Cloud Control Infrastructure group?
- How do I find the number of Management Agents grouped for each version?
- How do I view a list of all metrics for the Management Agent on the oms.test.com system?
- How do I view a list of all clustered targets in the repository?
- Jobs Views
- Management Template Views
- Metric Views
-
Monitoring Views
- How do I get database metrics with outstanding severities?
- How do I get a list of all disabled metrics on Management Agents?
- How do I get the number of down targets?
- How do I get the availability information for the Enterprise Manager website?
- How do I get the number of alertlog severities for the database in the last 24 hours?
- How do I get the current CPU utilization of a host?
- How do I get a list of all the collected user-defined metrics (UDMs)?
- How do I get the first byte response for the Enterprise Manager website at a specific time?
- How do I obtain the average number of connections for a listener for a specific period?
- How do I find the reasons for host outages lasting longer than one day?
- How do I generate a list of all targets currently blacked out?
- How do I view a list of availability state changes made to targets in the repository in the last 30 days?
- How do I find all hosts with more than 90 percent CPU utilization?
- How do I find the minimum and maximum number of sessions for all OMS applications in the last 30 days?
- How do I find the loader throughput of the OMS on the last day?
- How do I find the minimum and maximum number from the last full day for the performance of Oracle Enterprise Manager Cloud Control?
- How do I view a list of all targets with the Response metric disabled?
- How do I view a list of all database or RAC targets that have the tablespace thresholds set to less than 85 for warning and 95 for critical?
- Oracle Home Directory Views
- Operating System Views
- Index