• Get a list of connected users

    Brian Flaherty
    Brian Flaherty
    Hey all. I have created a new blog post to offer a quick way of getting a list of all connected users within a ProjectWise datasource. Check it out. Let me know if you find it helpful. https://powerwisescripting.blog/2022/08/19/howto-get-list-of-connected…
    • over 1 year ago
    • ProjectWise
    • ProjectWise PowerShell Extensions Forum
  • Export-PWProjectAccessControl not outputting permissions correctly.

    dkleinot
    dkleinot
    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…
    • over 1 year ago
    • ProjectWise
    • ProjectWise PowerShell Extensions Forum
  • switching refrences to there active versios

    Niels Wehr
    Niels Wehr
    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…
    • Answered
    • over 1 year ago
    • ProjectWise
    • ProjectWise PowerShell Extensions Forum
  • Anyone know what the problem is with calling recursive common table expressions from the PowerShell Select-PWSQL Cmdlet?

    Adrian Abshere
    Adrian Abshere
    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…
    • Answered
    • over 1 year ago
    • ProjectWise
    • ProjectWise PowerShell Extensions Forum
  • User rights for accessing Project Wise from PowerShell cmdlets

    Peter Engelund
    Peter Engelund
    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…
    • over 1 year ago
    • ProjectWise Programming
    • ProjectWise Programming Forum
  • Update-PWWordDocumentFields

    Paul Duffy
    Paul Duffy
    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…
    • over 1 year ago
    • ProjectWise
    • ProjectWise PowerShell Extensions Forum
  • Get-PWWebconnection

    Ananthakumar Mani
    Ananthakumar Mani
    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…
    • Answered
    • over 1 year ago
    • ProjectWise
    • ProjectWise PowerShell Extensions Forum
  • Help creating "24hr Changes" export script for a Work Area folder

    roll_n_a_bentley
    roll_n_a_bentley
    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…
    • over 1 year ago
    • ProjectWise
    • ProjectWise PowerShell Extensions Forum
  • Get-PWPerformanceReportData leaving folders in datasources

    Kirk Peterson
    Kirk Peterson
    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…
    • over 1 year ago
    • ProjectWise
    • ProjectWise PowerShell Extensions Forum
  • Select-PWSQL (and DataTable variations) - Limitations on DataTables

    Paul Duffy
    Paul Duffy
    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…
    • over 1 year ago
    • ProjectWise
    • ProjectWise PowerShell Extensions Forum
  • Set-PWConnectedProjectAssociation

    Ananthakumar Mani
    Ananthakumar Mani
    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…
    • over 1 year ago
    • ProjectWise
    • ProjectWise PowerShell Extensions Forum
  • How To: Generate a Managed Workspace Report

    Brian Flaherty
    Brian Flaherty
    I have added a new post to my blog. Hopefully, you find this useful. powerwisescripting.blog/.../
    • over 1 year ago
    • ProjectWise
    • ProjectWise PowerShell Extensions Forum
  • Is there a PowerShell for PSET to rendition convertor?

    Leah Mize
    Leah Mize
    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.
    • over 1 year ago
    • ProjectWise
    • ProjectWise PowerShell Extensions Forum
  • Get-PWAllOwnedConnectedProjectIds returns only manually created project with deliverable management

    Ludovick
    Ludovick
    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…
    • over 1 year ago
    • ProjectWise
    • ProjectWise PowerShell Extensions Forum
  • How To: Get Documents Not Checked In

    Brian Flaherty
    Brian Flaherty
    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/
    • over 1 year ago
    • ProjectWise
    • ProjectWise PowerShell Extensions Forum
  • Validate the Project Creation in Connected Portal

    Ananthakumar Mani
    Ananthakumar Mani
    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…
    • over 2 years ago
    • ProjectWise
    • ProjectWise PowerShell Extensions Forum
  • any way to get datasource description?

    Kirk Peterson
    Kirk Peterson
    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
    • over 2 years ago
    • ProjectWise
    • ProjectWise PowerShell Extensions Forum
  • PW WEB Connections link

    Ananthakumar Mani
    Ananthakumar Mani
    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…
    • Answered
    • over 2 years ago
    • ProjectWise
    • ProjectWise PowerShell Extensions Forum
  • Getting PW Web/Teams Link Cmdlet

    Ananthakumar Mani
    Ananthakumar Mani
    Do we have any "Cmdlet" to getting the link of PW WEB/TEAMS ? or any other methods ?
    • Answered
    • over 2 years ago
    • ProjectWise
    • ProjectWise PowerShell Extensions Forum
  • Set-PWDocumentState failing

    Ananthakumar Mani
    Ananthakumar Mani
    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…
    • over 2 years ago
    • ProjectWise
    • ProjectWise PowerShell Extensions Forum
  • Generate Environment Usage Report

    Brian Flaherty
    Brian Flaherty
    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/
    • over 2 years ago
    • ProjectWise
    • ProjectWise PowerShell Extensions Forum
  • HowTo: Create a SQL Tester w/ GUI

    Brian Flaherty
    Brian Flaherty
    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/
    • over 2 years ago
    • ProjectWise
    • ProjectWise PowerShell Extensions Forum
  • Name of the below Attribute ? to update Work area Name

    Ananthakumar Mani
    Ananthakumar Mani
    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…
    • over 2 years ago
    • ProjectWise
    • ProjectWise PowerShell Extensions Forum
  • Generate a UserList and Group Usage Report

    Brian Flaherty
    Brian Flaherty
    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/
    • over 2 years ago
    • ProjectWise
    • ProjectWise PowerShell Extensions Forum
  • Generate an Application Usage Report

    Brian Flaherty
    Brian Flaherty
    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/
    • over 2 years ago
    • ProjectWise
    • ProjectWise PowerShell Extensions Forum
<>