Service Desk Practitioners Forum
cancel
Showing results for 
Search instead for 
Did you mean: 

Service desk tables

SOLVED
Go to solution
Highlighted
Andrej_19
Collector

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,

Andrej
2 REPLIES
Dan Ioan
Frequent Visitor
Solution

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
Dan
Robert S. Falko
Honored Contributor

Re: Service desk tables

Andrej,

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).

-Josh
//Add this to "OnDomLoad" event