How to create reports that focus on OLA data

[bcrose623]

We have just implemented SLA and OLA in our Production instance.  We are able to find canned reports for SLA's but we are not able to find any for OLA's.  When trying to adjust a report on SLA's to track OLA's we are unable to fin a table or condition that is specific to OLA's, IE, there is an SLA Task but no OLA Task.  What have other people/user done to address this issue to create those reports on OLA's?

[Sebas Di Loreto]

@bcrose623 

I know it is confusing, but the difference between SLA and OLA is the TYPE field like shown on the screen below. And there is a third type called "underpinning contract" (UC) as well. All of them are in the contract_sla table.

When a task is created and SLAs (or OLAs or UCs) are ran, they will show on the task_sla table, which is most likely the table you are using on your report. If you just want to see OLAs then add a condition with type=OLA.

[bcrose623]

Thanks for the response.  I am trying to modify the SLA breached report but I do not have the option to select Type and then OLA.  I even checked my personal instance and I get the same thing.  

[Sebas Di Loreto]

@bcrose623 

You have to dotwalk the "SLA definition" field first 

[bcrose623]

Thanks.  That worked.