Create a Query with BMC Remedy IT Service Management

Contents

BMC Query Language

While you can search and filter with the Remedy Search dialog it is sometimes helpful to save a Remedy query for specific requirements like finding Long-runners ...
You can build expressions based on the Field names', '''Values''', '''Variables''' and 'operators
Field names
Field names appear as they show up like 'Assigned Group*+'. You can also use the Context menu to select them They are enclosed in single quotes.
Values
Values of the fields like "Resolved", Strings are enclosed in double quotes.
Variables
Environment variables $DATE$ for the current data and time are available Strings are enclosed in dollar sings.
Operators
logical and comparison operators

1) Click New Search 2) Click Advanced Search 3) Enter query below

Remedy-Search-001.png
'Assigned Group*+' = "MyGroup" and 'Reported Date+' > "31/12/13"

A Query to Find Long Runners in Remedy

If you are working with production support you are likely to be instructed to resolve defects within an SLA defined timeframe. You can use Remedies Query language to generate a report for Long-runners for your groups.
   'Assigned Group*+' = "MyGroup" 
         and ('Status*' != "Resolved" and 'Status*' != "Closed" and 'Status*' != "Cancelled" ) 
and 'Reported Date+' < ( $DATE$ - 4*24*60*60)
$DATE$
current time in seconds 4 days * 24 hours * 60 min * 60 sec = 4 days ago

Status: Published Date: 2017/06/05 14:12:53 Revision: 1.1

Copyright bei Andreas Haack (C) 2014. Diese Seite wird so wie sie ist zur Verfuegung gestellt, ohne irgenweche Garantien der Verwendbarkeit fuer bestimte Zwecke. Die auf dieser Seiten angebrachten Links liegen ausserhalb der redaktionellen Verantwortung von Andreas Haack und es wird keine Haftung oder Garantie uebernommen. Die Seiten sind Copyright (c) 2014 von Andreas Haack. Kein Teil darf ohne die schriftliche Einverstaendnis von Andreas Haack veroeffentlicht werden.
The page is provided 'as is' , without warranty of any kind, express or implied, including but not limited to the warranties of merchantability, fit- ness for a particular purpose and non-infringement. In no event shall Andreas Haack be liable for any claim, damages or other liability. This page is copyrighted property of Andreas Haack. Copyright by Andreas Haack (c) 2014 . No part of this page may be published without written permission for Andreas Haack. A hyper-link may created to this page but NOT to the embedded elements of this page. It may be freely downloaded for private purpose only as long as it is unaltered.