[SOLVED]CMDB configuration item details in database

Moderator: crythias

Post Reply
BrianYin
OTRS newbie
Posts: 76
Joined: 29 Aug 2012, 10:12
OTRS Version?: 3.1.12

[SOLVED]CMDB configuration item details in database

Post by BrianYin »

hi, everyone
does anyone using CMDB in OTRS right now. i have a problem of finding configuration item details in database. i don't know which table contains its details(cpu,ram,owner,hard disk...) which i added when i created this item.
i find the class defination history in xml-storage, however, i don't find my information in that one, is there anyone can tell me how can i read this table? Thanks !!
Last edited by BrianYin on 26 Oct 2012, 11:20, edited 1 time in total.
OTRS Version: 3.1.9
OS: windows 2003
ITSM 3.1.6
MySQL 5.xxx

jojo
Moderator
Posts: 14859
Joined: 26 Jan 2007, 14:50
OTRS Version?: Git Master
Contact:

Re: CMDB configuration item details in database

Post by jojo »

CIs are stored in XML, so SQL can not be used directly
"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

BrianYin
OTRS newbie
Posts: 76
Joined: 29 Aug 2012, 10:12
OTRS Version?: 3.1.12

Re: CMDB configuration item details in database

Post by BrianYin »

if SQL can not be used directly, where can i get configuration item details ? copy them from agent frontend? that's not convenient.
system saved thoes information in cache? it should be somewhere....i think
OTRS Version: 3.1.9
OS: windows 2003
ITSM 3.1.6
MySQL 5.xxx

jojo
Moderator
Posts: 14859
Joined: 26 Jan 2007, 14:50
OTRS Version?: Git Master
Contact:

Re: CMDB configuration item details in database

Post by jojo »

you can export it as CSV via Import/Export Module
"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

BrianYin
OTRS newbie
Posts: 76
Joined: 29 Aug 2012, 10:12
OTRS Version?: 3.1.12

Re: CMDB configuration item details in database

Post by BrianYin »

ok, that's what i need, thanks !
OTRS Version: 3.1.9
OS: windows 2003
ITSM 3.1.6
MySQL 5.xxx

Post Reply