Using advanced query conditions you can run listing and distribution reports that interrogate information about SLA as part of their filter criteria. Use a listing report to get the list of items or distribution report to get a count grouped according to requirements e.g. fulfiller. The actual SLA data cannot be shown via this method but lists of items and counts satisfying SLA conditions can be easily produced. Please note that you will need to identify from primary tables ID for the below SQL i.e. The TS_ID in TS_TABLES for the primary table (in below examples it is 1011).
Example 1: SQL Server – Service Request Violations in last 30 days.
@where TSM_SERVICE_REQUESTS.TS_ID in (SELECT ITEM_ID FROM SLA_ITEM where RISK_CATEGORY='V' and START_DATE between getdate()-30 and getdate() and ITEM_TABLE_ID=1011)
Example 2: Oracle – Service Request Violations in last month
(2) Adding an SLA Status Field to the Primary Table:
(a) Add a single selection or binary/trinary field to field to your primary table e.g. SLA_STATUS (note that if each item can have multiple SLA’s then you would need one field for each SLA).
(b) On the SLA definition add a new action(s) to run the standard “update” transition and set the value of this field accordingly.