View netapp_model_view.vserver_full 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
objid bigint 19 Locally unique object identifier. ZAPIs: vserver-get-iter.vserver-info
uuid varchar 255 Globally unique ID of the vserver
resourceKey varchar 512
name varchar 255 Textual name
clusterId bigint 19
rootVolumeId bigint 19  √  null
snapshotPolicyId bigint 19  √  null
quotaPolicyId bigint 19  √  null Specifies the quota policy for the vserver.
qosPolicyGroupId bigint 19  √  null
state enum 12  √  null Data serving state of Vserver
stateRaw varchar 255  √  null
operationalState enum 11  √  null Operational state of Vserver.
operationalStateRaw varchar 255  √  null Raw operationalState of Vserver.
type enum 11  √  null Type of Vserver
typeRaw varchar 255  √  null
subtype enum 16  √  null Subtype of Vserver.
subtypeRaw varchar 255  √  null Raw subtype of Vserver.
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
networkIpSpaceId bigint 19  √  null IP Space associated with the vServer.
isConfigLockedForChanges bit 0  √  null Is the Vserver configuration locked for modificatiion. If the config-lock is true, then modifying the Vserver configuration is not allowed
nfsDefaultWindowsUser varchar 255  √  null The default windows user for CIFS access.
nfsChownMode enum 17  √  null Vserver Change Ownership Mode.
nfsChownModeRaw varchar 255  √  null Raw value of nfsChownMode
nfsV4IdDomain varchar 255  √  null NFSv4 ID mapping domain.
nfsV4GraceSeconds bigint 19  √  null NFSv4 Grace timeout value in seconds.
nfsMountdPort bigint 19  √  null Port that NFS mount daemon is listening to.
nfsNlmPort bigint 19  √  null Port that network lock manager is listening to.
nfsNsmPort bigint 19  √  null Port that network status monitor is listening to.
nfsEnabled bit 0  √  null NFS access is supported and enabled
nfsRootonlyEnabled bit 0  √  null If true, then vserver allows NFS protocol calls only from privileged ports (port numbers less than 1024).
nfsShowmount bit 0  √  null If true, then vserver allows showmount.
nfsVstorageEnabled bit 0  √  null If true, then enables the usage of vStorage protocol for server side copies, which is mostly used in hypervisors.
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
nfsV4AclEnabled bit 0  √  null If true, then NFSv4.0 ACL feature 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
nfsV4NumericIdsEnabled bit 0  √  null If true, then NFSv4 support for Numeric Owner IDs 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
nfsV41AclPreserveEnabled bit 0  √  null If true, then NFSv4 server will preserve and modify ACL when chmod is done .
nfsV41ReadDelegationEnabled bit 0  √  null If true, then NFSv4.1 read delegation feature is enabled.
nfsV41WriteDelegationEnabled bit 0  √  null If true, then NFSv4.1 write delegation feature is enabled.
cifsEnabled bit 0  √  null CIFS access is supported and enabled
cifsServer varchar 255  √  null NetBIOS name of the CIFS server
cifsAuthenticationStyle enum 11  √  null Authentication style for CIFS clients
cifsAuthenticationStyleRaw 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
nvmeEnabled bit 0  √  null True if NVMe enabled
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
dnsTimeout bigint 19  √  null Number of seconds to wait for a response from a name server before trying a different name server.
dnsAttempts bigint 19  √  null Max number of trials before giving up and returning error.
domainName varchar 255  √  null FQDN to Be Used for DNS Updates
isEnabled bit 0  √  null True if the dynamic DNS update is enabled
useSecure bit 0  √  null True if use secure dynamic DNS updates
ttl bigint 19  √  null TTL for the dynamically updated DNS records
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.
ldapClientConfig varchar 255  √  null The name of an existing Lightweight Directory Access Protocol (LDAP) client configuration for vserver.
isKerberosEnabled bit 0  √  null If true, kerberos security is enabled. ZAPIs: kerberors-config-get-iter kerberos-config-info.is-kerberos-enabled
isSmbEncryptionRequired bit 0  √  null CIFS security share property (encrypt-data),
cifsWorkgroup varchar 255  √  null workgroup the cifs server belongs to
createTime bigint 19
updateTime bigint 19
objState enum 5 LIVE Internal object state

Analyzed at Tue Apr 23 04:50 EDT 2019

View Definition:
select `netapp_model`.`vserver`.`objid` AS `objid`,`netapp_model`.`vserver`.`uuid` AS `uuid`,`netapp_model`.`vserver`.`resourceKey` AS `resourceKey`,`netapp_model`.`vserver`.`name` AS `name`,`netapp_model`.`vserver`.`clusterId` AS `clusterId`,`netapp_model`.`vserver`.`rootVolumeId` AS `rootVolumeId`,`netapp_model`.`vserver`.`snapshotPolicyId` AS `snapshotPolicyId`,`netapp_model`.`vserver`.`quotaPolicyId` AS `quotaPolicyId`,`netapp_model`.`vserver`.`qosPolicyGroupId` AS `qosPolicyGroupId`,`netapp_model`.`vserver`.`state` AS `state`,`netapp_model`.`vserver`.`stateRaw` AS `stateRaw`,`netapp_model`.`vserver`.`operationalState` AS `operationalState`,`netapp_model`.`vserver`.`operationalStateRaw` AS `operationalStateRaw`,`netapp_model`.`vserver`.`type` AS `type`,`netapp_model`.`vserver`.`typeRaw` AS `typeRaw`,`netapp_model`.`vserver`.`subtype` AS `subtype`,`netapp_model`.`vserver`.`subtypeRaw` AS `subtypeRaw`,`netapp_model`.`vserver`.`allowedProtocols` AS `allowedProtocols`,`netapp_model`.`vserver`.`disallowedProtocols` AS `disallowedProtocols`,`netapp_model`.`vserver`.`networkIpSpaceId` AS `networkIpSpaceId`,`netapp_model`.`vserver`.`isConfigLockedForChanges` AS `isConfigLockedForChanges`,`netapp_model`.`vserver`.`nfsDefaultWindowsUser` AS `nfsDefaultWindowsUser`,`netapp_model`.`vserver`.`nfsChownMode` AS `nfsChownMode`,`netapp_model`.`vserver`.`nfsChownModeRaw` AS `nfsChownModeRaw`,`netapp_model`.`vserver`.`nfsV4IdDomain` AS `nfsV4IdDomain`,`netapp_model`.`vserver`.`nfsV4GraceSeconds` AS `nfsV4GraceSeconds`,`netapp_model`.`vserver`.`nfsMountdPort` AS `nfsMountdPort`,`netapp_model`.`vserver`.`nfsNlmPort` AS `nfsNlmPort`,`netapp_model`.`vserver`.`nfsNsmPort` AS `nfsNsmPort`,`netapp_model`.`vserver`.`nfsEnabled` AS `nfsEnabled`,`netapp_model`.`vserver`.`nfsRootonlyEnabled` AS `nfsRootonlyEnabled`,`netapp_model`.`vserver`.`nfsShowmount` AS `nfsShowmount`,`netapp_model`.`vserver`.`nfsVstorageEnabled` AS `nfsVstorageEnabled`,`netapp_model`.`vserver`.`nfsV2Supported` AS `nfsV2Supported`,`netapp_model`.`vserver`.`nfsV3Supported` AS `nfsV3Supported`,`netapp_model`.`vserver`.`nfsV4Supported` AS `nfsV4Supported`,`netapp_model`.`vserver`.`nfsV41Supported` AS `nfsV41Supported`,`netapp_model`.`vserver`.`nfsV41PnfsEnabled` AS `nfsV41PnfsEnabled`,`netapp_model`.`vserver`.`nfsV4AclEnabled` AS `nfsV4AclEnabled`,`netapp_model`.`vserver`.`nfs41AclEnabled` AS `nfs41AclEnabled`,`netapp_model`.`vserver`.`nfsV4ReadDelegationEnabled` AS `nfsV4ReadDelegationEnabled`,`netapp_model`.`vserver`.`nfsV4WriteDelegationEnabled` AS `nfsV4WriteDelegationEnabled`,`netapp_model`.`vserver`.`nfsV4MigrationEnabled` AS `nfsV4MigrationEnabled`,`netapp_model`.`vserver`.`nfsV4ReferralsEnabled` AS `nfsV4ReferralsEnabled`,`netapp_model`.`vserver`.`nfsV4NumericIdsEnabled` AS `nfsV4NumericIdsEnabled`,`netapp_model`.`vserver`.`nfsV41MigrationEnabled` AS `nfsV41MigrationEnabled`,`netapp_model`.`vserver`.`nfsV41ReferralsEnabled` AS `nfsV41ReferralsEnabled`,`netapp_model`.`vserver`.`nfsV41AclPreserveEnabled` AS `nfsV41AclPreserveEnabled`,`netapp_model`.`vserver`.`nfsV41ReadDelegationEnabled` AS `nfsV41ReadDelegationEnabled`,`netapp_model`.`vserver`.`nfsV41WriteDelegationEnabled` AS `nfsV41WriteDelegationEnabled`,`netapp_model`.`vserver`.`cifsEnabled` AS `cifsEnabled`,`netapp_model`.`vserver`.`cifsServer` AS `cifsServer`,`netapp_model`.`vserver`.`cifsAuthenticationStyle` AS `cifsAuthenticationStyle`,`netapp_model`.`vserver`.`cifsAuthenticationStyleRaw` AS `cifsAuthenticationStyleRaw`,`netapp_model`.`vserver`.`cifsDomain` AS `cifsDomain`,`netapp_model`.`vserver`.`exportPolicyEnabled` AS `exportPolicyEnabled`,`netapp_model`.`vserver`.`defaultUnixUser` AS `defaultUnixUser`,`netapp_model`.`vserver`.`defaultUnixGroup` AS `defaultUnixGroup`,`netapp_model`.`vserver`.`iscsiEnabled` AS `iscsiEnabled`,`netapp_model`.`vserver`.`iscsiNodeName` AS `iscsiNodeName`,`netapp_model`.`vserver`.`iscsiAliasName` AS `iscsiAliasName`,`netapp_model`.`vserver`.`nvmeEnabled` AS `nvmeEnabled`,`netapp_model`.`vserver`.`fcpEnabled` AS `fcpEnabled`,`netapp_model`.`vserver`.`fcpNodeName` AS `fcpNodeName`,`netapp_model`.`vserver`.`nisEnabled` AS `nisEnabled`,`netapp_model`.`vserver`.`activeNisDomainName` AS `activeNisDomainName`,`netapp_model`.`vserver`.`activeNisServers` AS `activeNisServers`,`netapp_model`.`vserver`.`dnsEnabled` AS `dnsEnabled`,`netapp_model`.`vserver`.`dnsServers` AS `dnsServers`,`netapp_model`.`vserver`.`dnsDomainNames` AS `dnsDomainNames`,`netapp_model`.`vserver`.`dnsTimeout` AS `dnsTimeout`,`netapp_model`.`vserver`.`dnsAttempts` AS `dnsAttempts`,`netapp_model`.`vserver`.`domainName` AS `domainName`,`netapp_model`.`vserver`.`isEnabled` AS `isEnabled`,`netapp_model`.`vserver`.`useSecure` AS `useSecure`,`netapp_model`.`vserver`.`ttl` AS `ttl`,`netapp_model`.`vserver`.`maximumVolumes` AS `maximumVolumes`,`netapp_model`.`vserver`.`language` AS `language`,`netapp_model`.`vserver`.`nameServerSwitch` AS `nameServerSwitch`,`netapp_model`.`vserver`.`volumeBytesUsed` AS `volumeBytesUsed`,`netapp_model`.`vserver`.`volumeBytesAvail` AS `volumeBytesAvail`,`netapp_model`.`vserver`.`volumeBytesTotal` AS `volumeBytesTotal`,`netapp_model`.`vserver`.`isRepository` AS `isRepository`,`netapp_model`.`vserver`.`ldapClientEnabled` AS `ldapClientEnabled`,`netapp_model`.`vserver`.`ldapClientConfig` AS `ldapClientConfig`,`netapp_model`.`vserver`.`isKerberosEnabled` AS `isKerberosEnabled`,`netapp_model`.`vserver`.`isSmbEncryptionRequired` AS `isSmbEncryptionRequired`,`netapp_model`.`vserver`.`cifsWorkgroup` AS `cifsWorkgroup`,`netapp_model`.`vserver`.`createtime` AS `createTime`,`netapp_model`.`vserver`.`updatetime` AS `updateTime`,`netapp_model`.`vserver`.`objState` AS `objState` from `netapp_model`.`vserver`