################################################
# Setting Cert Policy - required for successful auth of API
################################################
add-type @"
using System.Net;
using System.Security.Cryptography.X509Certificates;
public class TrustAllCertsPolicy : ICertificatePolicy {
public bool CheckValidationResult(
ServicePoint srvPoint, X509Certificate certificate,
WebRequest request, int certificateProblem) {
return true;
}
}
"@
[System.Net.ServicePointManager]::CertificatePolicy = New-Object TrustAllCertsPolicy
[Net.ServicePointManager]::SecurityProtocol = [Net.SecurityProtocolType]::Tls12
$isodate=Get-Date -format s 
$isodate=$isodate -replace(":","")
$ErrorLog="E:\SQLSchedulers\PostgreSQLDBInventoryDashboard_UAT\ErrorLog\Errorlog_"+$isodate +".txt"
$Log="E:\SQLSchedulers\PostgreSQLDBInventoryDashboard_UAT\Log\DBDashBoard_log_"+$isodate +".txt"
$dt = new-object "System.Data.DataTable" 
foreach ($svr in get-content "E:\SQLSchedulers\PostgreSQLDBInventoryDashboard_UAT\server.txt")
{ 
	Try
	{
		$sf = "E:\SQLSchedulers\PostgreSQLDBInventoryDashboard_UAT\tmp\test.txt"
		if (Test-Path $sf)
			{
				Remove-Item $sf
			}
		$svr
		$DBConn = "Driver={PostgreSQL UNICODE(x64)};Server=$svr;Port=5432;Database=postgres;Uid=postgres;Pwd=Devops123!@#;"
		$cn = New-Object System.Data.Odbc.OdbcConnection;
		$cn.ConnectionString = $DBConn;
		$cn.Open();
		$sql = $cn.CreateCommand()
		$query = "SELECT datname FROM pg_database where datname not in ('postgres','template1','template0','dvdrental')"
		$cmd = New-object System.Data.Odbc.OdbcCommand($query, $cn)
		$ds = New-Object system.Data.DataSet
				(New-Object System.Data.Odbc.OdbcDataAdapter($cmd)).Fill($ds) | Out-Null
		$sql.CommandTimeout = 0
		$dt.clear()
		"Successfully Connected to $svr" | Add-Content $Log
		$cn.Close()
		$ds.Tables[0] | Export-Csv $sf -Encoding UTF8 -notypeinfo
		
    }   
	Catch
	 {
	 "$svr $_ "| Add-Content $ErrorLog
	 }
}