ProjectWise Performance Report

Hello everyone,

For those of you at the conference, this was the dashboard I showed in my presentation and for those not at the conference, this is a dashboard on performance monitoring inside of ProjectWise using PowerShell.  Please find the attached documents to getting started with setting up performance monitoring on your system.  There is a PowerShell script that needs to be run on some kind of scheduled task at the various locations you want to test, the template for the PowerBi report and a setup document to help you link the results from your script with PowerBi.  For any questions or discussion please post to this thread.  Enjoy!



UPDATE March 16, 2020

Change log
- Now supports WSG metrics, activated with the -IncludeWSGData switch (requires PWPS_WSG to be installed if activated)
- Added more verbose logging
- Added Environment table and WSG table to output
- Updated the call to get currently connected users (should perform better)
- Now only clears files created by the script from the working directory (was previously clearing everything)
- If you do not want WSG data returned you do not need to activate the switch, or change your current script in any way.
- If you do with to collect WSG data please remember to install PWPS_WSG the same way you install PWPS_DAB
- A new datatable is returned for Environment data, which will be added to the output dataset
- No breaking changes have been made.

Parents Reply
  • Hey everyone, if you're writing to SQL or want a datatable as the output, use the -OutputType "DataTable" switch in the Get-PWPerformanceReportData cmdlet. Example below.

    $PWPerformanceReportVariables = @{
        Connection = "Home Wifi";
        Location = "Melbourne, Victoria";
        ConnectingViaCache = "False"
        Datasource = ""
        ProjectWiseUserName = "PWReportUser"
        ProjectWisePassword = (ConvertTo-SecureString -String PWPassword -AsPlainText -Force);
        OutputType = "DataTable";
    $PerformanceData = Get-PWPerformanceReportData @PWPerformanceReportVariables -Verbose

No Data