Queries

This topic applies to systems using an Asset Manager or Universal license only.

All Audits

Purpose:

Lists all audits

Prompts:

None

Fields displayed:

Title, Extended ID, Status, Created By, Creation Date

Criteria:

None

The All Audits query includes the Reference Number attribute as a hidden column in addition to the Extended ID attribute (which uses the column heading of Reference). This hidden attribute is used for sorting. For more information about extended IDs, see the Designer Guide.

Audit - Assignments

Purpose:

Lists all audit assignments

Prompts:

None

Fields displayed:

Process Assignment, Status, User, Group, Role

Criteria:

None

Audit - Attachments

Purpose:

Lists all audit attachments

Prompts:

None

Fields displayed:

Title, Created By, Creation Date

Criteria:

None

Audit - Cancellations

Purpose:

Lists all audit cancellations

Prompts:

None

Fields displayed:

Title, Created By, Creation Date

Criteria:

None

Audit - Escalation Points

Purpose:

Lists all audit escalation points

Prompts:

None

Fields displayed:

Title, Creation Date, Expiry Date Time, Is Breach

Criteria:

None

Audit - Notes

Purpose:

Lists all audit notes

Prompts:

None

Fields displayed:

Serial Number, Title, Text, Created By, Creation Date

Criteria:

None

Audit - Reminders

Purpose:

Lists all audit reminders

Prompts:

None

Fields displayed:

Subject, Send Date

Criteria:

None

Audit - Software Products

Purpose:

Lists all audits of software products

Prompts:

None

Fields displayed:

Software Product title

Criteria:

None

Audit - Tasks

Purpose:

Lists all audit tasks

Prompts:

None

Fields displayed:

Serial Number, Title, Lifecycle, Status

Criteria:

None

Audit - Task Assignments

Purpose:

Lists all audit task assignments

Prompts:

None

Fields displayed:

Title, Created By, User, Group, Creation Date

Criteria:

None

Audit - Task Completions

Purpose:

Lists all audit task completions

Prompts:

None

Fields displayed:

Title, Created By, Creation Date

Criteria:

None

Audit - Task Notes

Purpose:

Lists all audit task notes

Prompts:

None

Fields displayed:

Title, Created By, Creation Date

Criteria:

None

Audit - Task Reminders

Purpose:

Lists all audit task reminders

Prompts:

None

Fields displayed:

Subject, Send Date

Criteria:

None

Audit - Task Restarts

Purpose:

Lists all audit task restarts

Prompts:

None

Fields displayed:

Title, Created By, Creation Date

Criteria:

None


Was this article useful?    

The topic was:

Inaccurate

Incomplete

Not what I expected

Other