Service Desk Practitioners Forum

Service desk tables

Go to solution
Honored Contributor.

Service desk tables

I was looking at Service desk 4.5 tables and I was wondering, what do prefixes of the tables mean and what kind of data are supposed to contain.

I'm specifically interested in prefixes
Fog_, IFC_, ITSM_, REP_, Spot_.

Anyone ?

Best regards,

Dan Ioan
Honored Contributor.

Re: Service desk tables

Hi Andrej,

As far as I know the prefixes mentioned bellow have the following meaning:
ITSM_ - main tables of SD, where are stored
all items such as service calls, changes, incidents, problems, configuration items, location, persons, etc.
REP_ - repository area of SD for special data like kernel codes, data exchange, DB rules, settings for admin console, etc.
IFC_ - Tables used to store sequences related to application server, attribute definition for an entity, etc. SD client cann't modify these directly, in application.
Fog_ and Spot_ are something I can't identify.
I presume that you can obtain more information by own creation of Data Dictionary:
System Panel-->Settings-->Report settings-->Create data dictionary
Hope this helps you a little.

Best regards
Robert S. Falko
Acclaimed Contributor.

Re: Service desk tables


I can confirm that fog_ and spot_ are not ovsd tables.

IFC_ tables contain data dictionary information, too.

When you first install OVSD you must choose the name of the account in the database that owns the schema (optionally, one account for itsm and one for rep). All the OVSD objects are owned by this account(these accounts).