I need an Excel report of the Group Policies I am working with and am running the following PowerShell command on a Windows Server 2012 R2 and a Windows Server 2008 R2:
Get-GPOReport –Name “PolicyName” –ReportType Html – Path “C:\PS\Reports\PolicyName.html”
When I open the attached 2008 result with Excel, I see the policies, albeit a bit hard to look at, and the applied settings.
When I open the attached 2012 result, I don’t see the settings at all – just this:
"; htmlText = htmlText + "
"; htmlText = htmlText + "
"; htmlText = htmlText + "
"; htmlText = htmlText + "
"; htmlText = htmlText + "
"; htmlText = htmlText + "
I can see the full html file for both when opening with a browser without an issue.
The reason I am trying to use the 2012 one is because the results were incomplete for one of the reports and for whatever reason did not capture all of the settings.
I guess my questions are:
1. Why the difference between results?
2. How can I get all the settings using the 2008 server?
