#PowerShell, #PowerWiseScripting, #ProjectWise, PWPS_DAB

HowTo: Generate Environment Usage Report

In the past few posts, you may have noticed a theme. I am generating reports to help determine if any extraneous information exists within our datasources which can be cleaned up. I am not going to cover how to do the cleanup, but rather how to gather the information. The cleanup may come later.  So,… Continue reading HowTo: Generate Environment Usage Report

#PowerShell, #PowerWiseScripting, #ProjectWise, PWPS_DAB

HowTo: Create a SQL Tester w/ GUI

In this post I will show you how to create a GUI for testing Select SQL statements.  I have used this for developing / testing Select SQL statements to be used within Environment Attributes when I don't have SQL Management Studio available. Comes in handy. All of the ProjectWise related cmdlets are available using the… Continue reading HowTo: Create a SQL Tester w/ GUI

#PowerShell, #PowerWiseScripting, #ProjectWise, PWPS_DAB

HowTo: Generate UserList And Group Usage Report

In the past few posts, you may have noticed a theme. I am generating reports to help determine if any extraneous information exists within our datasources which can be cleaned up. I am not going to cover how to do the cleanup, but rather how to gather the information. The cleanup may come later.  So,… Continue reading HowTo: Generate UserList And Group Usage Report