This script documents Workspace Environment Management configuration settings into a single easy to read HTML file.
Script author: James Kindon @james_kindon
Contributions made by: George Spiers @JGSpiers
Tested working on OS version: Windows Server 2016, Windows Server 2012 R2, Windows 10 (although not officially supported).
Tested working on SQL version: SQL Server 2016, SQL Server 2014.
Tested working on WEM version: WEM 4.3, WEM 4.2.
Description: This script collects all the configured settings within Workspace Environment Management and formats them in to a easy to read HTML file.
Note: This script does not perform any writes to the WEM database.
Instructions: To avoid failure, run PowerShell as an administrator. The user account you use (SQL or Windows Authentication) must be able to connect to the WEM database and Read/Query the database. This could be the SQL vuemUser account or WEM Broker account.
Requirements: This script attempts to detect and install Windows Management Framework 5.0 if SQL Management Studio and SSMO modules are not present on the machine you are running this script from. If SQL Management Studio is installed then the modules provided by SSMO are used. If not, WMF 5.0 is installed. The installation of WMF 5.0 has been successfully tested on Windows Server 2012 R2 and Windows Server 2016. Windows 10 is not supported. To install WMF 5.0 you must have a connection to the internet on the machine you are using to run this script. If you do not have a connection to the internet, download from another machine that does and install this software manually.
For more information on Workspace Environment Management see http://www.jgspiers.com/citrix-workspace-environment-manager/
Download (click below):