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.7zProjectWise_Performance_Report_Example_2.0.zip ProjectWise_Performance_Dashboard_1.0.zip

  • Can anyone tell me what's happening, or not happening and how to fix it?

    New-SQLTable : Cannot validate argument on parameter 'Database'. The argument is null or empty. Provide an argument that is not null or empty, and then try the command again.
    At line:14 char:62
    + ... QLTable -SQLConnection $SQLConnection -Database $DatabaseName -DataTa ...
    + ~~~~~~~~~~~~~
    + CategoryInfo : InvalidData: (:) [New-SQLTable], ParameterBindingValidationException
    + FullyQualifiedErrorId : ParameterArgumentValidationError,New-SQLTable

    BulkCopy-SQLTable : Exception calling "WriteToServer" with "1" argument(s): "Cannot access destination table 'PWPerfGeneral'."
    At line:17 char:5
    + BulkCopy-SQLTable -SQLConnection $SQLConnection -DataTable $Table
    + ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
    + CategoryInfo : NotSpecified: (:) [Write-Error], WriteErrorException
    + FullyQualifiedErrorId : Microsoft.PowerShell.Commands.WriteErrorException,BulkCopy-SQLTable

    Write-PWPSLog : Exception calling "WriteToServer" with "1" argument(s): "Cannot access destination table 'PWPerfGeneral'."
    At C:\Program Files\WindowsPowerShell\Modules\PWPS_DAB\1.12.10.0\HelperFunctions.psm1:1460 char:13
    + Write-PWPSLog -Cmdlet $Cmdlet -Message $Message -Level Er ...
    + ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
    + CategoryInfo : NotSpecified: (:) [Write-Error], WriteErrorException
    + FullyQualifiedErrorId : Microsoft.PowerShell.Commands.WriteErrorException,Write-PWPSLog

    BulkCopy-SQLTable : Error bulk copying table.
    At line:17 char:5
    + BulkCopy-SQLTable -SQLConnection $SQLConnection -DataTable $Table
    + ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
    + CategoryInfo : NotSpecified: (:) [Write-Error], WriteErrorException
    + FullyQualifiedErrorId : Microsoft.PowerShell.Commands.WriteErrorException,BulkCopy-SQLTable

    Write-PWPSLog : Error bulk copying table.
    At C:\Program Files\WindowsPowerShell\Modules\PWPS_DAB\1.12.10.0\HelperFunctions.psm1:1464 char:13
    + Write-PWPSLog -Cmdlet $Cmdlet -Message $Message -Level Er ...
    + ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
    + CategoryInfo : NotSpecified: (:) [Write-Error], WriteErrorException
    + FullyQualifiedErrorId : Microsoft.PowerShell.Commands.WriteErrorException,Write-PWPSLog

    New-SQLTable : Cannot validate argument on parameter 'Database'. The argument is null or empty. Provide an argument that is not null or empty, and then try the command again.
    At line:14 char:62
    + ... QLTable -SQLConnection $SQLConnection -Database $DatabaseName -DataTa ...
    + ~~~~~~~~~~~~~
    + CategoryInfo : InvalidData: (:) [New-SQLTable], ParameterBindingValidationException
    + FullyQualifiedErrorId : ParameterArgumentValidationError,New-SQLTable

    BulkCopy-SQLTable : Exception calling "WriteToServer" with "1" argument(s): "Cannot access destination table 'PWPerfDocument'."
    At line:17 char:5
    + BulkCopy-SQLTable -SQLConnection $SQLConnection -DataTable $Table
    + ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
    + CategoryInfo : NotSpecified: (:) [Write-Error], WriteErrorException
    + FullyQualifiedErrorId : Microsoft.PowerShell.Commands.WriteErrorException,BulkCopy-SQLTable

    Write-PWPSLog : Exception calling "WriteToServer" with "1" argument(s): "Cannot access destination table 'PWPerfDocument'."
    At C:\Program Files\WindowsPowerShell\Modules\PWPS_DAB\1.12.10.0\HelperFunctions.psm1:1460 char:13
    + Write-PWPSLog -Cmdlet $Cmdlet -Message $Message -Level Er ...
    + ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
    + CategoryInfo : NotSpecified: (:) [Write-Error], WriteErrorException
    + FullyQualifiedErrorId : Microsoft.PowerShell.Commands.WriteErrorException,Write-PWPSLog

    BulkCopy-SQLTable : Error bulk copying table.
    At line:17 char:5
    + BulkCopy-SQLTable -SQLConnection $SQLConnection -DataTable $Table
    + ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
    + CategoryInfo : NotSpecified: (:) [Write-Error], WriteErrorException
    + FullyQualifiedErrorId : Microsoft.PowerShell.Commands.WriteErrorException,BulkCopy-SQLTable

    Write-PWPSLog : Error bulk copying table.
    At C:\Program Files\WindowsPowerShell\Modules\PWPS_DAB\1.12.10.0\HelperFunctions.psm1:1464 char:13
    + Write-PWPSLog -Cmdlet $Cmdlet -Message $Message -Level Er ...
    + ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
    + CategoryInfo : NotSpecified: (:) [Write-Error], WriteErrorException
    + FullyQualifiedErrorId : Microsoft.PowerShell.Commands.WriteErrorException,Write-PWPSLog

    New-SQLTable : Cannot validate argument on parameter 'Database'. The argument is null or empty. Provide an argument that is not null or empty, and then try the command again.
    At line:14 char:62
    + ... QLTable -SQLConnection $SQLConnection -Database $DatabaseName -DataTa ...
    + ~~~~~~~~~~~~~
    + CategoryInfo : InvalidData: (:) [New-SQLTable], ParameterBindingValidationException
    + FullyQualifiedErrorId : ParameterArgumentValidationError,New-SQLTable

    BulkCopy-SQLTable : Exception calling "WriteToServer" with "1" argument(s): "Cannot access destination table 'PWPerfFolder'."
    At line:17 char:5
    + BulkCopy-SQLTable -SQLConnection $SQLConnection -DataTable $Table
    + ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
    + CategoryInfo : NotSpecified: (:) [Write-Error], WriteErrorException
    + FullyQualifiedErrorId : Microsoft.PowerShell.Commands.WriteErrorException,BulkCopy-SQLTable

    Write-PWPSLog : Exception calling "WriteToServer" with "1" argument(s): "Cannot access destination table 'PWPerfFolder'."
    At C:\Program Files\WindowsPowerShell\Modules\PWPS_DAB\1.12.10.0\HelperFunctions.psm1:1460 char:13
    + Write-PWPSLog -Cmdlet $Cmdlet -Message $Message -Level Er ...
    + ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
    + CategoryInfo : NotSpecified: (:) [Write-Error], WriteErrorException
    + FullyQualifiedErrorId : Microsoft.PowerShell.Commands.WriteErrorException,Write-PWPSLog

    BulkCopy-SQLTable : Error bulk copying table.
    At line:17 char:5
    + BulkCopy-SQLTable -SQLConnection $SQLConnection -DataTable $Table
    + ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
    + CategoryInfo : NotSpecified: (:) [Write-Error], WriteErrorException
    + FullyQualifiedErrorId : Microsoft.PowerShell.Commands.WriteErrorException,BulkCopy-SQLTable

    Write-PWPSLog : Error bulk copying table.
    At C:\Program Files\WindowsPowerShell\Modules\PWPS_DAB\1.12.10.0\HelperFunctions.psm1:1464 char:13
    + Write-PWPSLog -Cmdlet $Cmdlet -Message $Message -Level Er ...
    + ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
    + CategoryInfo : NotSpecified: (:) [Write-Error], WriteErrorException
    + FullyQualifiedErrorId : Microsoft.PowerShell.Commands.WriteErrorException,Write-PWPSLog

    New-SQLTable : Cannot validate argument on parameter 'Database'. The argument is null or empty. Provide an argument that is not null or empty, and then try the command again.
    At line:14 char:62
    + ... QLTable -SQLConnection $SQLConnection -Database $DatabaseName -DataTa ...
    + ~~~~~~~~~~~~~
    + CategoryInfo : InvalidData: (:) [New-SQLTable], ParameterBindingValidationException
    + FullyQualifiedErrorId : ParameterArgumentValidationError,New-SQLTable

    BulkCopy-SQLTable : Exception calling "WriteToServer" with "1" argument(s): "Cannot access destination table 'PWPerfUser'."
    At line:17 char:5
    + BulkCopy-SQLTable -SQLConnection $SQLConnection -DataTable $Table
    + ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
    + CategoryInfo : NotSpecified: (:) [Write-Error], WriteErrorException
    + FullyQualifiedErrorId : Microsoft.PowerShell.Commands.WriteErrorException,BulkCopy-SQLTable

    Write-PWPSLog : Exception calling "WriteToServer" with "1" argument(s): "Cannot access destination table 'PWPerfUser'."
    At C:\Program Files\WindowsPowerShell\Modules\PWPS_DAB\1.12.10.0\HelperFunctions.psm1:1460 char:13
    + Write-PWPSLog -Cmdlet $Cmdlet -Message $Message -Level Er ...
    + ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
    + CategoryInfo : NotSpecified: (:) [Write-Error], WriteErrorException
    + FullyQualifiedErrorId : Microsoft.PowerShell.Commands.WriteErrorException,Write-PWPSLog

    BulkCopy-SQLTable : Error bulk copying table.
    At line:17 char:5
    + BulkCopy-SQLTable -SQLConnection $SQLConnection -DataTable $Table
    + ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
    + CategoryInfo : NotSpecified: (:) [Write-Error], WriteErrorException
    + FullyQualifiedErrorId : Microsoft.PowerShell.Commands.WriteErrorException,BulkCopy-SQLTable

    Write-PWPSLog : Error bulk copying table.
    At C:\Program Files\WindowsPowerShell\Modules\PWPS_DAB\1.12.10.0\HelperFunctions.psm1:1464 char:13
    + Write-PWPSLog -Cmdlet $Cmdlet -Message $Message -Level Er ...
    + ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
    + CategoryInfo : NotSpecified: (:) [Write-Error], WriteErrorException
    + FullyQualifiedErrorId : Microsoft.PowerShell.Commands.WriteErrorException,Write-PWPSLog