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 Extended IDs.

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