Export (0) Print
Expand All
This topic has not yet been rated - Rate this topic

Server.EnumWindowsUserInfo Method

Enumerates a list of information about all Microsoft Windows users that have explicitly granted access to SQL Server.

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

Return Value

Type: System.Data.DataTable
A DataTable system object value that contains a list of Windows users that have explicitly granted access to the instance of SQL Server.The table describes the different columns of the returned DataTable.

Column

Data type

Description

account name

String

The name of the Windows NT user.

type

String

The type of user. This specifies whether the user is an individual account or a group account.

C#

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

DataTable d = srv.EnumWindowsUserInfo();
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 = $srv.EnumWindowsUserInfo()
foreach ($r in $d.Rows)
{
   Write-Host "============================================"
   Foreach ($c in $d.Columns)
   {
      Write-Host $c.ColumnName "=" $r[$c]
   }
}
Did you find this helpful?
(1500 characters remaining)
Thank you for your feedback

Community Additions

ADD
Show:
© 2014 Microsoft. All rights reserved.