Creation on database view for Change and Outage tables

Surendra6
Tera Contributor

‎06-10-2025 10:43 AM

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.

0 Helpfuls
  • 235 Views
1 REPLY 1

Chaitanya ILCR
Kilo Patron

‎06-10-2025 11:46 AM

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

ChaitanyaILCR_0-1749581114979.png

 

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

Regards,
Chaitanya

 

0 Helpfuls