• Replies 51 replies
  • Subscribers 76 subscribers
  • Views 10997 views
  • Users 0 members are here

ProjectWise Performance Report

Marty.Nickel
Offline

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

Parents

  • Hi Marty,

    Great presentation today.  Downloaded the 7z file and followed the instructions and I was able to create a batch file that executes the PS script.  it uses a logical account that was created for this purpose.  If I run that batch file in a windows session, it records the data.  I set up an event in Task Scheduler to run the batch file once per hour.  The Task Scheduler history shows the event running every hour and it appears to be successful.  It returns operation code 2.  From a google search, that op code seems to mean file not found.  I'm not sure how this is possible because I can run the batch file by typing the full path to the batch file into the windows start menu. The only suggestion I have seen is to make sure the path to the batch file is set in the "Start in" field of the task scheduler action, which I have done.  

    I have another other ProjectWise-related task running on the same machine and that event works fine.  This task was set up using the same windows username, so it shouldn't be a permissions issue.  All of this leads me to believe that the problem is related to something that this powershell script is doing, that my environment doesn't like when there is no user logged in to windows.  

    Any idea what I might be missing, or what else I might try?

Reply

  • Hi Marty,

    Great presentation today.  Downloaded the 7z file and followed the instructions and I was able to create a batch file that executes the PS script.  it uses a logical account that was created for this purpose.  If I run that batch file in a windows session, it records the data.  I set up an event in Task Scheduler to run the batch file once per hour.  The Task Scheduler history shows the event running every hour and it appears to be successful.  It returns operation code 2.  From a google search, that op code seems to mean file not found.  I'm not sure how this is possible because I can run the batch file by typing the full path to the batch file into the windows start menu. The only suggestion I have seen is to make sure the path to the batch file is set in the "Start in" field of the task scheduler action, which I have done.  

    I have another other ProjectWise-related task running on the same machine and that event works fine.  This task was set up using the same windows username, so it shouldn't be a permissions issue.  All of this leads me to believe that the problem is related to something that this powershell script is doing, that my environment doesn't like when there is no user logged in to windows.  

    Any idea what I might be missing, or what else I might try?

Children

Communities
Support and Services
Training and Learning
Social Media