• 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…
  • 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…