Hi,

 

I'm sure i'm probably just overlooking something but i am unable to find the table that links the SiteID field to the SiteName. I'm pulling the data via a SQL load into another program but cannot seem to find the descriptions for the SiteID field from servicedesk.workorder.

 

I've looked under servicedesk.sitedefinition but i am only seeing the following fields

 

SITEID,
REGIONID

ISDELETED,
TIMEZONEID

 

am i missing the NAME field or is it located elsewhere?

 

Thanks,

 

Lee