• Performance monitor - Merge SQLite databases if running from separate regions - Just Sharing

    Chris Spencer
    Chris Spencer
    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…
    • 3 months ago
    • ProjectWise
    • ProjectWise PowerShell Extensions Forum
  • Insert a missing Work Area Property SQL Table

    Kevin
    Kevin
    Greetings, Our Microsoft SQL database, INT_SERVER, is missing a SQL Table. The Table represents a Work Area Property 'Set'. In project-wise Administrator, the Work Area Property 'Set' is named 'General Admin'. We first became aware of this via a Service…
    • over 1 year ago
    • ProjectWise
    • ProjectWise PowerShell Extensions Forum
  • When I try to run Select-PWSQL it is returning Warning: No Colums in table

    Byron Hickey
    Byron Hickey
    I have tried to use Select-PWSQL and Select-PWSQLDataTable to try and return any data from the database. I have tried the select statement using just the table name, schema.tablename and dbname.schema.tablename. I have used double quotes and single quotes…
    • Answered
    • over 2 years ago
    • ProjectWise
    • ProjectWise PowerShell Extensions Forum
  • Exporting Multiple Document Properties [Not Using Import/Export to Excel Tool]

    Jamie Stevens
    Jamie Stevens
    Question related to exporting document property data from our Datasource (not the actual files). Looking to extract document properties for about ~12,500 files, for use on another task. The amount of documents will continue to grow as the Project develops…
    • Answered
    • over 2 years ago
    • ProjectWise
    • ProjectWise PowerShell Extensions Forum
  • Using "Select-PWSQL" cmdlet, which table can I find the document "FullPath"?

    Edward Ashbolt
    Edward Ashbolt
    As per title I want to return the full path of all documents on the server. I found that the "dms_doc" table has everything I need for a specific task except the full path for each document. Any ideas which table I can look at that will contain the fully…
    • Answered
    • over 2 years ago
    • ProjectWise
    • ProjectWise PowerShell Extensions Forum
  • Active Project Participants filtered by active Project number

    Mahesh Patel
    Mahesh Patel
    Has anyone been able to use active project participants as an attribute in a PW Environment? What we are trying to do is get a list of the active project participants, which are prefixed with the active project number and then pass that as an attribute…
    • Answered
    • over 4 years ago
    • ProjectWise
    • ProjectWise PowerShell Extensions Forum
  • View related content throughout ProjectWise
  • More
  • Cancel