SnapCenter PowerShell Commands
Get-SmResources
Suggest changes
PDFs
Discovers plug-in resources.
Syntax
Get-SmResources [-PluginCode] <PluginCode> [-HostName] <String> [-UseKnownResources] <SwitchParameter> [-AppObjectType] <String> [-AppObjectId] <String> [-IsDAG] <SwitchParameter> [-InformationAction] <ActionPreference> [-InformationVariable] <String> [-WhatIf] <SwitchParameter> [-Confirm] <SwitchParameter>
Detailed Description
Discovers plug-in resources. For SnapCenter Plug-in for Microsoft SQL Server, resources include databases, Availability Groups, and SQL Server instances. You can query one host at a time and return information about any plug-in instances installed on that host. You can use this cmdlet to get detailed information about resources located on the specified host.For SnapCenter Plug-in for Oracle Database, resources include Oracle databases and application volumes This is useful for creating appropriate disk and SMB shares and to include resources in datasets for later data protection.If a request times out when running this cmdlet, you can add the following rest timeout value key to the out from PowerShell config file located at "C:\Windows\System32\WindowsPowerShell\v1.0\Modules\SnapCenter\SnapManager.PSModule.dll.config": <add key="RESTTimeout" value="10800000" />
Parameters
| Name | Description | Required? | Pipeline Input | Default Value |
|---|---|---|---|---|
PluginCode |
The name of the plug-in for which you want to discover resources. Possible inputs include SCSQL, SCW, SCO, HANA, SCU, SCE, and SP. |
true |
true (ByPropertyName) |
|
HostName |
Specifies the host name. You can query one host at a time. |
true |
true (ByPropertyName) |
|
UseKnownResources |
Indicates that you want to return the cached resources. You can use this parameter when you have already queried resources from the SnapCenter GUI. In this case, you receive information only about the already discovered resources. You can use this parameter for resource verification.Oracle application volume resources are manually created by the user. These resources will always be obtained from the SnapCenter database because discovery on host is not applicable for them. |
false |
true (ByPropertyName) |
|
AppObjectType |
Specifies the type of application object. For example, instance, database, or a SAP HANA SingleContainer or MultipleContainers. For SnapCenter Plug-in for Oracle Database, valid object types are Database and ApplicationVolume. |
false |
true (ByPropertyName) |
|
AppObjectId |
Specifies the AppObjectId of resource. For example, -AppObjectId MVA-RX200-S13\SQLEXPRESS\DB16. For Oracle databases and application volume resources, the ID is of the format HostName\ResourceName. |
false |
true (ByPropertyName) |
|
IsDAG |
Required parameter that enables SnapCenter to discover Microsoft Exchange Database Availability Groups (DAGs) when you use the SnapCenter Plug-in for Microsoft Exchange Server. |
false |
true (ByPropertyName) |
|
WhatIf |
false |
false |
||
Confirm |
false |
false |
||
DatabaseName |
SAP HANA database name. |
false |
true (ByValue, ByPropertyName) |
|
ListStorageFootprint |
false |
true (ByValue, ByPropertyName) |
||
SID |
This is a SAP HANA database specific parameter. A SAP HANA system is identified by aunique 3 letter system ID (SID). For example, ABC. |
false |
true (ByValue, ByPropertyName) |
|
ResourceType |
Specifies the type of application object. For example, instance, database, or a SAP HANA SingleContainer or MultipleContainers. |
false |
true (ByValue, ByPropertyName) |
|
TenantDatabaseName |
This is a SAP HANA database specific parameter. It is the name of the tenant database for SAP HANA Multitenant Database. |
false |
true (ByValue, ByPropertyName) |
|
ResourceName |
This can be used to filter resources by their names |
false |
true (ByValue, ByPropertyName) |
Examples
Example 1: Discovering resources on a host
Get-SmResources -HostName 'vise-f6.sddev.mycompany.com' -PluginCode MSFT_SQL
This example syntax discovers the resources for the Microsoft SQL plug-in on the specified host.
PluginCode OperationResults
---------- ----------------
MSFT_SQL {SMCoreContracts.SmObjectOperationResult, SMCoreContract…
Example 2: Listing storage content of custom DB2 plugin resource
Get-SmResources -HostName 'sccorelinux61.sccore.test.com' -PluginCode DB2 -AppObjectName financeDB -ListStorageFootprint
This example syntax lists resource details along with StorageFoot print details of the custom plug-in resource named financeDB of DB2.
Completed Discovering resources: Job Id [123] ResourceName : financeDB ResourceVersion : ResourceId : sccorelinux61.sccore.test.com\Db2\financeDB ResourceType : Instance Protected: No RunAsName: ResourceSettings : MountPaths : StorageFootPrint : StorageResourceType : SDStorageDir, StorageResource : financeDB :/vol/SM1_SRC_sccorelinux61_sccore_test_com
Example 3: Listing SAP HANA databases of type SingleContainer
Get-SmResources -HostName 'scspr0204312001.gdl.englab.netapp.com' -PluginCode HANA -AppObjectType SingleContainer
This example syntax lists all SAP HANA databases of resource type SingleContainer.
Completed Discovering Resources: Job Id [564] DatabaseName : NonMDC6 SID : LMN UserStoreKeys: bG1uOGfG3efS1yJZQMqOttTQH5C283MUtNTlOHUlIYhUbAH+zBtCpXAr/v89mO2Is9IoQuNKjOOGeKD/iv4vYaP+2hK0VNM8YOf8zAU58u24RZGTrLjcLZX0OeH0JwPgGZ5Ljml629LkU7ArBMfWXokq6Q== FileBackupPath : /hana/shared/LMN/HDB01/backup/data FileBackupPrefix : SnapCenter_ OSDBUser : ResourceId : scspr0204312001.gdl.englab.netapp.com\hana\LMN ResourceUid : LMN PluginName : hana Host : scspr0204312001.gdl.englab.netapp.com ResourceType : SingleContainer Protected: No RunAsName: ResourceSettings : MountPaths :
Example 4: Listing SAP HANA databases of type Multitenant Database Container
Get-SmResources -HostName 'scspr0204312001.gdl.englab.netapp.com' -PluginCode HANA -AppObjectType MultipleContainers
This example syntax lists SAP HANA databases of resource type MultipleContainers.
Completed Discovering Resources: Job Id [565] DatabaseName : NewRes1 SID: BGB UserStoreKeys : YmdiOd9V1LuiyloAsPoQhXb1I32XN8mu4kmsXUT1eWA/wsEBIr0YbxAniqNQCWPJxot/bw24xEfTr1IUOuP8wXGP4t/DluFo4HfNIYIpEAQ9BuK9ehMQagGY9DwbsvtTrrueVzPCi0E4LAfV4+WsLdLaow== FileBackupPath : /hana/shared/PPP/HDB01/backup/data FileBackupPrefix : SnapCenter_ OSDBUser : TenantDatabaseName : hhh TenantType : SingleTenant ResourceId : scspr0204312001.gdl.englab.netapp.com\hana\BGB\hhh ResourceUid: BGB\hhh PluginName : hana Host : scspr0204312001.gdl.englab.netapp.com ResourceType : MultipleContainers Protected : No RunAsName : ResourceSettings : MountPaths :
Example 5: Listing all SAP HANA resources of specified host
Get-SmResources -PluginCode 'hana' -HostName 'schana02.gdl.englab.netapp.com' -UseKnownResources
This example lists all the SAP HANA databases of a selected host.
Completed Discovering Resources: Job Id [21]
DatabaseName: R57
SID : R57
UserStoreKeys : cjU3uItRwnENhBzpUwKFGMsPL+sWzrS0LwLvh+BVhDJEh+hxGEBF00tcKka6ElLUjyXEPDULjXdVqw6GmlkIr+UuIa4Zq+pnGKlt0zRbM6E1ZxE8k6r8HElNgHrjY3JUsUvBS7RNQlOirVC6R2n93Qfd9A==
FileBackupPath :
FileBackupPrefix: SnapCenter_
OSDBUser: r57adm
TenantDatabaseNames : {R57, TDB01, TDB02, TDB03}
TenantType : MultiTenant
ResourceId : schana02.gdl.englab.netapp.com\hana\MDC\R57
ResourceUid : MDC\R57
PluginName : hana
Host: schana02.gdl.englab.netapp.com
ResourceType: MultipleContainers
Protected : No
RunAsName :
ResourceSettings:
MountPaths :
DiscoveryType : Auto
IsAuthenticated : Yes
DatabaseName: MDC
SID : MT1
UserStoreKeys : bXQxDY8049rvqv2jPtrmFNChtY9CuhhNBSnsSJ9Fzo13LYquhwnlDknOd+QeJepEFFSIEX0AxRFcYnQVm1RR5Ky2P3oi2vgEUrPqe0UoHkfBe/QgjDeeaIrBIr4CNIiXZVwKFxOm0oLxXcf4Uluo/amAhw==
FileBackupPath :
FileBackupPrefix: SnapCenter_
OSDBUser: root
TenantDatabaseNames : {}
TenantType : MultiTenant
ResourceId : schana02.gdl.englab.netapp.com\hana\MDC\MT1
ResourceUid : MDC\MT1
PluginName : hana
Host: schana02.gdl.englab.netapp.com
ResourceType: MultipleContainers
Protected : No
RunAsName :
ResourceSettings:
MountPaths :
DiscoveryType : Manual
IsAuthenticated : Not Applicable
DatabaseName : NonMDC_SN
SID : H01
UserStoreKeys: aDAx85jqzWC0G9U7i7ohDgG1VxG7E8AxaUKyD2BeRnv+fF3sluc9aZDdPUyaWgJwQ5ZAAe0IPBY/l1PGkli2DgffnbhPjwu9fPg+nKhlErLyjXp26txx+CJJWHAniekIAsJxLdc9aUrcKO4Xm5N2wdNgdQ==
FileBackupPath :
FileBackupPrefix : SnapCenter_
OSDBUser : user
ResourceId : schana02.gdl.englab.netapp.com\hana\H01
ResourceUid : H01
PluginName : hana
Host : schana02.gdl.englab.netapp.com
ResourceType : SingleContainer
Protected: No
RunAsName:
ResourceSettings :
MountPaths :
DiscoveryType: Manual
IsAuthenticated : Not Applicable
Example 6: Listing all the resources of a specified resource type
Get-SmResources -PluginCode 'hana' -HostName 'schana02.gdl.englab.netapp.com' -UseKnownResources -ResourceType 'MultipleContainers' -DatabaseName 'R57'
This example lists all the resources of a specified resource type.
Completed Discovering Resources: Job Id [47] DatabaseName : R57 SID: R57 UserStoreKeys : FileBackupPath : FileBackupPrefix : SnapCenter_ OSDBUser : TenantDatabaseName : TenantType : MultiTenant ResourceId : schana02.gdl.englab.netapp.com\hana\MDC\R57 ResourceUid: MDC\R57 PluginName : hana Host : schana02.gdl.englab.netapp.com ResourceType : MultipleContainers Protected : No RunAsName : ResourceSettings : MountPaths : DiscoveryType : Auto IsAuthenticated: No
Example 7: Trigger plug-in discovery and list the resources of specified host
Get-SmResources -PluginCode 'hana' -HostName 'schana02.gdl.englab.netapp.com' -UseKnownResources:$false
This example syntax lists all resources of specified host.
Completed Discovering Resources: Job Id [21]
DatabaseName: R57
SID : R57
UserStoreKeys : cjU3uItRwnENhBzpUwKFGMsPL+sWzrS0LwLvh+BVhDJEh+hxGEBF00tcKka6ElLUjyXEPDULjXdVqw6GmlkIr+UuIa4Zq+pnGKlt0zRbM6E1ZxE8k6r8HElNgHrjY3JUsUvBS7RNQlOirVC6R2n93Qfd9A==
FileBackupPath :
FileBackupPrefix: SnapCenter_
OSDBUser: r57adm
TenantDatabaseNames : {R57, TDB01, TDB02, TDB03}
TenantType : MultiTenant
ResourceId : schana02.gdl.englab.netapp.com\hana\MDC\R57
ResourceUid : MDC\R57
PluginName : hana
Host: schana02.gdl.englab.netapp.com
ResourceType: MultipleContainers
Protected : No
RunAsName :
ResourceSettings:
MountPaths :
DiscoveryType : Auto
IsAuthenticated : Yes
DatabaseName: MDC
SID : MT1
UserStoreKeys : bXQxDY8049rvqv2jPtrmFNChtY9CuhhNBSnsSJ9Fzo13LYquhwnlDknOd+QeJepEFFSIEX0AxRFcYnQVm1RR5Ky2P3oi2vgEUrPqe0UoHkfBe/QgjDeeaIrBIr4CNIiXZVwKFxOm0oLxXcf4Uluo/amAhw==
FileBackupPath :
FileBackupPrefix: SnapCenter_
OSDBUser: root
TenantDatabaseNames : {}
TenantType : MultiTenant
ResourceId : schana02.gdl.englab.netapp.com\hana\MDC\MT1
ResourceUid : MDC\MT1
PluginName : hana
Host: schana02.gdl.englab.netapp.com
ResourceType: MultipleContainers
Protected : No
RunAsName :
ResourceSettings:
MountPaths :
DiscoveryType : Manual
IsAuthenticated : Not Applicable
DatabaseName : NonMDC_SN
SID : H01
UserStoreKeys: aDAx85jqzWC0G9U7i7ohDgG1VxG7E8AxaUKyD2BeRnv+fF3sluc9aZDdPUyaWgJwQ5ZAAe0IPBY/l1PGkli2DgffnbhPjwu9fPg+nKhlErLyjXp26txx+CJJWHAniekIAsJxLdc9aUrcKO4Xm5N2wdNgdQ==
FileBackupPath :
FileBackupPrefix : SnapCenter_
OSDBUser : user
ResourceId : schana02.gdl.englab.netapp.com\hana\H01
ResourceUid : H01
PluginName : hana
Host : schana02.gdl.englab.netapp.com
ResourceType : SingleContainer
Protected: No
RunAsName:
ResourceSettings :
MountPaths :
DiscoveryType: Manual
IsAuthenticated : Not Applicable
Example 8: Listing the resources for given sid and resource type
Get-SmResources -HostName 'schana02.gdl.englab.netapp.com' -PluginCode HANA -ResourceType MultipleContainers -UseKnownresources -SID 'R57' -DatabaseName 'R57'
This example lists all the resources of a specified host.
Completed Discovering Resources: Job Id [1692]
DatabaseName: R57
SID : R57
UserStoreKeys : cjU3YuC1vIPicEl3zD+B6o/fev9RR0vicLMY9+9iW3DGz0WN1WiAVHFywsnSJh3vlksKbR75f2klpfhgkI27yTZPxuja5HqHsTQVrW6ZITfirN9hfM61sHeI38LSBNNaKLCsfU4kk6Okk6QzZL+RVtht1g==
FileBackupPath :
FileBackupPrefix: SnapCenter_
OSDBUser: r57adm
TenantDatabaseNames : {R57, TDB01, TDB02, TDB03}
TenantType : MultiTenant
ResourceId : schana02.gdl.englab.netapp.com\hana\MDC\R57
ResourceUid : MDC\R57
PluginName : hana
Host: schana02.gdl.englab.netapp.com
ResourceType: MultipleContainers
Protected : No
RunAsName :
ResourceSettings:
MountPaths :
DiscoveryType : Auto
IsAuthenticated : Yes
Example 8: Get details of the specified resource using AppObjectId
Get-SmResources -PluginCode 'SCSQL' -HostName 'schana02.gdl.englab.netapp.com' -AppResourceId 'MVA-RX200-S13\SQLEXPRESS\DB16'
This example syntax displays the details of the resources (including cloud protection).
DBName: DB16 DBVersion : 11.0.2100 DBId : MVA-RX200-S13\SQLEXPRESS\DB16 DBType: SQL Database Protected : Yes OverallStatus : CloudProtected: Yes CloudProtectedPolices : sql_fulllog_backup_policy_daily
Example 9: Listing all Oracle Plug-in resources on a specified host
Get-SmResources -PluginCode 'SCO' -HostName 'R8092776CF4V1.HNK2.com' -UseKnownResources
This example lists all the SnapCenter Plug-in for Oracle resources on a specified host.
DBName: DB11 DBVersion : 19.0.0.0.0 DBId : R8092776CF4V1.HNK2.com\DB11 DBType: Oracle Single Instance Protected : No OverallStatus : Not protected DBName: DB13 DBVersion : 19.0.0.0.0 DBId : R8092776CF4V1.HNK2.com\DB13 DBType: Oracle Single Instance Protected : No OverallStatus : Not protected Name : appVolLun Uid : appVolLun Id: R8092776CF4V1.HNK2.com\appVolLun Type : Application Volume Protected : No OverallStatus : Not protected Name : appVol Uid : appVol Id: R8092776CF4V1.HNK2.com\appVol Type : Application Volume Protected : No OverallStatus : Not protected
Example 10: Listing all Oracle application volume resources on a specified host
Get-SmResources -PluginCode 'SCO' -HostName 'R8092776CF4V1.HNK2.com' -UseKnownResources -AppObjectType 'ApplicationVolume'
This example lists all the Oracle application volume resources on a specified host.
Name : appVolLun Uid : appVolLun Id: R8092776CF4V1.HNK2.com\appVolLun Type : Application Volume Protected : No OverallStatus : Not protected Name : appVol Uid : appVol Id: R8092776CF4V1.HNK2.com\appVol Type : Application Volume Protected : No OverallStatus : Not protected
Example 11: Listing all Oracle database resources on a specified host
Get-SmResources -PluginCode 'SCO' -HostName 'R8092776CF4V1.HNK2.com' -UseKnownResources -AppObjectType 'Database'
This example lists all the Oracle database resources on a specified host.
DBName: DB11 DBVersion : 19.0.0.0.0 DBId : R8092776CF4V1.HNK2.com\DB11 DBType: Oracle Single Instance Protected : No OverallStatus : Not protected DBName: DB13 DBVersion : 19.0.0.0.0 DBId : R8092776CF4V1.HNK2.com\DB13 DBType: Oracle Single Instance Protected : No OverallStatus : Not protected
Example 12: Get Oracle Plug-in resources on a specified host and filter by resource name
Get-SmResources -PluginCode 'SCO' -HostName 'R8092776CF4V1.HNK2.com' -UseKnownResources -AppObjectType 'ApplicationVolume' -ResourceName 'appVolLun'
This example gets the SnapCenter Plug-in for Oracle resources on a specified host and filters it by resource name
Name : appVolLun Uid : appVolLun Id: R8092776CF4V1.HNK2.com\appVolLun Type : Application Volume Protected : No OverallStatus : Not protected
Example 13: Trigger Discovery of Oracle Plug-in resources on a specified host and lists them
Get-SmResources -PluginCode 'SCO' -HostName 'R8092776CF4V1.HNK2.com'
This example triggers discovery of SnapCenter Plug-in for Oracle resources on a specified host and lists them.
Completed Discovering Resources: Job Id [3172] DBName: DB11 DBVersion : 19.0.0.0.0 DBId : R8092776CF4V1.HNK2.com\DB11 DBType: Oracle Single Instance Protected : No OverallStatus : Not protected DBName: DB13 DBVersion : 19.0.0.0.0 DBId : R8092776CF4V1.HNK2.com\DB13 DBType: Oracle Single Instance Protected : No OverallStatus : Not protected Name : appVolLun Uid : appVolLun Id: R8092776CF4V1.HNK2.com\appVolLun Type : Application Volume Protected : No OverallStatus : Not protected Name : appVol Uid : appVol Id: R8092776CF4V1.HNK2.com\appVol Type : Application Volume Protected : No OverallStatus : Not protected
Example 14: Trigger plug-in discovery and list the resources of specified host for UnixFileSystems
Get-SmResources -PluginName 'UnixFileSystems' -HostName 'linuxfs.gdl.englab.netapp.com' -UseKnownResources:$false
This example triggers discovery of UnixFileSystems Plug-in on a specified host and lists them.
Completed Discovering Resources: Job Id [420] ResourceName : /netapp/qtree1 ResourceId : linuxfs.gdl.englab.netapp.com\UnixFileSystems\/netapp/qtree1 ResourceUid : /netapp/qtree1 PluginName : UnixFileSystems Host : linuxfs.gdl.englab.netapp.com ResourceType : Path Protected: Yes RunAsName: ResourceSettings : MountPaths : DiscoveryType: Auto IsAuthenticated : Yes ResourceName : /netapp/qtree2 ResourceId : linuxfs.gdl.englab.netapp.com\UnixFileSystems\/netapp/qtree2 ResourceUid : /netapp/qtree2 PluginName : UnixFileSystems Host : linuxfs.gdl.englab.netapp.com ResourceType : Path Protected: Yes RunAsName: ResourceSettings : MountPaths : DiscoveryType: Auto IsAuthenticated : Yes