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!

Thanks,

Marty

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)

Notes

- 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.

ProjectWise_Performance_Report_1.0.7z ProjectWise_Performance_Report_Example_2.0.zip ProjectWise_Performance_Dashboard_1.0.zip

Top Replies

Parents

Offline Marty.Nickel Tue, Jun 25 2019 2:42 PM
Cancel
Vote Up 0 Vote Down

Sign in to reply

Cancel

Reply

Offline Marty.Nickel Tue, Jun 25 2019 2:42 PM
Cancel
Vote Up 0 Vote Down

Sign in to reply

Cancel

Children

Offline Zachary Kerr Wed, Jun 26 2019 8:22 AM in reply to Marty.Nickel

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 = "decide-pwce-aus.bentley.com:decide-pwce-aus-010"
    ProjectWiseUserName = "PWReportUser"
    ProjectWisePassword = (ConvertTo-SecureString -String PWPassword -AsPlainText -Force);
    OutputType = "DataTable";
}

$PerformanceData = Get-PWPerformanceReportData @PWPerformanceReportVariables -Verbose