Browse By Tags

  • Building Folder FullPaths

    Does anyone have a quick way of building folder fullpath values for many folders? I have created a sql query that will do it very fast, however, using Select-PWSQL will not return the fullpath.

  • Multi-threading or Using Jobs

    Hello All, I have a script which loops through multiple datasources to gather data for each, populate a datatable and export to an Excel file. Simple enough. My question is, has anyone tried to using either some type of multi-threading or jobs, to…

  • Synchronize AD and IMS accounts

    Does anyone have a PowerShell script that can be shared that will synchronize AD and IMS accounts? I am looking to automatically create the IMS accounts for new AD accounts. Thank you!

  • Create userlist from template

    Hi, Is there a way to create a userlist from another one? Let's say i have a userlist name prov_serv, i want to create an other who is identical to prov_serv but with a different name in powershell. Is it possible?

  • Get-PWConnectionClientToken failing

    some time yesterday morning, and continuing on into today, calls to Get-PWConnectionClientToken are now returning and empty string and emits three warnings: WARNING: Can't read token WARNING: Value cannot be null. Parameter name: s This is occurring…

  • Update-PWDocumentFileFromProjectWise not copying file

    I tried this line with the aim of writing the metadata contained in PWDocument into the file line.Seed_File by copying the file and uploading onto ProjectWise. However the resulting file on ProjectWise is empty; the metadata attributes are there but…

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

  • Deliverables Management Connector Installation for Powershell Failed

    Hi All, ProjectWise_Explorer_CONNECT_Edition_20230125181625.log After experiencing issues with building PWConnectedProjects using PowerShell we received this error. We have attempted to modify our ProjectWise Explorer installation to include the ProjectWise…

  • 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.
Communities
Support and Services
Training and Learning
Social Media