663 thoughts on “Generate Exchange Environment Reports using Powershell”

1. hello stev

   my name is nir and i am system admin on a company in the Communications

   industry in israel.

   i am fascinated from your blog and now i am trying to use your

   “Generate Exchange Environment Reports using Powershell”.

   my environment is 2 exchange 2010 in a dag that run over servers 2008r2 sp1.

   i can run the script without errors but in the html report there are many details that missing like :

   Database Name
   Mailboxes Av. Mailbox Size Archive MBs Av. Archive Size DB Size/WhiteSpace Last Full Backup Circular Logging
   Active Owner Copies (n)
   what can go wrong ?

2. hellp !!

   graete script !!

   i run it in my production environment … Exchange 2010 SP3 UR11 ..win srv 2008 r2 ent.

   its all good but many information don’t appears in the report.

   details like :Database Name ,MailboxesAv., Mailbox Size, Archive MBsAv. Archive Size, DB Size/WhiteSpace, Last Full Backup, Circular Logging,Active Owner Copies (n)

   any help ??

3. Hi Everybody,

   When we ran Exchange Environment Report, It was completed the following error.

   Exchange 2010 DAG.

   “You must provide a value for this property.
   (0:Int32) [Get-MailboxDatabase]
   FullyQualifiedErrorId: 179A7E5B,Microsoft,Exchange,management,SystemConfigurationTasks.GetMailboxDatabase”

   Thanks in advanced.

4. Hi everbody,

   We have DAG (Eight Mbox Server) (both servers with each other)

   When we ran Exchange Environment Report, It was completed the following error.

   And report had created missing..

   ==============================================
   You must provide a value for this property.
   + CategoryInfo : NotSpecified: (0:Int32) [Get-MailboxDatabase], DataValidationException
   + FullyQualifiedErrorId : 16C18E48,Microsoft.Exchange.Management.SystemConfigurationTasks.GetMailboxDatabase
   ======================================

   Thank in advance.

5. Hi Steve,

   Thanks for this awesome script. I have been using it in many environments. In one of the environments that we use the script we have been asked if we can report on a specific site only.

   Please advise if this would be possible?

6. Hello, i noticed the Database Disk Free %’s isn’t accurate. I have Exchange 2013 with both DB and Logs in a single 900GB LUN. Example i have: is a DB with only 45 mailboxes amounting to 72GB (including Logs) and the % is claiming 79 when it should only be 92.

   Let me know if i’m simply misunderstanding what the value is expected to be. 🙂

   Sample:

   Mailboxes Av. Mailbox Size DB Size DB Whitespace Database Disk Free Log Disk Free
   45 1,283.70 MB 66.13 GB 0.04 GB 79.5% 79.5%

7. Hi Steve,

   I am trying to run this report on Exchange 2013 CU9 (4x node DAG) and unable to retrieve any information about databases. It provides report about servers but all information related to DAG is missing/ empty (servers, database name, mailboxes and etc.).

8. Hey Steve – While running this on a single Exchange 2010 server with just one database, it doesn’t return any info about the database at all. I ran it on an Exchange 2010 SP2 UR5 v2. Any advice?Thanks.

9. On a single box with exchange 2013 getting this error when running from exchange shell

   Exception calling “Join” with “2” argument(s): “Value cannot be null.
   Parameter name: values”
   At C:\users\Administrator\Desktop\Get-ExchangeEnvironmentReport.ps1:585 char:9
   + $ExtNames = [system.String]::Join(“,”,$ExtNames)
   + ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
   + CategoryInfo : NotSpecified: (:) [], MethodInvocationException
   + FullyQualifiedErrorId : ArgumentNullException

10. Steve,

    I am running the following script on Exchange PowerShell and I am not getting prompted for Task Scheduler Password. Everything else works.

    .\Get-ExchangeEnvironmentReport -HTMLReport c:\ExchangeReport.html -SendMail:$true -MailFrom:system@domain.com -MailTo:user@domain.com -MailServer:webmail.domain.com -ScheduleAs:domain\admin

    Anything that I am doing wrong?

11. Hi Steve,
    i have set the $ServerFilter option to look at my server naming convention, but the report still tries to scan the entire org, i changed “*” to “server0*” for exampple, what else am i missing?

    regards

12. Steve,
    Brilliant script sir! Unfortunately, I need some tutoring on how to accomplish the following:
    – Append the DATE to both email Subject and HTMLReport
    – Filter servers parsed (wildcard won’t work due to naming convention)
    – Either exclude multiple servers (“Ex2, Ex4”) from the report, but still parsing Ex1, Ex3, & Ex5
    – Or specifying just the server to parse “Ex1, Ex3, Ex5”

13. Hi Steve, thank you for your script.
    It run successfully when I enter directly into Exchange Power Shell:
    D:\Scripts>.\Get-ExchangeEnvironmentReport.ps1 -HTMLReport report.html
    But it fail when I try to run it in cmd:
    D:\Scripts>C:\Windows\System32\WindowsPowerShell\v1.0\powershell.exe -command “D
    :\Scripts\Get-ExchangeEnvironmentReport.ps1 -HTMLReport report.html”
    Exchange Management Shell cannot be loaded
    At D:\Scripts\Get-ExchangeEnvironmentReport.ps1:825 char:3
    + throw “Exchange Management Shell cannot be loaded”
    + ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
    + CategoryInfo : OperationStopped: (Exchange Manage…annot be lo
    aded:String) [], RuntimeException
    + FullyQualifiedErrorId : Exchange Management Shell cannot be loaded

    • I fixed it, I should edit Exchange installation path from line 817 to 825 in script file, cause I use Exchange 2013.

14. Steve,

    Great work on this script.

    I used it for the last few years and worked great. I am just wondering where and how do I setup the parameters if I want to email the report on a daily basis. I am a bit confused to where to set the parameters, a good example will help me.

15. dumbest question you will ever get… How should I go about modifying your awesome report so that it just data dumps to CSV instead? I will probably need to split it up into multiple ps1 files to do a data dump of each table of information into separate CSV files. Any help is much appreciated!!!

16. Hi Steve,
    It does seem script not working with mount points on Exchange servers. I get the details almost all the details except database names, amount of mailboxes per database, size of databases and etc.

17. I’ve tried using the above suggestions, like what Daren and Ian, however I can’t seem to get the script to run with a scheduled task even with the ExecutionPolicy Bypass option. I’ve tried a a few different arguments as well, like:

    PowerShell.exe -ExecutionPolicy Bypass -PSConsoleFile “D:\Program Files\Microsoft\Exchange Server\V14\Bin\ExShell.psc1” -Command “. ‘C:\Scripts\Get-ExchangeEnvironmentReport -HTMLReport C:\Scripts\ExchangeReport.html -SendMail:$true -MailFrom:server@mancan.com -MailTo:something@mancan.com -MailServer:something.mancan.com'”

    But it’s not working. Running Exchange 2010 SP1, the scheduled task is on that server with allow whether user is logged in or not and highest priority. Any thoughts?

18. Hi Steve, I got here cause I needed to get a good report about a Exchange 2007 environment and ExBPA is not a good one to get the right info
    I have a problem already reported here

    Exception calling “Join” with “2” argument(s): “Value cannot be null.
    Parameter name: value”
    At C:\Users\tisistemas\Desktop\Get-ExchangeEnvironmentReport.ps1:584 char:42
    + $IntNames = [system.String]::Join <<<< (",",$IntNames)
    + CategoryInfo : NotSpecified: (:) [], MethodInvocationException
    + FullyQualifiedErrorId : DotNetMethodException

    Exception calling "Join" with "2" argument(s): "Value cannot be null.
    Parameter name: value"
    At C:\Users\tisistemas\Desktop\Get-ExchangeEnvironmentReport.ps1:585 char:42
    + $ExtNames = [system.String]::Join <<<< (",",$ExtNames)
    + CategoryInfo : NotSpecified: (:) [], MethodInvocationException
    + FullyQualifiedErrorId : DotNetMethodException

    Exception calling "Join" with "2" argument(s): "Value cannot be null.
    Parameter name: value"
    At C:\Users\tisistemas\Desktop\Get-ExchangeEnvironmentReport.ps1:584 char:42
    + $IntNames = [system.String]::Join <<<< (",",$IntNames)
    + CategoryInfo : NotSpecified: (:) [], MethodInvocationException
    + FullyQualifiedErrorId : DotNetMethodException

    Exception calling "Join" with "2" argument(s): "Value cannot be null.
    Parameter name: value"
    At C:\Users\tisistemas\Desktop\Get-ExchangeEnvironmentReport.ps1:585 char:42
    + $ExtNames = [system.String]::Join <<<< (",",$ExtNames)
    + CategoryInfo : NotSpecified: (:) [], MethodInvocationException
    + FullyQualifiedErrorId : DotNetMethodException

    I get a chopped report only with the first part and DBs info but no info about virtual directories or other things. I downloaded the lasted version 1.6.1.
    Also, I have Exchange 2007 SP3 without UR, but the report says that I have UR8.
    Do you know what could be happening?

    Thanks!

19. I have added a command to the Get-MailboxDatabase commands to reduce the errors on unmounted databases.

    | Get-MailboxDatabaseCopyStatus | where {$_.Status -eq “mounted”}

    • Moderator, you can delete this one, it doesn’t work. Posted too soon.

20. Is it possible to pull the following info out of what is already being collected? I have a script that I can run and it gets me this info, I have added to the 1.61 version of your script, and it gives me the data, but only pulls it from the 2013 Exchange servers. When I run it as a standalone, it pulls from the 2010 servers also.

    Number of Databases Total DB Size Average DB Size Largest DB Size Smallest DB Size

    The script is below, along with results.

    $MailboxStorageStats = get-mailboxdatabase -IncludePreExchange2013 | foreach-object{select-object -inputobject $_ -property *,@{name=”MailboxDBSizeinGB”;expression={[math]::Round(((get-item (“\\” + $_.servername + “\” + $_.edbfilepath.pathname.replace(“:”,”$”))).length / 1GB),2)}}} | Sort-Object mailboxdbsizeinGB -Descending | measure-object -Property mailboxdbsizeinGB -Sum -Maximum -Minimum -Average
    $MBXCount = “{0:n0}” -f ($mailboxcount1.Count)
    $DLCount = “{0:n0}” -f ($DLCount1.Count)
    $MBXDatabaseCount = “{0:n0}” -f ($MailboxStorageStats.Count)
    $MBXDatabaseSizeTotal = “{0:n2}” -f ($MailboxStorageStats.Sum)
    $MBXDatabaseAverage = “{0:n2}” -f ($MailboxStorageStats.Average)
    $MBXDatabaseLargest = “{0:n2}” -f ($MailboxStorageStats.Maximum)
    $MBXDatabaseSmallest = “{0:n2}” -f ($MailboxStorageStats.Minimum)

    $file = “Test.html”

    Add-content $file “”
    Add-content $file “Exchange Database Statistics”
    Add-content $file “Generated $((Get-Date).ToString())”
    Add-content $file “on server $server”
    Add-content $file “Number of DatabasesTotal DB SizeAverage DB SizeLargest DB SizeSmallest DB Size”
    Add-content $file “$MBXDatabaseCount”,”$MBXDatabaseSizeTotal GB”,”$MBXDatabaseAverage GB”,”$MBXDatabaseLargest GB”,”$MBXDatabaseSmallest GB”
    Add-content $file “”

    Results running as standalone:
    Number of Databases Total DB Size Average DB Size Largest DB Size Smallest DB Size
    76 10,328.00 GB 135.89 GB 680.00 GB 0.00 GB

    Results when included in the 1.61 script:
    Number of Databases Total DB Size Average DB Size Largest DB Size Smallest DB Size
    11 696.02 GB 63.27 GB 680.00 GB 0.00 GB

21. Has anybody tried the option ServerFilter?

    For me (Exchange 2010 SP3 UR11 DAG on Server 2008R2) it does not count the mailboxes anymore!?
    I’ve checked the script and found
    – there is no Server for the result of Get-Mailbox
    – use ServerName instead

    So I’ve changed two lines in Section _UpProg1 10 “Getting Mailboxes” and _UpProg1 60 to $_.ServerName
    -> $Mailboxes = [array](Get-Mailbox -ResultSize Unlimited) | Where {$_.ServerNAME-like $ServerFilter}
    and voila the html contains the number of filtered mailboxes.

22. Today I noticed that 3 of our Mailbox servers in Montana hadn’t had a full backup since the 10th. I contacted the tech onsite, and he sent me a screen shot of the backups as being successful every day. I ran the script again, it then reported that the backups had run this morning about 3 hours before the script ran. I noticed that all of the error checking seems to be set to silently continue. Is there an easy way to report on failed connections?

    Ken

23. Hello Steve, Thank you very much :-).

    Having an issue where the outputted html report shows site information but not database, I’m sure I am doing something dumb any help is appreciated.

    2010 SP3 UR9, Server 2008 R2 Std.

24. Pingback: Top 5 Tips for Migrating to Office 365 | Essential

25. Running this in our test environment which is Exchange 2010 SP3 and using powershell 2.0 I’m getting:

    Exception calling “Join” with “2” argument(s): “Value cannot be null.
    Parameter name: value”
    At D:\Install\Get-ExchangeEnvironmentReport.ps1:585 char:42
    + $ExtNames = [system.String]::Join <<<< (",",$ExtNames)
    + CategoryInfo : NotSpecified: (:) [], MethodInvocationException
    + FullyQualifiedErrorId : DotNetMethodException

    Using Version 1.6.1 of your script, any ideas?

    GREAT WORK.

    • Do any servers have all blank external names? BTW is the report coming out OK?

      • same here no external blank names, and no the report does not generate.

      • I’m getting the same thing. I do have blank external URL’s so is there a workaround?

    • Hey Guys, I’m running a hybrid with exchange 2010 & 2013 CU8. I kept on receive the error below and the report doesn’t show enough information. Can someone help?

      Cannot process argument transformation on parameter ‘Server’. Cannot convert value “removed” to type “Microsoft.Exchange.Configuration.Tasks.ServerIdParameter”. Error: “Cannot
      convert hashtable to an object of the following type: Microsoft.Exchange.Configuration.Tasks.ServerIdParameter. Hashtable-to-Object conversion is not supported in restricted
      language mode or a Data section.”
      + CategoryInfo : InvalidData: (:) [Get-OwaVirtualDirectory], ParameterBindin…mationException
      + FullyQualifiedErrorId : ParameterArgumentTransformationError,Get-OwaVirtualDirectory
      + PSComputerName : pbmbx01w.secure.protective.com

      Cannot process argument transformation on parameter ‘Server’. Cannot convert value “Removed” to type “Microsoft.Exchange.Configuration.Tasks.ServerIdParameter”. Error: “Cannot
      convert hashtable to an object of the following type: Microsoft.Exchange.Configuration.Tasks.ServerIdParameter. Hashtable-to-Object conversion is not supported in restricted
      language mode or a Data section.”
      + CategoryInfo : InvalidData: (:) [Get-WebServicesVirtualDirectory], ParameterBindin…mationException
      + FullyQualifiedErrorId : ParameterArgumentTransformationError,Get-WebServicesVirtualDirectory
      + PSComputerName : “removed”

      • Are you running this from the Exchange Management Console on a 2013 CU8 server?

        • Yes, I did.

    • replace lines 582-590:
      $IntNames = $IntNames|Sort -Unique
      $ExtNames = $ExtNames|Sort -Unique
      $IntNames = [system.String]::Join(“,”,$IntNames)
      $ExtNames = [system.String]::Join(“,”,$ExtNames)
      if ($IntNames)
      {
      $IntNamesText=”Internal Names: $($IntNames)”
      $ExtNamesText=”External Names: $($ExtNames)”
      }

      with:
      $IntNames = $IntNames|Sort -Unique
      $ExtNames = $ExtNames|Sort -Unique

      if ($IntNames)
      {
      $IntNames = [system.String]::Join(“,”,$IntNames)
      $IntNamesText=”Internal Names: $($IntNames)”
      }

      if ($ExtNames)
      {
      $ExtNames = [system.String]::Join(“,”,$ExtNames)
      $ExtNamesText=”External Names: $($ExtNames)”
      }

26. Pingback: New version of the Exchange Environment Report available now | Steve Goodman's Exchange & Office 365 Blog

27. Hi Steve,
    many thanks for your great script. I’m using it with the Task Scheduler to get a daily overview.
    I have also created a reporting tool, maybe it is interesting for the german users:
    https://www.frankysweb.de/exchange-report/
    have a nice day, regards Frank

    • Looks cool!

    • Any chance of a English language version.

    • Do you have an English version for this. It looks amazing as a dash board

    • How did you configure it with Task Scheduler? Working on doing the same but keeps failing.

28. Any Chance that you will adding non hybrid office 365 support?

    • What would you like to see?

29. hi. thanks for the script. one question: i have two mbx in a DAG, the report would give the number of mailboxes only on one mbx server. the other mbx server have 0 mailboxes. why is that?

    • What version of Exchange and roll up?

      • I have had that since I started using it. Pretty sure it only reports mailboxes on the active server.

        Ken

30. Pingback: PowerShell Scripts for your Exchange and Office 365 Toolkit

31. can I add CC in command?

    -SendMail:$true -MailFrom:you@example.com -MailTo:you@example.com -MailServer:smtp.example.com -ScheduleAs:DOMAIN\user

    • Yes you cokld

32. Running on EXCH 2007 error as below –>

    Exception calling “Join” with “2” argument(s): “Value cannot be null.
    Parameter name: value”
    At C:\…\Get-ExchangeEnvironmentReport.ps1:567 char:42
    + $IntNames = [system.String]::Join <<<< (",",$IntNames)
    + CategoryInfo : NotSpecified: (:) [], MethodInvocationException
    + FullyQualifiedErrorId : DotNetMethodException

    • Which version are you using? The Ex 2007 specific one?

      • I get this as well on both of our Ex2007 environments. One has Exch 2007 SP3 UR11 on Windows Server 2003 w/ PowerShell 2.0, the other has Exch 2007 SP3 UR17 on Windows Server 2008.

        Great script! Which version of the script is Ex 2007 specific?

        • Hi Steve,

          I’ve just tried the new update – I’m just seeing “Exchange 2007 SP3” now, with no UR number.

          Cheers,
          James

          • Hi James, I’ll take a look and see if I can reproduce.

          • OK, I’ve updated it. My fault – commented out a line during testing Ex2016 support.

          • I’m a bit confused.
            I would have thought Rollup was RU.
            What does UR stand for?

            (Or is it just a typo?)

33. Hello,

    There is a bad display of echange 2010 SP3 RU 10 version if other RU has been applied before this one. To resolve this, just add [int] in front of variable compare on line 356 in v1.5.8 to evaluate them as numerical and not as string : if ([int]$tRU -ge [int]$RollupLevel) { $RollupLevel=$tRU; $RollupVersion=$tRUV }

    • Thanks I’ve added this along with extra stuff to the script. Thanks again.

34. Dear, I have the problem in my Exchange 2007:

    Exception calling “Join” with “2” argument(s): “Value cannot be null.
    Parameter name: value”
    At C:\scripts\Get-ExchangeEnvironmentReport.ps1:567 char:42
    + $IntNames = [system.String]::Join <<<< (",",$IntNames)
    + CategoryInfo : NotSpecified: (:) [], MethodInvocationException
    + FullyQualifiedErrorId : DotNetMethodException

    • Which version of PS are you running?

      • Hello,

        I have the same error : Join” with “2” argument(s): “Value cannot be nul”.

        Error message :

        Exception calling “Join” with “2” argument(s): “Value cannot be null.
        Parameter name: value”
        At E:\Program Files\Microsoft\Exchange Server\V14\Scripts\Get-ExchangeEnvironmentReport.ps1:584 char:42
        + $IntNames = [system.String]::Join <<<< (",",$IntNames)
        + CategoryInfo : NotSpecified: (:) [], MethodInvocationException
        + FullyQualifiedErrorId : DotNetMethodException

        Exception calling "Join" with "2" argument(s): "Value cannot be null.
        Parameter name: value"
        At E:\Program Files\Microsoft\Exchange Server\V14\Scripts\Get-ExchangeEnvironmentReport.ps1:585 char:42
        + $ExtNames = [system.String]::Join <<<< (",",$ExtNames)
        + CategoryInfo : NotSpecified: (:) [], MethodInvocationException
        + FullyQualifiedErrorId : DotNetMethodException

        With :

        1.6.1 script's version.
        Exchange 2010 SP3 UR10
        Windows Server 2008 R2 Ent Service Pack 1

        many thanks,

35. Goodnight Steve, I have a script that generates this information and send it to a Bank of SQL?

    Regards,

    Jose Roberto Machado

36. Pingback: Admin Admin Podcast #027 Show Notes – Nmaping it all up | The Admin Admin Podcast

37. Any thoughts whether this report might be able to include edition and perhaps total # of Active Sync devices?

    • Yes it could do, I’ve not had the request before

38. Hi, I\m running Exchange 2013 RU9 and script not showing exchange version. Please contact me i will send you screenshot. Thank you

    • What is it showing?

39. Hello friends I hope I help run the scripts in the domain not the entire forest , I need to thank

40. any luck with updating so it shows exchange 2010 sp3 ru10 information?

41. Hi Steve,

    This script is a life saver in our daily checks. Thanks for the great work.
    Having some issues with the latest Rollup 10 that we updated Exchange 2010 too. The script still thinks we are on RU9?

    How do I rectify this in the script?

    Also how would I sort and list the databases by db name instead of sorted by which server they are mounted on?

    Many thanks

    Wes

    • Hiya, I’ll be posting an update for this soon

42. Pingback: Top 5 Tips for Migrating to Office 365 - Essential Computing

43. I’m running this script from a workstation with Exchange 2013 tools installed. I get errors, and while the HTML report is generated and the DAG information is displayed, there are no databases listed and no details about the databases

    • Hiya, it should work fine with Remote PowerShell (that’s what I assume when you say 2013 tools on a workstation) but it is designed to run on-server. What errors do you get? Do you have connectivity to all servers?

      • Hi, I am trying to run this on a windows 8.1 machine that has the 2013 exchange tools installed on it too, I get some information in the report such as the server and DAG names, but none of the exchange information such as mailboxes, server versions, disk space etc all of the fields are blank. If I run it from the exchange server directly it is fine and has all of the info within the report. How can I get this to run from a workstation with the 2013 exchange tools installed rather than from the actual exchange server?

44. Generate Exchange Environment Reports using Powershell – to the rescue again! http://t.co/SJWsoYN82g @stevegoodman @msftexchange

45. Steve, Great Utility! Definitely useful for sizing when looking to upgrade, as well as current state snapshot.

    Any thoughts to adding a more detailed outputs. For instance giving advanced options to gather URI configurations, certificate, send/receive connector settings, etc?

    I might give it a go and add these things in as well either through separate powershell scripts or expand on this one.

    Thanks!

    • Hi Ken, I’ve thought about it – I wonder if a more detailed PDF report would be more appropriate if that were the case as it would be hard to show the info concisely

46. Great script/information…if I just wanted Database Availability Group Members and not the other parts how would i do that?

    • Hi David, it is spit into commented sections at the end that generate HTML in functions (IE a named command that makes each table of data), so you should be able to delete the bits you want easily.

47. I ran this manually and get the HTML file in the specified folder, but the email fails with this PS error message:

    Send-MailMessage : Service not available, closing transmission channel. The server response was: 4.3.2 Service not
    available

48. This script don’t provide info about exchange SP3 UR10 , Do we need to change/modify anything , Please Suggest ..

    • Do you have a solution for this problem?

    • If you’re talking about seeing something like “Exchange 2010 SP3 UR8 v2” even though UR10 is installed, it’s a bug in the code with the way strings are evaluated. The following line fails because the string “10” is not greater than or equal to “8” even though the int values are:

      if ($tRU -ge $RollupLevel) { $RollupLevel=$tRU; $RollupVersion=$tRUV }

      change the line to:

      if ([int]$tRU -ge [int]$RollupLevel) { $RollupLevel=$tRU; $RollupVersion=$tRUV }

      • That’s right. Its on my list to fix.. I keep making updates in the field and forgetting to update the master copy…!

49. Same here, Exchange 2013 CU and Exchange 2010 SP3, doesnt display the 2013 info, gives databases and everything else but not the version of exchange 2013.

    • Yeo sorry haven’t had a chance just yet this week. I’ll update it ASAP

      • Hey Steve, Do you know when you will be able to update the report? CU8 for Exchange 2013 not showing anything, version is blank, roles are fine but mailbox count 0?
        thanks, Ed

        • Hiya, I’ll be updating for this soon – in the next week

    • just search and add whats missing i the script.
      $ExSPLevelStrings = @{“0” = “RTM”
      “1” = “SP1”
      “2” = “SP2”
      “3” = “SP3”
      “4” = “SP4”
      “CU1” = “CU1”
      “CU2” = “CU2”
      “CU3” = “CU3”
      “CU4” = “CU4”
      “CU5” = “CU5”
      “CU6” = “CU6”
      “CU7” = “CU7”
      “CU8” = “CU8”
      “CU9” = “CU9”
      “SP1” = “SP1”
      “SP2” = “SP2”}

    • Yep I’ll be updating and releasing a new version ASAP

50. exchange 2010 SP3 RU4

    runs fine from powershell but when i manually run it from Task scheduler nothing happens. no errors from task

    • I usually run the script via a batch / cmd script rather than direct as a task.

    • I’ve got this script working via a schedule task by using Steve’s command to create the initial scheduled task. Then went in to edit as follows:
      1. In the Program/script field: C:\Windows\System32\WindowsPowerShell\v1.0\powershell.exe
      2. In the Add arguments field: -command “. ‘C:\Program Files\Microsoft\Exchange Server\V15\bin\RemoteExchange.ps1’; Connect-ExchangeServer -auto; pushd C:\report; C:\report\Get-ExchangeEnvironmentReport.ps1 -HTMLReport C:\report\report.html -SendMail:$true -MailFrom:emailaddress -MailTo:emailaddress -MailServer:servername”

      Make the appropriate changes to add your email address and servername, and the location of the actual ExchangeEnvironmentReport.ps1 file.

    • I have a Task Scheduler that runs with the following:
      Security options: specify an account with permissions to run the scripts successfully, “run whether the user is logged on or not”
      Action: start a program
      Program/script: powershell
      Arguments: “-executionpolicy bypass -file c:\get-exchangeenvironmentreport.ps1 -HTMLReport c:\exchangeenvironmentreport.html” (no quotes)

      If you’ve configured the following policy, you will need to relax the setting:
      “Network access: Do not allow storage of passwords and credentials for network authentication”
      https://technet.microsoft.com/en-us/library/jj852185%28v=ws.10%29.aspx

      • I’m running Windows 2012 R2 and used your example to create a task scheduler and nothing happens

Comments are closed.