Queries

All Bundles

Purpose:

Lists all CIs of type Bundle

Prompts:

None

Fields displayed:

Title, Creation Date

Criteria:

Class Type is equal to Bundle

All Contracts

Purpose:

Lists all CIs of type Contract

Prompts:

None

Fields displayed:

Title, Status

Criteria:

None

All Requestable CIs

Purpose:

Lists CIs that can be requested

Prompts:

None

Fields displayed:

Title, Creation Date

Criteria:

Class Type is equal to Bundle
OR Class Type is equal to Service
OR Class Type is equal to Software

All Services

Purpose:

Lists all Services

Prompts:

None

Fields displayed:

Title, Creation Date

Criteria:

Class Type is equal to Bundle
OR Class Type is equal to Service

All Software Licenses

Purpose:

Lists all CIs of type Software License

Prompts:

None

Fields displayed:

Title, Status

Criteria:

None

All Software Products

Purpose:

Lists all CIs of type Software Product.
This is used by the Calculate Software Product Values scheduled bulk action in Schedule Manager that calculates several attributes on the Software Product object.

Prompts:

None

Fields displayed:

Title, Status

Criteria:

None

Asset Manager - All Active Contracts

Purpose:

Lists all active contracts (for use in Asset Manager Workspaces)

Prompts:

None

Fields displayed:

Title, Status, Contract Type, Total Value, Entitlement Type, Supplier, Contract Owner, Contract Start, Contract End, Renewal In Progress

Criteria:

Status is equal to Active

Asset Manager - All Contracts

Purpose:

Lists all contracts (for use in Asset Manager Workspaces)

Prompts:

None

Fields displayed:

Title, Status, Contract Type, Total Value, Supplier, Contract Owner, Contract Start, Contract End, Renewal In Progress

Criteria:

None

Asset Manager - Contracts Expiring in 90 Days

Purpose:

Lists all contracts due to expire in the next 90 days (for use in Asset Manager Workspaces)

Prompts:

None

Fields displayed:

Title, Status, Contract Type, Total Value, Entitlement Type, Supplier, Contract Owner, Contract End, Contract Start, Renewal In Progress

Criteria:

Contract End is within the next 3 months
AND Status is equal to Active

Asset Manager - Hardware

Purpose:

Lists all hardware assets (for use in Asset Manager Workspaces)

Prompts:

None

Fields displayed:

Title, Asset Tag, Status, Class Type, Manufacturer, Model, Serial Number, Asset Owner, IP Address, Last Update, Cost, Warranty End Date

Criteria:

Class Type is not one of Asset, Software License, Contract, Service, Bundle, Software Product, Software Package

Asset Manager - Hardware Expiring in 90 Days

Purpose:

Lists all hardware assets due to expire in the next 90 days (for use in Asset Manager Workspaces)

Prompts:

None

Fields displayed:

Title, Asset Tag, Status, Class Type, Manufacturer, Model, Serial Number, Asset Owner, IP Address, Last Update, Location, Cost, Warranty End Date

Criteria:

Class Type is not one of Asset, Software License, Contract, Service, Bundle, Software Product, Software Package
AND Warranty End Date is within the next 3 months

Asset Manager - Licenses Expiring in 90 Days

Purpose:

Lists all licenses due to expire in the next 90 days (for use in Asset Manager Workspaces)

Prompts:

None

Fields displayed:

Title, Version, License Metric, License Type, Available From, Available To, Product Key

Criteria:

Available To is within the next 3 months

Asset Manager - Repository

Purpose:

Lists all assets (for use in Asset Manager Workspaces)

Prompts:

None

Fields displayed:

Title, Class Type, Status

Criteria:

None

Asset Manager - Software Licenses

Purpose:

Lists all software licenses (for use in Asset Manager Workspaces)

Prompts:

None

Fields displayed:

Software Title, Title, License Metric, License Type, Available From, Available To, Product Key, Cost, Quantity

Criteria:

None

Asset Manager - Software Products

Purpose:

Lists all software products (for use in Asset Manager Workspaces)

Prompts:

None

Fields displayed:

Title, Allocated Licenses, Used Licenses, Total Value, Unallocated Licenses, Purchased Licenses, Product Family, Product Version

Criteria:

None

CI Exceptions

Purpose:

Lists CI Exception attributes, grouped by CI. Used as the default query for the Configuration Management\Exception Attribute object, and so used by CI Exception Reports component.

Prompts:

None

Fields displayed:

Exception, Attribute, New Value, Old Value, Reason, Reason Category

Criteria:

None

CI List

Purpose:

Lists CIs alongside their location in the Service Catalog Hierarchy

Prompts:

None

Fields displayed:

Title, Catalog Hierarchy name

Criteria:

None

CI Selection List

Purpose:

Lists CIs grouped by CI type

Prompts:

None

Fields displayed:

Type, Item, Manufacturer, Model

Criteria:

None

Config Item and Group

Purpose:

Lists the CI and Type for each group. Suitable to use on the Groups sub-tab on the Publishing tab of the Service Catalog component.

Prompts:

None

Fields displayed:

Configuration Item, CI Type, Group

Criteria:

None

Config Item and Role

Purpose:

Lists the CI and Type for each role. Suitable to use on the Roles sub-tab on the Publishing tab of the Service Catalog component.

Prompts:

None

Fields displayed:

Configuration Item, CI Type, Role

Criteria:

Status is equal to Active
AND Contract End is older than 1 minute
AND Renewal In Progress is equal to False

Contracts For Termination

Purpose:

Lists Contracts where the current date is later than the Contract End date. This is used by the Terminate Expired Contracts scheduled bulk action in Schedule Manager to automatically terminate expired contracts that are not being renewed.

Prompts:

None

Fields displayed:

Title

Criteria:

None

Globally Published Catalog Items

Purpose:

Lists all Services that have been published to all.

Prompts:

None

Fields displayed:

Title, Catalog Hierarchy, Lifecycle, In Service Catalog, Is Featured Item, Business Service, Request Once, Links to Users, Stock Required, Manager Authorize

Criteria:

Publish To All is equal to True

Impacted CI Summary

Purpose:

Used by impact analysis in Workspaces to control the appearance of the impacted items list

Prompts:

None

Fields displayed:

CI Type, Title, Status, Asset Location, Asset Owner

Criteria:

None

Request Mode

Purpose:

Lists Business Services that are in the Service Catalog. Suitable to use on the Request Mode tab of the Service Catalog component.

Prompts:

None

Fields displayed:

Title

Criteria:

Class Type is equal to Bundle
OR Class Type is equal to Service
AND Business Service is equal to True
AND In Service Catalog is equal to True

Service Catalog Directory

Purpose:

Lists all Services.

Prompts:

None

Fields displayed:

Title, Catalog Hierarchy, Lifecycle, In Service Catalog, Is Featured Item, Business Service, Request Once, Links to Users, Stock Required, Manager Authorize

Criteria:

None

SS CI Lookup

Purpose:

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

Prompts:

None

Fields displayed:

Name, Title, Creation Date, CI Type, Version.

Criteria:

None

User Subscriptions

Purpose:

Lists services linked to the selected user

Prompts:

User

Fields displayed:

CI Serial Number, CI Title, CI Type, Request Once?, Catalog Hierarchy

Criteria:

User is equal to <prompt user>
AND Configuration Item.In Service Catalog is equal to True
AND Configuration Item.Business Service is equal to True


Was this article useful?    

The topic was:

Inaccurate

Incomplete

Not what I expected

Other