Subscribe

db schema for oncommand 7.0

Does anyone have the latest dbscheme for oncommand 7.0

Re: db schema for oncommand 7.0

Hi,

 

Schema for the database views can be found in the Operations Manager online help.

If this post resolved your issue, help others by selecting ACCEPT AS SOLUTION or adding a KUDO.

Re: db schema for oncommand 7.0

Thanks, I got what I was looking for yesterday and forgot to repost.

 

This is the view I was most interested in.

 

 

PS C:\powershell> invoke-mysqlquery -query 'show tables'

Tables_in_netapp_model_view
---------------------------
aggregate
aggregate_full
application_record
application_record_full
change_delete_detail
change_record
changed_attribute
cifs_share
cifs_share_acl
cifs_share_acl_full
cifs_share_full
cluster
cluster_full
cluster_peer
cluster_peer_full
disk
disk_aggregate_relationship
disk_aggregate_relationship_full
disk_full
disk_path
disk_path_full
export_policy
export_policy_full
export_rule
export_rule_full
fcp_lif
fcp_lif_derived
fcp_lif_derived_full
fcp_lif_full
fcp_port
fcp_port_full
flash_device
flash_device_full
ha_pair
ha_pair_full
igroup
igroup_full
igroup_initiator
igroup_initiator_full
iscsi_portal_group
iscsi_portal_group_full
iscsi_portal_group_lif
iscsi_portal_group_lif_full
iscsi_security_entry
iscsi_security_entry_full
iscsi_session
iscsi_session_connection
iscsi_session_connection_full
iscsi_session_full
job_schedule
job_schedule_full
license
license_full
license_v2_entitlement_risk
license_v2_entitlement_risk_full
lif
lif_full
lun
lun_full
lun_import
lun_import_full
lun_map
lun_map_full
lun_map_reporting_node
lun_map_reporting_node_full
metrocluster_operation
metrocluster_operation_full
network_failover_group
network_failover_group_full
network_failover_group_network_port_relationship
network_failover_group_network_port_relationship_full
network_ip_space
network_ip_space_full
network_lif
network_lif_derived
network_lif_derived_full
network_lif_full
network_port
network_port_broadcast_domain
network_port_broadcast_domain_full
network_port_full
network_route
network_route_full
network_route_lif
network_route_lif_full
network_subnet
network_subnet_full
nis_domain
nis_domain_full
node
node_full
node_license_usage
node_license_usage_full
plex
plex_full
portset
portset_full
portset_to_igroup
portset_to_igroup_full
portset_to_port
portset_to_port_full
processor
processor_full
qos_policy_group
qos_policy_group_full
qos_service_center
qos_service_center_full
qos_volume_workload
qos_volume_workload_full
qos_workload_detail
qos_workload_detail_full
qos_workload_node_relationship
qos_workload_node_relationship_full
qtree
qtree_full
qtree_quota
qtree_quota_full
quota_user
quota_user_full
raid_group
raid_group_full
resource_aggregate
resource_aggregate_full
routing_group
routing_group_destination
routing_group_destination_full
routing_group_full
service_processor
service_processor_full
sis_policy
sis_policy_full
snap_mirror
snap_mirror_full
snap_mirror_history
snap_mirror_history_full
snap_mirror_policy
snap_mirror_policy_full
snap_mirror_policy_rule
snap_mirror_policy_rule_full
snaplock
snaplock_full
snapshot
snapshot_full
snapshot_policy
snapshot_policy_full
snapshot_policy_schedule
snapshot_policy_schedule_full
storage_adapter
storage_adapter_full
storage_pool
storage_pool_aggregate_relationship
storage_pool_aggregate_relationship_full
storage_pool_available
storage_pool_available_full
storage_pool_full
storage_service
storage_service_full
storage_shelf
storage_shelf_cable
storage_shelf_cable_full
storage_shelf_full
storage_switch
storage_switch_full
system_health_alert
system_health_alert_full
user_quota
user_quota_full
volume
volume_full
volume_move_job
volume_move_job_full
vserver
vserver_full
vserver_name_mapping
vserver_name_mapping_full
vserver_peer
vserver_peer_full
vserver_to_aggregate
vserver_to_aggregate_full