• Export-PWProjectAccessControl not outputting permissions correctly.

    Security Protocol now set to TLS 1.2 PWPS_DAB Version is 2.1.10.0 This is a 64-bit process. All, I ran into an issue with the Export-PWProjectAccessControl cmdlet where it is reporting different permissions then ProjectWise Explorer is: VERBOSE…
  • switching refrences to there active versios

    Hello, is there a way to switch the references of an ProjectWise document to there active versions in the PWPS_DAB? I tryed to build an work arround but there is only an Add-PWDocumentReference which allows me to add aditionally references but i cant…
  • Anyone know what the problem is with calling recursive common table expressions from the PowerShell Select-PWSQL Cmdlet?

    simple common table expressions seem to work: e.g. ;with cte as ( Select proj.o_projectno ,proj.o_parentno ,proj.o_projectname From dms_proj proj where proj.o_parentno > 0 and o_instanceID <> 0 ) select * from cte However, adding the…
  • Update-PWWordDocumentFields

    Just wanted to ask the team, the cmdlet for Update-PWWordDocumentFields, as far as I understand, was set up as a workaround for a specific issue with Title block updates. How easy would it be to adapt this for Excel. And also, is there a way within PowerShell…
  • Get-PWWebconnection

    Hey guys, When I run the below code to get the PW Web connection name it is replicate 2 nameslike below, UNIQUEID - PROJECT NAME UNIQUEID - PROJECT NAME Anybody noticed this ? Why it is showing 2 times ? $EncodedToken = ConvertTo-EncodedToken…
  • Help creating "24hr Changes" export script for a Work Area folder

    I'm trying to create a script that will search for any changes to files/folders made to a " Work Area " folder within a 24 hour period and export out a copy to a local folder for those changed items. This script will be executed once a day via Task Scheduler…
  • Get-PWPerformanceReportData leaving folders in datasources

    I have a script running on multiple caching servers to maintain a PowerBI page to assess PW performance, but the script now seems to be leaving hundreds of these sorts of folders in my datasources: Is there a way to ensure it doesn't do this? Kirk…
  • Select-PWSQL (and DataTable variations) - Limitations on DataTables

    I have used these commands on several scripts but have started running into issues on custom environment tables we have. The select statement is simply "SELECT * FROM env_1192", but this is returning "No columns in table" in PowerShell. I have double…
  • Set-PWConnectedProjectAssociation

    I created a rich/connected project manually. And i want to associate it both. Using the below code is saying error and even I could not get the connected project guid. The connected projectid is showing like "00000000-0000-0000-0000-000000000000" Could…
  • How To: Generate a Managed Workspace Report

    I have added a new post to my blog. Hopefully, you find this useful. powerwisescripting.blog/.../
  • Is there a PowerShell for PSET to rendition convertor?

    This seems like a general want for the Bentley users as they use Psets and Renditions are more limited. or a pset to PW file 'Set' convertor would help too.
  • Get-PWAllOwnedConnectedProjectIds returns only manually created project with deliverable management

    Hello ( Projectwise North Europe Datacenter, On premise Projectwise Datasources Pjw connect Server 3.299) I created some connected projects with PowerShell script, all is ok and works well, i can see them on the web console, i have Projectwise…
  • How To: Get Documents Not Checked In

    Hello All, I have new post demonstrating an alternative method for obtaining an array of documents which are not checked in. Hope you find this useful. http://powerwisescripting.blog/2021/10/19/howto-get-documents-not-checked-in/
  • Validate the Project Creation in Connected Portal

    Dear all, I am working in the Powershell script which is needs to be validate the projects in all places, Means that, 1. ProjectWise Explorer - Workarea and Assosciation {I know i can do that} 2. ProjectWise Web (Connect.bentley.com) {Need a suggesion…
  • any way to get datasource description?

    hello - I have a number of datasources where the datasource name and description (user friendly name), are different. Are there any commandlet's that would get me the description? thanks! Kirk Peterson
  • PW WEB Connections link

    Dear Team, I am trying to get the PW WEB link for my project to automate something. I have posted many posts here to get help but there is no good help. Finally I planned to get it via different way like the below. But I need to know how/where to…
  • Getting PW Web/Teams Link Cmdlet

    Do we have any "Cmdlet" to getting the link of PW WEB/TEAMS ? or any other methods ?
  • Set-PWDocumentState failing

    I am trying to change the state of a file with using the below code, but i am getting an error message like below. If someone could correct me where i am wrong would be very much appreciated Error Message : VERBOSE: Found 1 documents WARNING: Failed…
  • Generate Environment Usage Report

    I have added a new post showing how to generate an Environment Usage report. Hopefully you find it useful. https://powerwisescripting.blog/2021/07/30/howto-generate-environment-usage-report/
  • HowTo: Create a SQL Tester w/ GUI

    I have added a new post showing how to create and use a GUI to develop and test SQL Select statements. https://powerwisescripting.blog/2021/07/28/howto-create-a-sql-tester-w-gui/
  • Name of the below Attribute ? to update Work area Name

    I am using the below code to update the connected work area name but i am struck here that, when i put @{PROJECT_Project_Name="NewProjectName"} this will be updating the properties not the name of the project. The rectangle marked one in that image that…
  • Generate a UserList and Group Usage Report

    I have added a new post outlining the steps to generating a UserList and Group Usage report. Hopefully you find this useful. http://powerwisescripting.blog/2021/07/27/howto-generate-userlist-and-group-usage-report/
  • Generate an Application Usage Report

    I have added a new post outlining the steps to generating an Application Usage report. Hopefully you find this useful. https://powerwisescripting.blog/2021/07/24/howto-generate-application-usage-report/
  • Create a File Type Associations Report

    The following link is a post outlining the steps to generating a report listing the File Type Associations for the three document processors. http://powerwisescripting.blog/2021/07/21/howto-create-file-type-association-report/
  • Issues with Import-PWDocuments

    I'm running into issues with Import-PWDocuments. We've been using it for some time now to mirror a server location into ProjectWise to provide select external access to a large set of information. The dataset is roughly 200K files, 50K folders, and the…