• 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…
  • Insert a missing Work Area Property SQL Table

    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…
  • When I try to run Select-PWSQL it is returning Warning: No Colums in table

    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…
  • Exporting Multiple Document Properties [Not Using Import/Export to Excel Tool]

    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…
  • Using "Select-PWSQL" cmdlet, which table can I find the document "FullPath"?

    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…
  • Active Project Participants filtered by active Project number

    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…