Home General Discussion

Reporting related question - Last Modified time/date stamp on SLAs

Amit_SehgalAmit_Sehgal Customer IT Monkey ✭
edited May 2019 in General Discussion

where to get the Last Modified time/date stamp on SLAs from the data warehouse,

if someone could please guide us to the right table/view where that would be stored would be great,


Answers

  • Brett_MoffettBrett_Moffett Cireson PACE Super IT Monkey ✭✭✭✭✭
    If you are looking for the History of the SLA to show you what was changed, When and by whom, then you are unfortunately out of luck as the Entity Change Log (the piece that tracks all changes to CI's, WI's etc.) is stripped off when it is saved to the Data Warehouse.

    If the item has been groomed from the Service Manager DB then the data is lost.

    I hope this makes sense.
  • Amit_SehgalAmit_Sehgal Customer IT Monkey ✭

    thanks for message Brett, appreciate your help,

    if you don't mind can you please explain a bit more on this line - 'If the item has been groomed from the Service Manager DB then the data is lost.'

    I understand the 1st bit what you are saying,


    regards,


    Amit.

Sign In or Register to comment.