Metodo Server.EnumAvailableMedia (MediaTypes)

Articolo
07/13/2013

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.

Spazio dei nomi Microsoft.SqlServer.Management.Smo
Assembly: Microsoft.SqlServer.Smo (in Microsoft.SqlServer.Smo.dll)

Sintassi

'Dichiarazione
Public Function EnumAvailableMedia ( _
    media As MediaTypes _
) As DataTable
'Utilizzo
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

Parametri

media
Tipo: Microsoft.SqlServer.Management.Smo.MediaTypes
A MediaTypes object value that specifies the type of media to which the results are limited.

Valore restituito

Tipo: 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.

Esempi

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]
   }
}