topic db schema for oncommand 7.0 in Active IQ Unified Manager Discussions https://community.netapp.com/t5/Active-IQ-Unified-Manager-Discussions/db-schema-for-oncommand-7-0/m-p/124697#M22369 <P>Does anyone have the latest dbscheme for oncommand 7.0</P> Wed, 04 Jun 2025 18:31:14 GMT JGPSHNTAP 2025-06-04T18:31:14Z db schema for oncommand 7.0 https://community.netapp.com/t5/Active-IQ-Unified-Manager-Discussions/db-schema-for-oncommand-7-0/m-p/124697#M22369 <P>Does anyone have the latest dbscheme for oncommand 7.0</P> Wed, 04 Jun 2025 18:31:14 GMT https://community.netapp.com/t5/Active-IQ-Unified-Manager-Discussions/db-schema-for-oncommand-7-0/m-p/124697#M22369 JGPSHNTAP 2025-06-04T18:31:14Z Re: db schema for oncommand 7.0 https://community.netapp.com/t5/Active-IQ-Unified-Manager-Discussions/db-schema-for-oncommand-7-0/m-p/124760#M22390 <P>Hi,</P><P>&nbsp;</P><P>Schema for the database views can be found in the Operations Manager online help.</P> Wed, 26 Oct 2016 04:48:14 GMT https://community.netapp.com/t5/Active-IQ-Unified-Manager-Discussions/db-schema-for-oncommand-7-0/m-p/124760#M22390 Sahana 2016-10-26T04:48:14Z Re: db schema for oncommand 7.0 https://community.netapp.com/t5/Active-IQ-Unified-Manager-Discussions/db-schema-for-oncommand-7-0/m-p/124780#M22395 <P>Thanks, I got what I was looking for yesterday and forgot to repost.</P><P>&nbsp;</P><P>This is the view I was most interested in.</P><P>&nbsp;</P><P>&nbsp;</P><P>PS C:\powershell&gt; invoke-mysqlquery -query 'show tables'</P><P>Tables_in_netapp_model_view<BR />---------------------------<BR />aggregate<BR />aggregate_full<BR />application_record<BR />application_record_full<BR />change_delete_detail<BR />change_record<BR />changed_attribute<BR />cifs_share<BR />cifs_share_acl<BR />cifs_share_acl_full<BR />cifs_share_full<BR />cluster<BR />cluster_full<BR />cluster_peer<BR />cluster_peer_full<BR />disk<BR />disk_aggregate_relationship<BR />disk_aggregate_relationship_full<BR />disk_full<BR />disk_path<BR />disk_path_full<BR />export_policy<BR />export_policy_full<BR />export_rule<BR />export_rule_full<BR />fcp_lif<BR />fcp_lif_derived<BR />fcp_lif_derived_full<BR />fcp_lif_full<BR />fcp_port<BR />fcp_port_full<BR />flash_device<BR />flash_device_full<BR />ha_pair<BR />ha_pair_full<BR />igroup<BR />igroup_full<BR />igroup_initiator<BR />igroup_initiator_full<BR />iscsi_portal_group<BR />iscsi_portal_group_full<BR />iscsi_portal_group_lif<BR />iscsi_portal_group_lif_full<BR />iscsi_security_entry<BR />iscsi_security_entry_full<BR />iscsi_session<BR />iscsi_session_connection<BR />iscsi_session_connection_full<BR />iscsi_session_full<BR />job_schedule<BR />job_schedule_full<BR />license<BR />license_full<BR />license_v2_entitlement_risk<BR />license_v2_entitlement_risk_full<BR />lif<BR />lif_full<BR />lun<BR />lun_full<BR />lun_import<BR />lun_import_full<BR />lun_map<BR />lun_map_full<BR />lun_map_reporting_node<BR />lun_map_reporting_node_full<BR />metrocluster_operation<BR />metrocluster_operation_full<BR />network_failover_group<BR />network_failover_group_full<BR />network_failover_group_network_port_relationship<BR />network_failover_group_network_port_relationship_full<BR />network_ip_space<BR />network_ip_space_full<BR />network_lif<BR />network_lif_derived<BR />network_lif_derived_full<BR />network_lif_full<BR />network_port<BR />network_port_broadcast_domain<BR />network_port_broadcast_domain_full<BR />network_port_full<BR />network_route<BR />network_route_full<BR />network_route_lif<BR />network_route_lif_full<BR />network_subnet<BR />network_subnet_full<BR />nis_domain<BR />nis_domain_full<BR />node<BR />node_full<BR />node_license_usage<BR />node_license_usage_full<BR />plex<BR />plex_full<BR />portset<BR />portset_full<BR />portset_to_igroup<BR />portset_to_igroup_full<BR />portset_to_port<BR />portset_to_port_full<BR />processor<BR />processor_full<BR />qos_policy_group<BR />qos_policy_group_full<BR />qos_service_center<BR />qos_service_center_full<BR />qos_volume_workload<BR />qos_volume_workload_full<BR />qos_workload_detail<BR />qos_workload_detail_full<BR />qos_workload_node_relationship<BR />qos_workload_node_relationship_full<BR />qtree<BR />qtree_full<BR />qtree_quota<BR />qtree_quota_full<BR />quota_user<BR />quota_user_full<BR />raid_group<BR />raid_group_full<BR />resource_aggregate<BR />resource_aggregate_full<BR />routing_group<BR />routing_group_destination<BR />routing_group_destination_full<BR />routing_group_full<BR />service_processor<BR />service_processor_full<BR />sis_policy<BR />sis_policy_full<BR />snap_mirror<BR />snap_mirror_full<BR />snap_mirror_history<BR />snap_mirror_history_full<BR />snap_mirror_policy<BR />snap_mirror_policy_full<BR />snap_mirror_policy_rule<BR />snap_mirror_policy_rule_full<BR />snaplock<BR />snaplock_full<BR />snapshot<BR />snapshot_full<BR />snapshot_policy<BR />snapshot_policy_full<BR />snapshot_policy_schedule<BR />snapshot_policy_schedule_full<BR />storage_adapter<BR />storage_adapter_full<BR />storage_pool<BR />storage_pool_aggregate_relationship<BR />storage_pool_aggregate_relationship_full<BR />storage_pool_available<BR />storage_pool_available_full<BR />storage_pool_full<BR />storage_service<BR />storage_service_full<BR />storage_shelf<BR />storage_shelf_cable<BR />storage_shelf_cable_full<BR />storage_shelf_full<BR />storage_switch<BR />storage_switch_full<BR />system_health_alert<BR />system_health_alert_full<BR />user_quota<BR />user_quota_full<BR />volume<BR />volume_full<BR />volume_move_job<BR />volume_move_job_full<BR />vserver<BR />vserver_full<BR />vserver_name_mapping<BR />vserver_name_mapping_full<BR />vserver_peer<BR />vserver_peer_full<BR />vserver_to_aggregate<BR />vserver_to_aggregate_full</P> Wed, 26 Oct 2016 12:15:38 GMT https://community.netapp.com/t5/Active-IQ-Unified-Manager-Discussions/db-schema-for-oncommand-7-0/m-p/124780#M22395 JGPSHNTAP 2016-10-26T12:15:38Z