Browse By Tags

  • 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…
  • User rights for accessing Project Wise from PowerShell cmdlets

    I would like to execute commands in PW via PowerShell cmdlets. Creating new folders and receiving information on files and exporting files. Right now its only possible for user with administrator rights. Is it possible to use PS with more restricted user…
  • 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…
  • HowTo: Update User's Domain

    Here's a new post demonstrating how to update the domain associated with a Windows type ProjectWise user account. Hope, you find it useful. http://powerwisescripting.blog/2021/04/22/howto-update-users-domain/ Cheers, Brian