Creation on database view for Change and Outage tables

[Surendra6]

Hi All,

Can anyone please help to create database view where clause for below mentioned tables.

Table                          Variable prefix     

cmdb_ci_outage    -   co

change_request     -  chg

task_outage           -  out

Thank you in advance.

[Chaitanya ILCR]

Hi @Surendra6 ,

if you are trying to report on this you can create the report directly on the task_outage table as it has both outage and task reference fields you can do a dot walk and pull the relevant info

but as you asked

out is a reserve word hence for task_outage I have changed the variable prefix to tout

Please mark my answer as helpful/correct if it resolves your query.

Regards,
Chaitanya