Table Schema

[xiax]

Hey,
Currently looking at the ServiceCenter Database we use for Peregrine, through SQL Enterprise Manager.
This is so we can use some scripting to pull off and maybe even add incidents automatically.

Looking at all the tables including, I'm wondering if anyone has a list of all the tables with all the columns or even just what each table does.

Going through the tables, it seems that they interconnect rather a lot to produce the Calls and Incidents. We also have the Change Plugin which we would like to use in the same context.

Obviously when adding data to the database, I need to make sure every table that needs to be updated is updated to stop corruption, hence I need your help.

Any help would be great

Thanks

[daurkin]

Is there a way to get a list of all the table and fields? Yes you can do but I forgot the SC command to type to have it exported to a text file. If I get it again I'll let you know.

The second part is going to probably be too much work for what it's worth. To create tickets you will have to use the ServiceCenter application. There are too many triggers, values, notifications, and fields hit when you create one ticket. Hence why there are so many tables. If you want to create something that allow you to create tickets without "using" ServiceCenter you need Get it or Connect it.

FYI - the tables in ServiceCenter that are the most helpful
assignment - some assignment group information
contacts - your customers' information
incidents - your CALL tickets
location - your location information
problem - each problem ticket update (multiple records for each ticket)
probsummary - the lastest summary of the problem ticket (one record for each ticket)
screlation - the association information of an incident ticket(s) to a problem ticket(s)
operator - operator information

Most of the table will be unreadable outside of ServiceCenter admin tools due to the structures and arrays it uses.