# Replace the connection string below :
$connectionstring = "Data Source=XXXXXXXXXXXXXX;Application Name=AvectoIC3;Initial Catalog=Avecto.IC3.Database.Management;Integrated Security=True"

$sqlConn = New-Object System.Data.SqlClient.SqlConnection
$sqlConn.ConnectionString = $connectionString
$sqlConn.Open()
$sqlcmd = New-Object System.Data.SqlClient.SqlCommand
$sqlcmd.Connection = $sqlConn
$query = "SELECT * from dbo.[User]"
$sqlcmd.CommandText = $query
$adp = New-Object System.Data.SqlClient.SqlDataAdapter $sqlcmd
$data = New-Object System.Data.DataSet
$adp.Fill($data) | Out-Null
Write-Host "IC3 Users"
$data.Tables[0][0].AccountName
Write-Host "Database contacted successfully"
$sqlConn.Close()