#PowerShell, #PowerWiseScripting, #ProjectWise, PWPS_DAB

HowTo: Get Document Count for Disabled User(s)

In this post, I will demonstrate how to generate a report listing all disabled accounts within a ProjectWise (PW) datasource and the number of documents they were the creator of. The purpose was to determine which accounts could safely be removed from the datasource without losing any data. Basically, if an account was not the… Continue reading HowTo: Get Document Count for Disabled User(s)

#PowerShell, #PowerWiseScripting, #ProjectWise, PWPS_DAB

HowTo: Get ProjectWise Folder Paths with the dsql_GetSubFolders SQL Function

In this post, I will demonstrate another method of obtaining the full path of a ProjectWise folder(s). The idea for this stemmed from a post on the Bentley Communities site where a user took advantage of the dsql_GetSubFolders SQL function provided with the ProjectWise datasource. The problem was there wasn't an easy way to obtain… Continue reading HowTo: Get ProjectWise Folder Paths with the dsql_GetSubFolders SQL Function

#PowerShell, #PowerWiseScripting, #ProjectWise, PWPS_DAB

HowTo: Use New ProjectWise Folder Object Methods

In this post, we will be looking at the three new methods added to the ProjectWise Folder object with the latest release of the PWPS_DAB module (1.24.0.0).  These methods offer a quick way to navigate to the folder within ProjectWise Explorer and to retrieve the documents contained within the folder or the folder and all… Continue reading HowTo: Use New ProjectWise Folder Object Methods

#PowerShell, #PowerWiseScripting, #ProjectWise, PWPS_DAB

HowTo: Get ProjectWise Folders By GUID Using dsqlGetSubFolders

Did you know that there is a SQL function provided with ProjectWise which will return all folders within a provided ProjectWise folder specified by the corresponding folder id. The name of the function is dsqlGetSubFolders. In this post, I will show an easy way to retrieve all ProjectWise Folder objects for a provided Work Area… Continue reading HowTo: Get ProjectWise Folders By GUID Using dsqlGetSubFolders

#PowerShell, #PowerWiseScripting, #ProjectWise, PWPS_DAB

HowTo: Get-PWParentWorkArea FUNCTION

I want to thank Robert McMillan for the inspiration for this post. He had created a process to get the Parent Rich Project of a specified folder or document. In this post, we will look at a function I've created which accepts a ProjectWise Document or ProjectWise Folder object and works its way back up… Continue reading HowTo: Get-PWParentWorkArea FUNCTION