When running PowerShell script as a scheduled task some Exchange 2010 database properties are null
- by barophobia
Hello,
I've written a script that intends to retrieve the DatabaseSize of a database from Exchange 2010. I created a new AD user for this script to run under as a scheduled task. I gave this user admin rights to the Exchange Organization (as a last resort during my testing) and local admin rights on the Exchange machine.
When I run this script manually by starting powershell (with runas /noprofile /user:domain\user powershell) everything works fine. All the database properties are available. When I run the script as a scheduled task a lot of the properties are null including the one I want: DatabaseSize.
I've also tried running the script as the domain admin account with the same results.
There must be something different in the two contexts but I can't figure out what it is.
My script:
Add-PSSnapin Microsoft.Exchange.Management.PowerShell.E2010
Write-EventLog 'Windows PowerShell' -source PowerShell -eventid 100 -message "Starting script"
$databases = get-mailboxdatabase -status
if($databases -ne $null)
{
Write-EventLog 'Windows PowerShell' -source PowerShell -eventid 100 -message "Object created"
$databasesize_text = $databases.databasesize.tomb().tostring()
if($databasesize_text -ne $null)
{
$output = "echo "+$databasesize_text+":ok"
Write-EventLog 'Windows PowerShell' -source PowerShell -eventid 100 -message "Path check"
if(test-path "\\mon-01\prtgsensors\EXE\")
{
Write-EventLog 'Windows PowerShell' -source PowerShell -eventid 100 -message "Path valid"
Set-Content \\mon-01\prtgsensors\EXE\ex-05_db_size.bat -value $output
}
Write-EventLog 'Windows PowerShell' -source PowerShell -eventid 100 -message "Exiting program"
}
else
{
Write-EventLog 'Windows PowerShell' -source PowerShell -eventid 100 -message "databasesize_text is empty. nothing to do"
}
}
else
{
Write-EventLog 'Windows PowerShell' -source PowerShell -eventid 100 -message "object not created. nothing to do"
}
exit 0
