Server.EnumAvailableMedia Server.EnumAvailableMedia Server.EnumAvailableMedia Method

Definition

Enumerates a list of media that are visible to the instance of SQL Server on the local area network.

Overloads

EnumAvailableMedia(MediaTypes) EnumAvailableMedia(MediaTypes) EnumAvailableMedia(MediaTypes)

Enumerates a list of media that is visible to the instance of SQL Server on the local area network and limited to the type of media specified.

EnumAvailableMedia() EnumAvailableMedia() EnumAvailableMedia()

Enumerates a list of media that is visible to the instance of SQL Server on the local area network.

EnumAvailableMedia(MediaTypes) EnumAvailableMedia(MediaTypes) EnumAvailableMedia(MediaTypes)

Enumerates a list of media that is visible to the instance of SQL Server on the local area network and limited to the type of media specified.

public:
 System::Data::DataTable ^ EnumAvailableMedia(Microsoft::SqlServer::Management::Smo::MediaTypes media);
public System.Data.DataTable EnumAvailableMedia (Microsoft.SqlServer.Management.Smo.MediaTypes media);
Public Function EnumAvailableMedia (media As MediaTypes) As DataTable
Parameters
media
MediaTypes MediaTypes MediaTypes

A MediaTypes object value that specifies the type of media to which the results are limited.

Returns

A DataTable object value that contains the available media information. The table describes the different columns of the returned DataTable.

Column
Data type
Description
Name
String The name of the drive.
LowFree
Int32 The low order double word of available media resource.
HighFree
Int32 The high order double word of available media resource
MediaTypes
Int32 The media type. See MediaTypes.

Examples

C#

Server srv = new Server("(local)");  

DataTable d = srv.EnumAvailableMedia(MediaTypes.All);  
foreach (DataRow r in d.Rows)  
{  
   Console.WriteLine("============================================");  
   foreach(DataColumn c in d.Columns)  
   {  
      Console.WriteLine(c.ColumnName + " = " + r[c].ToString());  
   }  
}  

PowerShell

$srv = new-Object Microsoft.SqlServer.Management.Smo.Server("(local)")  

$d = new-object System.Data.Datatable  
$d = $srv.EnumAvailableMedia([Microsoft.SqlServer.Management.Smo.MediaTypes]::All)  

Foreach ($r in $d.Rows)  
{  
   Write-Host "============================================"  
   Foreach ($c in $d.Columns)  
   {  
      Write-Host $c.ColumnName "=" $r[$c]  
   }  
}  

EnumAvailableMedia() EnumAvailableMedia() EnumAvailableMedia()

Enumerates a list of media that is visible to the instance of SQL Server on the local area network.

public:
 System::Data::DataTable ^ EnumAvailableMedia();
public System.Data.DataTable EnumAvailableMedia ();
Public Function EnumAvailableMedia () As DataTable
Returns

A DataTable object value that contains the available media information. The table describes the different columns of the returned DataTable.

Column
Data type
Description.
Name
String The name of the drive.
LowFree
Int32 The low order double word of available media resource.
HighFree
Int32 The high order double word of available media resource
MediaTypes
Int32 The media type. See MediaTypes.

Examples

C#

Server srv = new Server("(local)");  

DataTable d = srv.EnumAvailableMedia();  
foreach (DataRow r in d.Rows)  
{  
   Console.WriteLine("============================================");  
   foreach(DataColumn c in d.Columns)  
   {  
      Console.WriteLine(c.ColumnName + " = " + r[c].ToString());  
   }  
}  

PowerShell

$srv = new-Object Microsoft.SqlServer.Management.Smo.Server("(local)")  

$d = new-object System.Data.Datatable  
$d = $srv.EnumAvailableMedia()  

Foreach ($r in $d.Rows)  
{  
   Write-Host "============================================"  
   Foreach ($c in $d.Columns)  
   {  
      Write-Host $c.ColumnName "=" $r[$c]  
   }  
}  
See Also

Applies to