Queries

Active Public Notices

Purpose:

Lists public notices that are active

Prompts:

None

Fields displayed:

Category, Title, Global Notice, Created By, Creation Date, Expiry Date, Publication Date

Criteria:

Category.Public Category is equal to (True)
AND Publication Date is older than (1 minute)
AND Expiry Date is within the next (99 years)

Active Private Notices

Purpose:

Lists private notices that are active

Prompts:

None

Fields displayed:

Category, Title, Global Notice, Created By, Creation Date, Expiry Date, Publication Date

Criteria:

Category.Public Category is equal to (False)
AND Publication Date is older than (1 minute)
AND Expiry Date is within the next (99 years)

All Noticeboard Categories

Purpose:

Lists all Noticeboard categories.

Prompts:

None

Fields displayed:

Name, Public Category

Criteria:

None

All Notices

Purpose:

Lists all Noticeboard Items.

Prompts:

None

Fields displayed:

Category, Title, Public Category, Global Notice, Publication Date, Expiry Date, Created By, Creation Date

Criteria:

None

All Processes

Purpose:

Lists all processes (for example, incidents, problems, tasks and changes)

Prompts:

None

Fields displayed:

Last Updated By, Extended ID, Title, Status, User, Lifecycle

Criteria:

None

Assignments

Purpose:

Lists all assignments

Prompts:

None

Fields displayed:

Process Assignment Number, Status, User, Group, Role

Criteria:

None

Class Type Details

Purpose:

Lists Class Types and Details

Prompts:

None

Fields displayed:

Class Type, Class Name, Is Lifecycle Class, Super Class Type, Table, Table Name, Table Schema, Client Class, Module, Module Title, Module Name, Name, Class, Defined By, Title

Criteria:

None

Class Type Summary

Purpose:

Lists Class Types Summary

Prompts:

None

Fields displayed:

Is Lifecycle Class, Table Name, Table, Defined By, Module Title, Module, Title

Criteria:

None

Customer Group

Purpose:

Lists customers

Prompts:

None

Fields displayed:

Title, Name, Type

Criteria:

None

Deleted Users

Purpose:

Lists all soft deleted users.

Prompts:

None

Fields displayed:

User Title, Current Group, Delete Datetime, Last updated by

Criteria:

Delete Datetime is not Null

Escalation Point

Purpose:

Lists all escalation points

Prompts:

None

Fields displayed:

Serial Number, Title, Expiry Date Time

Criteria:

None

My Current Activity

Purpose:

Lists all processes raised by the current user that are still open

Prompts:

None

Fields displayed:

Extended ID, Title, Creation date, Status

Criteria:

Raise User Is Current User
Status.Is Completion Is Equal To (false)
Status.Is End Is Equal To (false)

My Group's Assigned Workload

Purpose:

A list of all processes assigned to my groups

Prompts:

None

Fields displayed:

Color, Lifecycle, Extended ID, Title, Status, Raised By, Assigned Group, Assigned Analyst, Creation Date

Grouping:

Latest Assignment Group

Criteria:

Latest Assignment.Group is within my groups
AND Status.Is End is equal to (false)
AND Status.Is Completion is equal to (false)

My Support

Purpose:

A list of all incidents and requests raised by me

Prompts:

None

Fields displayed:

Lifecycle, Extended ID, Title, Status, Raised By, Creation Date

Criteria:

Raise User is current user
AND Status.Is End is equal to (false)
AND Class Type.Title is one of (Incident, Request)

My Workload

Purpose:

A list of all processes assigned to me

Prompts:

None

Fields displayed:

Color, Lifecycle, Extended ID, Title, Status, Raised By, Creation Date

Criteria:

Latest Assignment.User is current user
AND Status.Is End is equal to (false)
AND Status.Is Completion is equal to (false)

Notices Due to be Published

Purpose:

Lists Noticeboard Items due to be published in the next day

Prompts:

None

Fields displayed:

Category, Title, Public Category, Created By, Creation Date, Publication Date, Expiry Date

Criteria:

None

Outbound Mail Queue

Purpose:

Lists entries in the Message Recipient table, so that you can periodically clear the table to improve performance

Prompts:

None

Fields displayed:

Message Subject, Is Email Sent, Email Failed

Criteria:

Date Sent is older than 1 week
OR Is Email Sent is equal to True
OR Email Failed is equal to True

Private Notices

Purpose:

Lists all Noticeboard Items. For use with Self Service.

Prompts:

None

Fields displayed:

Title, Category, Creation Date, Expiry Date

Criteria:

Public Category is equal to False

Process List

Purpose:

A prioritized list of all processes

Prompts:

None

Fields displayed:

Priority Rank, Extended ID, Color, Priority Title, Class, Lifecycle, Raised By, Assigned Group, Assigned Analyst, Assignment Date, Assignment Number, Title, Status

Criteria:

None

Public Notices

Purpose:

Lists all Noticeboard Items. For use with Self Service.

Prompts:

None

Fields displayed:

Title, Category, Creation Date, Expiry Date

Criteria:

Public Category is equal to True

Search IPC

Purpose:

A prompted query that lists matching Incidents, Problems, and Changes

Prompts:

Status
ID
Title
Raise User
Creation Date

Fields displayed:

Extended ID, Title, Raised By, Created Date, Status, Type of process

Criteria:

Class Type.Title is one of Change, Incident, Problem
AND Status is equal to <prompt user>
AND Id is equal to <prompt user>
AND Title is equal to <prompt user>
AND Raise User.Title is equal to <prompt user>
AND Creation Date is equal to <prompt user>

SS All Work

Purpose:

A list of all processes. Intended for use with Self Service.

Prompts:

None

Fields displayed:

Extended ID, Raised Date, Title, Status, Raised By, Last Updated By, Lifecycle Title, Description.

Criteria:

None

SS Created By Current Group

Purpose:

A list of all processes that were created by the user's current group. Intended for use with Self Service.

Prompts:

None

Fields displayed:

Extended ID, Raised Date, Title, Status, Raised By, Last Updated By, Lifecycle Title, Description.

Criteria:

Create Group is Current Group

SS Last Updated By Current Group

Purpose:

List processes where the last update was made by the user's current group. Intended for use with Self Service.

Prompts:

None

Fields displayed:

Extended ID, Date of Last Update, Title, Status, Raised By, Last Updated By, Lifecycle Title, Description.

Criteria:

Update Group is Current Group

Super User Workload List

Purpose:

A prioritized list of all processes

Prompts:

None

Fields displayed:

Priority, Class, Lifecycle, Extended ID, Raised By, Assigned Group, Assigned Analyst, Assignment Date, Assignment Number, Title, Status

Criteria:

None

User Sessions

Purpose:

Lists all logged in users, including those who have not exited the program properly (for example, due to a computer failure). If an analyst with a concurrent license does not exit the program properly, then their license is not released and is not available for reallocation. If this happens, then if you have the relevant privilege, you can manually release the license using the User Sessions query.

Prompts:

None

Fields displayed:

User, Group, Client Type, Last Active, Start Time, End Time

Criteria:

AND Client Type is One Of (1, 2)

Users grouped by License Type

Purpose:

Lists all users grouped by the type of license they have been allocated.

Prompts:

None

Fields displayed:

Title, User Type, Primary Group

Grouping:

User License Type

Workload List

Purpose:

A prioritized list of all processes

Prompts:

None

Fields displayed:

Priority, Class, Lifecycle, Extended ID, Raised By, Assigned Group, Assigned Analyst, Assignment Date, Assignment Number, Title, Status

Criteria:

None


Was this article useful?    

The topic was:

Inaccurate

Incomplete

Not what I expected

Other