• Set-PWWorkAreaConnectionUserSync

    Hi all. I've been off PW for 6 months now coming back I find there seems to be a problem with Set-PWWorkAreaConnectionUserSync Now in running the commandlet I get the following error: PS C:\windows\system32> Set-PWWorkAreaConnectionUserSync -OIDCToken…
  • Need to get list of folder paths of Folders with the word Voided in its name to a spreadsheet so I can later rename

    Need to get list of folder paths of Folders with the word Voided in its name to a spreadsheet so I can later rename. $SPSdrawVoidedFolders = get-pwfolders -folderpath "SUBTRAN\SUB\Drawings" -PopulatePaths | where-object -Property "Name" -Like -Value…
  • CmdLet for getting the WSG URL

    Is there a cmdlet or a specific way to get the WSG URL based on the datasource that we are running ?
  • Performance monitor - Merge SQLite databases if running from separate regions - Just Sharing

    Maybe someone has a PowerShell script to do the same thing or a neater way? (Merging multiple sqlite databases to one - Machines were from different regions with no access to a central db) For this I required sqlite3.exe from the sqlite tools bundle and…
  • Connection Client Could not be Accessed - unnown error accured

    Below error are getting when we trying to login PW via powershell, So, for a test i tried to put a command "New-PWLogin" simply, then the below error is getting. Usually we receive the above error while accessing via ProjectWise Explorer. But…
  • Which cmdlet can get the Last Login Computer Name ?

    I am looking in to the data which computer the user used to login the last time. Would be great If some one reffer a commandlet or a PW db table where i can get this data.
  • I am trying to update the folder security for security type Folder rather than Workflow. I've experimented with the following: New-PWLogin -DatasourceName *Project* -BentleyIMS $FolderPaths = Get-PWFolders -FolderPath "path" -Slow Updat

  • Update all Folders to Read Only with current UAC Membership

    Is there a simple way to change all the current Users / Lists / Groups within the UAC of a folder (or set of folders) to Read Only / File Read? We need this for our Archives. I already have a PowerShell script that will move the folders into the Archive…
  • Update User IdentityProvider in PowerShell

    How can I update user's Identify provider column using PowerShell?
  • Report Saved Search to excel, with custom attributes

    I would like to write a report to excel based on a saved search. I also need to write a custom attribute 'Revision No' to excel. In the if block the custom attribute is written to the terminal but it doesn't write to Excel. $SavedSearch = 'PW…
  • Get-PWUserByLastLogin

    Get-PWUserByLastLogin is returning a significant number of users (with the command Get-PWUserByLastLogin -DaysAgo 60) where the user LastLogin day is 1/1/1979 (the equivalent of a zero maybe?). Looking at the audit history of some of these turns up…
  • HowTo: FUNCTION Show-OpenFileDialog

    I have a new blog post containing a simple function to select a local file using the Windows Open File Dialog. Please check it out. Hopefully you find it useful. https://powerwisescripting.blog/2023/03/28/howto-function-show-openfiledialog/
  • How to filter Get-PWFolderSecurity based on type 'User'

    I am trying to get all User type access control list using Get-PWFolderSecurity. But unfortunately it is taking more time to get the results and I did not find a way to filter only ' User' type results. Is there any way to filter out the results so that…
  • Folder not found during Set-PWEnvironmentByFolderPath

    Hello, I am trying to set the environment of a folder and all its subfolders. It's able to find all folders and their ID with line 7 (of the image below), but when I try to set the environment it returns the warnings "Folder 'XXXX' not found". The environment…
  • ThreadOption Cannot be found

    Intension : We are running a script via Powershell ISE, this script used to call another script and will running continuesly 24/7. The problem is it get struck between some point. and we need to re-start it manually. For that we put the below script to…
  • FUNCTION to get PW Administrator(s)

    I have a new blog post containing a simple function to retrieve the members of the primary administrators group. Please check it out. Hopefully you find it useful. http://powerwisescripting.blog/2022/11/25/howto-function-to-retrieve-adminstrators-in…
  • Get-PWUserByLastLogin returning last login date 1-1-1979

    Get-PWUserByLastLogin returning last login date 1-1-1979 $users = Get-PWUserByLastLogin -Verbose
  • How to get immediate child folders in a folder

    How to get only immediate child folders in a folder in powershell.
  • Customize document version created on the first state

    Hello, is it possible to customize by PowerShell Script, the document version, once it is added to the ProjectWise Datasource? Basically, it is possible to customize the Document versions, by using WRE. But when we are adding a new Document to ProjectWise…
  • How to avoid empty folders while querying Get-PWFolders

    I was trying to get the list of folders in a folder. But I can see a large number of empty folders in the result. Is there any way to exclude empty folders while querying folder list using Get-PWFolders? $UndergroundStorageFolders= Get-PWFolders …
  • Comparing CustomAttributes sub-proprerties from Get-PWDocumentsBySearchExtended

    I'm having issues trying to compare the FileUpdateDate to an DateTime environment attribute returned by Get-PWDocumentsBySearchExtended in Where-Object. It doesn't appear to be able to expand the CustomAttributes sub-property for comparison? $PWDocs…
  • Get a list of connected users

    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…
  • 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…