Administrator-level requests ( required parameters are in blue):

- A query that checks whether a maintenance task needs to be run to "reorganize" or "rebuild" the indexes in order to improve performance.

- A query that displays variable mappings.

- Query to retrieve Core Operations with details for a specific user and a particular date. this request requires a lot of system resources. you should try to limit the range particular date.

- A query that retrieves all files extracted on a specific computer.

- Query to list the restored files.

- Query to list duplicate files with details. (The search can be based on the document name or a variable value.)

For this query, you can filter the results by file extension. The wildcard character * can be used, for example, to filter for SOLIDWORKS files (e.g., sld*). To specify multiple extensions, simply separate them with a semicolon (;).

When searching for a variable value, it is possible to ignore duplicates when the search involves the part and its drawing.

- A query that lists the deleted files in a specific folder,along with details.

- A query that shows where a variable is used throughout the vault.

- A query that lists the revision history for a specific folder.

- A query that lists documents in a specific state for a specific folder and time period.

    This query has 3 filter options:

      • None => The query lists all documents that have been in the selected status
      • Keep only the most recent status change => When this option is enabled, if a document goes through a status multiple times, only the most recent status change entry will be retained
      • Consider only the previous report => When this option is enabled, the user will see a list of documents based on the previously selected report, not the report to which a document has been moved

       

- A query that allows you to view the system history.

- Queries that list users' inherited permissions or permissions inherited on folders

- A query that displays the size of a project on the disk.

- Query to list inherited and explicit group folder permissions in the vault.

- Query to list legacy and explicit user folder permissions in the vault.

- A query that returns a list of tasks for a user over a specific timeperiod.

- A query that lists documents arriving in the selected status allows you to list documents that are likely to arrive in the selected status.You must specify the document flow and status. If no folder is selected, the query is applied to the entire PDM repository.

- A query that retrieves documents with a specific variable value.

For this query, you can filter the results by file extension. The wildcard character * can be used, for example, to filter for SOLIDWORKS files (e.g., sld*). To specify multiple extensions, simply separate them with a semicolon (;).

- Query listing the plans that are not associated with a 3D document.

- A query that lists documents with references outside the vault. You can specify the file extension of the documents to be tested and/or the file extension of the references to be tested.

- Ability to create a custom query


Queries from PDMCheck:

(You can find more information and examples for these queries in the PDMCheck help section.)

- Query to retrieve documents whose bill of materials contains deleted documents

- Query to list empty folders

- The "Check Bill of Materials for Latest Version"query lists documents that are not in the latest version.List of extensions to be analyzed, separated by a semicolon;

- Query to Check Documents for Prohibited Characters List of characters to be checked, separated by a semicolon;

- A 3D document is not associated with a drawing; lists documents without drawings. The document's workflow and status must be specified.

- A 3D document is not associated with a 3D document; lists documents without a parent. The document's workflow and status must be specified.

- The bill of materials contains status inconsistencies. This option checks the bill of materials for status inconsistencies based on the selected parameters. List of extensions to be analyzed, separated by a semicolon;

The flow and status of the document must be specified for both the parent and the children

- The "Check File Names with PDM Information"query allows you to list documents based on variable concatenations


Some requests require parameters, such as the machine name, for example:


 


Or selecting a PDM folder:



For period settings, you can specify a date range:


 


Or an automatic period such as:


 


Queries that require selecting a folder will use the vault root as the starting point to avoid issues related to the locations of PDM views: