Database view

[Ramel]

Hi Community,

I created a database view between sys_audit and change_request as we need to report on those change requests that has been extended [planned start/end date have been changed], however I cannot make it to work. Anyone who can advise what is the correct where clause for this database view?

Thanks in advance.

Regards,

Ramel

[Dr Atul G- LNG]

Hi @Ramel 

Try to reverse the tables and then check.,

[Ramel]

Hi @Dr Atul G- LNG ,

I did change it as below but still not working.

[James Chun]

Hey @Ramel,

You should never use the Audit [sys_audit] table directly as it can cause performance degradation due to its size.

For your requirement, have you considered using Metric instead? Once you define a metric for the start/end dates, you can see how many times it was updated. 
e.g.

Refer to the doc for more info - https://docs.servicenow.com/bundle/washingtondc-platform-administration/page/use/reporting/task/crea...

Cheers

[Ramel]

@James Chun ,

Thank you for the suggestion. I have tried it but the problem is it only works for tickets that has been updated or newly created. We need to check on past tickets that mostly are already closed.

Regards,
Ramel