Queries

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

Asset Activities

Purpose:

Lists all asset activities

Prompts:

None

Fields displayed:

Lifecycle, Extended ID, Title, Status, Configuration Item

Criteria:

None

The Asset Activities 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.

Asset - Quotes

Purpose:

Lists all asset quotes

Prompts:

None

Fields displayed:

Title, Quote Amount, Quote Obtained, Creation Date

Criteria:

None

Asset - Assignments

Purpose:

Lists all asset assignments

Prompts:

None

Fields displayed:

Process Assignment, Status, User, Group, Role

Criteria:

None

Asset - Attachments

Purpose:

Lists all asset attachments

Prompts:

None

Fields displayed:

Title, Created By, Creation Date

Criteria:

None

Asset - Cancellations

Purpose:

Lists all asset cancellations

Prompts:

None

Fields displayed:

Title, Created By, Creation Date

Criteria:

None

Asset - Disposal Complete

Purpose:

Lists all assets that have been disposed

Prompts:

None

Fields displayed:

Title, Created By, Creation Date

Criteria:

None

Asset - Escalation Points

Purpose:

Lists all asset escalation points

Prompts:

None

Fields displayed:

Title, Creation Date, Expiry Date Time, Is Breach

Criteria:

None

Asset - Notes

Purpose:

Lists all asset notes

Prompts:

None

Fields displayed:

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

Criteria:

None

Asset - Raised Purchase Order

Purpose:

Lists all asset purchase orders

Prompts:

None

Fields displayed:

Title, Purchase Order, Supplier, Created By, Creation Date

Criteria:

None

Asset - Reject Reason

Purpose:

Lists all asset rejection reasons

Prompts:

None

Fields displayed:

Title, Created By, Creation Date

Criteria:

None

Asset - Reminders

Purpose:

Lists all asset reminders

Prompts:

None

Fields displayed:

Subject, Send Date

Criteria:

None

Asset - Tasks

Purpose:

Lists all asset tasks

Prompts:

None

Fields displayed:

Serial Number, Title, Lifecycle, Status

Criteria:

None

Asset- Task Assignments

Purpose:

Lists all asset task assignments

Prompts:

None

Fields displayed:

Title, Created By, User, Group, Creation Date

Criteria:

None

Asset - Task Completions

Purpose:

Lists all asset task completions

Prompts:

None

Fields displayed:

Title, Created By, Creation Date

Criteria:

None

Asset - Task Notes

Purpose:

Lists all asset task notes

Prompts:

None

Fields displayed:

Title, Created By, Creation Date

Criteria:

None

Asset - Task Reminders

Purpose:

Lists all asset task reminders

Prompts:

None

Fields displayed:

Subject, Send Date

Criteria:

None

Asset - Task Restarts

Purpose:

Lists all asset 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