Queries

Lists all CIs of type Bundle

None

Title, Creation Date

Class Type is equal to Bundle

Lists all CIs of type Contract

None

Title, Status

None

Lists CIs that can be requested

None

Title, Creation Date

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

Lists all Services

None

Title, Creation Date

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

Lists all CIs of type Software License

None

Title, Status

None

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.

None

Title, Status

None

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

None

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

Status is equal to Active

Lists all contracts (for use in Asset Manager Workspaces)

None

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

None

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

None

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

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

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

None

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

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

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

None

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

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

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

None

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

Available To is within the next 3 months

Lists all assets (for use in Asset Manager Workspaces)

None

Title, Class Type, Status

None

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

None

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

None

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

None

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

None

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.

None

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

None

Lists CIs alongside their location in the Service Catalogue Hierarchy

None

Title, Catalogue Hierarchy name

None

Lists CIs grouped by CI type

None

Type, Item, Manufacturer, Model

None

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

None

Configuration Item, CI Type, Group

None

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

None

Configuration Item, CI Type, Role

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

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.

None

Title

None

Lists all Services that have been published to all.

None

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

Publish To All is equal to True

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

None

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

None

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

None

Title

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

Lists all Services.

None

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

None

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

None

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

None

Lists services linked to the selected user

User

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

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