I want to be able to locate documents without an attribute sheet. So far I have only been able to accurately do that by querying SQL. The Search seems to only search documents with attribute sheets for attribute values.
Select-PWSQL? Haven't tried it myself though, so not sure of capabilities.
oh, also you can install the SQLServer module and do tons of stuff directly on the SQL databases.
You should be able to run any Select query for the current ProjectWise datasource using the Select-PWSQL, Select-PWSQLDataTable or Select-PWSQLDataTableToSQLite cmdlets.
thank you, I did not want to formulate up connect strings for each data source.