Share via

  • Article

Server.EnumAvailableMedia Method (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.

Namespace:  Microsoft.SqlServer.Management.Smo
Assembly:  Microsoft.SqlServer.Smo (in Microsoft.SqlServer.Smo.dll)

Syntax

'Declaration
Public Function EnumAvailableMedia ( _
    media As MediaTypes _
) As DataTable
'Usage
Dim instance As Server
Dim media As MediaTypes
Dim returnValue As DataTable

returnValue = instance.EnumAvailableMedia(media)

public DataTable EnumAvailableMedia(
    MediaTypes media
)

public:
DataTable^ EnumAvailableMedia(
    MediaTypes media
)

member EnumAvailableMedia : 
        media:MediaTypes -> DataTable 

public function EnumAvailableMedia(
    media : MediaTypes
) : DataTable

Parameters

Return Value

Type: System.Data.DataTable
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]
   }
}