That was my problem, i recreated the password file as the user running the scheduled task and now it works fine. One other issue i found was the ftp function in my script stopped working because that user account had a proxy setup in its internet settings, once i removed that it worked again.
I also attached it so others can see it, with comments in the code.
#vCenters Servers to Connect
$viservers = "vServer1","vServer2","vServer3","vServer4"
#Username to connect to vCenters
$userName = "username"
#Powershell encrypted password file, encrypt with user account running the script
$passwd = get-content D:\Scripts\pass.txt | convertto-securestring
#Gets username and Password and passes it to function below
$cred = New-Object -TypeName System.Management.Automation.PSCredential -ArgumentList $userName,$passwd
#Connects to each vCenter and collects the information below for a report
foreach ($singleViserver in $viservers)
{
Connect-VIServer $singleViserver -Credential $cred
$HostReport = @()
Get-VM |Get-View | %{
$Report = "" | select Name, VMuuid, ESXhost, VMos, IP, FQDN, Status, Customer
$Report.Name = $_.Name
$Report.VMuuid =$_.Summary.Config.uuid
$Report.ESXhost = (Get-View $_.Runtime.Host).Name
$Report.VMos =$_.Summary.Config.GuestFullName
$Report.IP =$_.Guest.IPAddress
$Report.FQDN =$_.Guest.HostName
$Report.Status = $_.Runtime.PowerState
$Report.Customer = (Get-VIObjectByVIView $_).CustomFields
$HostReport += $Report
}
#Disconnects after each vCenter
Disconnect-VIServer -Confirm:$False
}
#Creates a CSV file with the output of the above, create 1 file for all vCenters
$HostReport | Export-Csv ".\Full-HostReport.csv" -Delimiter "|" ñNoTypeInformation
#Takes output CSV and uploads to FTP Server
{
# create the FtpWebRequest and configure it
$ftp = [http://System.Net.FtpWebRequest|http://System.Net.FtpWebRequest]::Create("ftp://yourserver.com/Full-HostReport.csv")
$ftp = [http://System.Net.FtpWebRequest|http://System.Net.FtpWebRequest]$ftp
$ftp.Method = [http://System.Net.WebRequestMethods+Ftp|http://System.Net.WebRequestMethods+Ftp]::UploadFile
$ftp.Credentials = new-object System.Net.NetworkCredential("Username","Username@server.com")
$ftp.UseBinary = $true
$ftp.UsePassive = $true
# read in the file to upload as a byte array
$content = gc -en byte D:\Scripts\Full-HostReport.csv
$ftp.ContentLength = $content.Length
# get the request stream, and write the bytes into it
$rs = $ftp.GetRequestStream()
$rs.Write($content, 0, $content.Length)
# be sure to clean up after ourselves
$rs.Close()
$rs.Dispose()
}
Cheers,
Bradley Sessions
If you found this or other information useful, please consider awarding points for "Correct" or "Helpful".
Cheers!
If you found this or other information useful, please consider awarding points for "Correct" or "Helpful".
, C