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
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
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
Have you ever looked at the number of applications available within a ProjectWise datasource? In the datasource used for this post, there are 199 defined applications. Of those, how many are actually being used? In this post, we will be generating a report to answer that question. The report will list each application and the… Continue reading HowTo: Generate Application Usage Report
I recently had a request to compile a report listing all of the File Type Associations associated with each of the three document processors (Full Text Indexing, Thumbnail Extraction, and File Property Extraction) for multiple ProjectWise (PW) datasources. This report will help to standardize the File Type Associations across the multiple PW datasources. In this… Continue reading HowTo: Create File Type Association Report
