[Help] CI Database

Moderator: crythias

Locked
skullz
Znuny superhero
Posts: 658
Joined: 24 Feb 2012, 03:58
Znuny Version: LTS and Features
Real Name: Mo Azfar
Location: Kuala Lumpur, MY
Contact:

[Help] CI Database

Post by skullz »

hi..evening..
i'm created a CI in CMDB..
anybody know where the values is kept in database??
My Github
OTRS CE/LTS Discord Channel
Cant Update Package Anymore ? Check This

Professional OTRS, Znuny & OTOBO services: efflux.de/en
Free and premium add-ons: English
jojo
Znuny guru
Posts: 15020
Joined: 26 Jan 2007, 14:50
Znuny Version: Git Master
Contact:

Re: [Help] CI Database

Post by jojo »

the are stored in a XML format in a special table, so you can not work via SQL with the data
"Production": OTRS™ 8, OTRS™ 7, STORM powered by OTRS
"Testing": ((OTRS Community Edition)) and git Master

Never change Defaults.pm! :: Blog
Professional Services:: http://www.otrs.com :: enjoy@otrs.com
skullz
Znuny superhero
Posts: 658
Joined: 24 Feb 2012, 03:58
Znuny Version: LTS and Features
Real Name: Mo Azfar
Location: Kuala Lumpur, MY
Contact:

Re: [Help] CI Database

Post by skullz »

jojo wrote:the are stored in a XML format in a special table, so you can not work via SQL with the data
ok..thanks..
so it is possible if i can use webservices to add/edit ci class??
My Github
OTRS CE/LTS Discord Channel
Cant Update Package Anymore ? Check This

Professional OTRS, Znuny & OTOBO services: efflux.de/en
Free and premium add-ons: English
jojo
Znuny guru
Posts: 15020
Joined: 26 Jan 2007, 14:50
Znuny Version: Git Master
Contact:

Re: [Help] CI Database

Post by jojo »

there are no webservices (yet) for CIs
"Production": OTRS™ 8, OTRS™ 7, STORM powered by OTRS
"Testing": ((OTRS Community Edition)) and git Master

Never change Defaults.pm! :: Blog
Professional Services:: http://www.otrs.com :: enjoy@otrs.com
SeKSeKU
Znuny newbie
Posts: 4
Joined: 26 May 2012, 04:02
Znuny Version: 3.120
Real Name: Chia
Company: TAylor

Re: [Help] CI Database

Post by SeKSeKU »

jojo wrote:the are stored in a XML format in a special table, so you can not work via SQL with the data
Hi Jojo,
i also using OTRS 3.1 and .Net Asset management solution now .

1.Where can i have this XML file?

2.Where is this special table in OTRS database? i need to generate listing report using this table.

3. so you can not work via SQL with the data.
do you have any alternative solution to me so that i can create /modify the CI record automatically?

Thanks...
jojo
Znuny guru
Posts: 15020
Joined: 26 Jan 2007, 14:50
Znuny Version: Git Master
Contact:

Re: [Help] CI Database

Post by jojo »

3. via CSV Import/Export Modul
"Production": OTRS™ 8, OTRS™ 7, STORM powered by OTRS
"Testing": ((OTRS Community Edition)) and git Master

Never change Defaults.pm! :: Blog
Professional Services:: http://www.otrs.com :: enjoy@otrs.com
Locked