View ocum_report.svm Generated by
SchemaSpy
Legend: SourceForge.net
Primary key columns
Columns with indexes
Implied relationships
Excluded column relationships
< n > number of related tables
 
Column Type Size Nulls Auto Default Children Parents Comments
id bigint 19 Locally unique object identifier. ZAPIs: vserver-get-iter.vserver-info
uuid varchar 255 Globally unique ID of the vserver
name varchar 255 Textual name
clusterId bigint 19
rootVolumeId bigint 19  √  null
state varchar 255  √  null
type varchar 255  √  null
allowedProtocols varchar 255  √  null Ordered list of allowed protocols. List of: cifs, nfs, iscsi, and fcp
disallowedProtocols varchar 255  √  null Ordered list of disallowed protocols. List of: cifs, nfs, iscsi, and fcp
nfsEnabled bit 0  √  null NFS access is supported and enabled
nfsV2Supported bit 0  √  null NFS V2 is supported
nfsV3Supported bit 0  √  null NFS V3 is supported
nfsV4Supported bit 0  √  null NFS V4 is supported
nfsV41Supported bit 0  √  null NFS V4.1 is supported
nfsV41PnfsEnabled bit 0  √  null If true, then Parallel NFS support for NFS version 4.1 is enabled
nfs41AclEnabled bit 0  √  null If true, then NFSv4.1 ACL feature is enabled
nfsV4ReadDelegationEnabled bit 0  √  null If true, NFSv4.0 read delegation feature is enabled
nfsV4WriteDelegationEnabled bit 0  √  null If true, NFSv4.0 write delegation feature is enabled
nfsV4MigrationEnabled bit 0  √  null If true, NFSv4.0 migration feature is enabled
nfsV4ReferralsEnabled bit 0  √  null If true, NFSv4.0 referrals feature is enabled
nfsV41MigrationEnabled bit 0  √  null If true, NFSv4.1 migration feature is enabled
nfsV41ReferralsEnabled bit 0  √  null If true, NFSv4.1 referrals feature is enabled
cifsEnabled bit 0  √  null CIFS access is supported and enabled
cifsServer varchar 255  √  null NetBIOS name of the CIFS server
cifsAuthenticationStyle varchar 255  √  null
cifsDomain varchar 255  √  null Fully qualified domain name of the Windows Active Directory this CIFS server belongs to
exportPolicyEnabled bit 0  √  null Specifies whether the CIFS server uses export policies to control client access.
defaultUnixUser varchar 255  √  null The default UNIX user used if the identity of a CIFS user cannot be mapped using normal user mapping rules.
defaultUnixGroup varchar 255  √  null The default UNIX group used if the identity of a CIFS group cannot be mapped using normal group mapping rules.
iscsiEnabled bit 0  √  null iSCSI access is supported and enabled
iscsiNodeName varchar 255  √  null iSCSI target name for the vserver
iscsiAliasName varchar 255  √  null iSCSI target alias
fcpEnabled bit 0  √  null FCP access is supported and enabled
fcpNodeName varchar 255  √  null WWN of the vserver FCP target
nisEnabled bit 0  √  null Specifies whether the NIS domain configuration is active or inactive
activeNisDomainName varchar 255  √  null DERIVED. Domain name of the active NIS server - NULL if none is active.
activeNisServers text 65535  √  null DERIVED. NIS servers value of the active NIS server - NULL if none is active.
dnsEnabled bit 0  √  null True if DNS enabled
dnsServers varchar 255  √  null IPv4 addresses of name servers. Multiple values will be sorted comma separated
dnsDomainNames varchar 255  √  null List of DNS domains. The first domain is the one that the Vserver belongs to
maximumVolumes int 10  √  null Maximum number of volumes that can be created on the Vserver
language varchar 255  √  null Language to use for the Vserver
nameServerSwitch varchar 255  √  null Name Server switch configuration details for the Vserver.Multiple values will be ordered comma separated
volumeBytesUsed bigint 19  √  null DERIVED. Sum of all used bytes on volumes in Vserver
volumeBytesAvail bigint 19  √  null DERIVED. Difference between volumeBytesTotal and volumeBytesUsed.
volumeBytesTotal bigint 19  √  null DERIVED. Sum of all total bytes on volumes in Vserver
isRepository bit 0  √  null Specifies if this Vserver is a repository Vserver
ldapClientEnabled bit 0  √  null If true, the corresponding Lightweight Directory Access Protocol (LDAP) configuration is enabled for this Vserver.
isKerberosEnabled bit 0  √  null If true, kerberos security is enabled. ZAPIs: kerberors-config-get-iter kerberos-config-info.is-kerberos-enabled

Analyzed at Tue Apr 23 04:52 EDT 2019

View Definition:
select `vserver`.`objid` AS `id`,`vserver`.`uuid` AS `uuid`,`vserver`.`name` AS `name`,`vserver`.`clusterId` AS `clusterId`,`vserver`.`rootVolumeId` AS `rootVolumeId`,`vserver`.`stateRaw` AS `state`,`vserver`.`typeRaw` AS `type`,`vserver`.`allowedProtocols` AS `allowedProtocols`,`vserver`.`disallowedProtocols` AS `disallowedProtocols`,`vserver`.`nfsEnabled` AS `nfsEnabled`,`vserver`.`nfsV2Supported` AS `nfsV2Supported`,`vserver`.`nfsV3Supported` AS `nfsV3Supported`,`vserver`.`nfsV4Supported` AS `nfsV4Supported`,`vserver`.`nfsV41Supported` AS `nfsV41Supported`,`vserver`.`nfsV41PnfsEnabled` AS `nfsV41PnfsEnabled`,`vserver`.`nfs41AclEnabled` AS `nfs41AclEnabled`,`vserver`.`nfsV4ReadDelegationEnabled` AS `nfsV4ReadDelegationEnabled`,`vserver`.`nfsV4WriteDelegationEnabled` AS `nfsV4WriteDelegationEnabled`,`vserver`.`nfsV4MigrationEnabled` AS `nfsV4MigrationEnabled`,`vserver`.`nfsV4ReferralsEnabled` AS `nfsV4ReferralsEnabled`,`vserver`.`nfsV41MigrationEnabled` AS `nfsV41MigrationEnabled`,`vserver`.`nfsV41ReferralsEnabled` AS `nfsV41ReferralsEnabled`,`vserver`.`cifsEnabled` AS `cifsEnabled`,`vserver`.`cifsServer` AS `cifsServer`,`vserver`.`cifsAuthenticationStyleRaw` AS `cifsAuthenticationStyle`,`vserver`.`cifsDomain` AS `cifsDomain`,`vserver`.`exportPolicyEnabled` AS `exportPolicyEnabled`,`vserver`.`defaultUnixUser` AS `defaultUnixUser`,`vserver`.`defaultUnixGroup` AS `defaultUnixGroup`,`vserver`.`iscsiEnabled` AS `iscsiEnabled`,`vserver`.`iscsiNodeName` AS `iscsiNodeName`,`vserver`.`iscsiAliasName` AS `iscsiAliasName`,`vserver`.`fcpEnabled` AS `fcpEnabled`,`vserver`.`fcpNodeName` AS `fcpNodeName`,`vserver`.`nisEnabled` AS `nisEnabled`,`vserver`.`activeNisDomainName` AS `activeNisDomainName`,`vserver`.`activeNisServers` AS `activeNisServers`,`vserver`.`dnsEnabled` AS `dnsEnabled`,`vserver`.`dnsServers` AS `dnsServers`,`vserver`.`dnsDomainNames` AS `dnsDomainNames`,`vserver`.`maximumVolumes` AS `maximumVolumes`,`vserver`.`language` AS `language`,`vserver`.`nameServerSwitch` AS `nameServerSwitch`,`vserver`.`volumeBytesUsed` AS `volumeBytesUsed`,`vserver`.`volumeBytesAvail` AS `volumeBytesAvail`,`vserver`.`volumeBytesTotal` AS `volumeBytesTotal`,`vserver`.`isRepository` AS `isRepository`,`vserver`.`ldapClientEnabled` AS `ldapClientEnabled`,`vserver`.`isKerberosEnabled` AS `isKerberosEnabled` from `netapp_model_view`.`vserver`