Table name for a Site's State

[Alisha]

Hello,

Please could someone let me know what table the Site's State is stored in. Would I use h_sys_contact_extra, and can I join it with h_itsm_requests?

Many thanks,
Alisha 

[Bob Dickinson]

Hi @Alisha

The site info is stored in h_sys_sites (including the state). I have attached an example report which shows the potential join you would need to show this attribute is a request based report. 

Hope this helps

Kind Regards

Bob

all-open-incidents-by-site-state.report.txt