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 !!
[SOLVED]CMDB configuration item details in database
Moderator: crythias
[SOLVED]CMDB configuration item details in database
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
OS: windows 2003
ITSM 3.1.6
MySQL 5.xxx
Re: CMDB configuration item details in database
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
"Testing": ((OTRS Community Edition)) and git Master
Never change Defaults.pm! :: Blog
Professional Services:: http://www.otrs.com :: enjoy@otrs.com
Re: CMDB configuration item details in database
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
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
OS: windows 2003
ITSM 3.1.6
MySQL 5.xxx
Re: CMDB configuration item details in database
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
"Testing": ((OTRS Community Edition)) and git Master
Never change Defaults.pm! :: Blog
Professional Services:: http://www.otrs.com :: enjoy@otrs.com
Re: CMDB configuration item details in database
ok, that's what i need, thanks !
OTRS Version: 3.1.9
OS: windows 2003
ITSM 3.1.6
MySQL 5.xxx
OS: windows 2003
ITSM 3.1.6
MySQL 5.xxx