CI class structure in DB for external reporting

Moderator: crythias

Locked
yuri0001
Znuny superhero
Posts: 630
Joined: 17 Mar 2011, 14:40
Znuny Version: 5.0.6
Real Name: Yuri Kolesnikov
Location: Russia

CI class structure in DB for external reporting

Post by yuri0001 »

Began to deal with the CMDB, bearing in mind that after filling the bases I can generate reports on them by external reporting tools such as BusinessObjects. Considering the structure of the DB MySQL found that, at first glance, to take the structure directly from the database can not be - the description is stored in a blob, and completely opaque. A report OTRS frankly rather weak.
Anyone that was looking in that direction can suggest how to fight? :(
Best regards Yuri Kolesnikov
OTRS 5.0.14, ITSM 5.0.14
SUSE 13.2, MariaDB 10.0.22(productive)
OTRS 5.0.14, ITSM 5.0.14(test)
oretana
Znuny newbie
Posts: 1
Joined: 02 Aug 2011, 02:54
Znuny Version: 2.4
Real Name: Oscar Retana
Company: Gridshield

Re: CI class structure in DB for external reporting

Post by oretana »

Hello!

I am facing this same situation and frustration. Did you find any approach to be able to easily extract information from OTRS's CMDB?

Thanks! - Oscar
MichaelR
Znuny expert
Posts: 250
Joined: 12 Oct 2010, 01:35
Znuny Version: 3.0.9
Company: LRS Health

Re: CI class structure in DB for external reporting

Post by MichaelR »

I don't quite get what you mean. You want to extract CMDB information from OTRS' database for reporting, and you cannot understand the CMDB layout in the database?

Ps. there is a russian section to the otrs forums
OTRS: 3.0.9 & ITSM 3.0.4 - OS: Windows 7 - DB: MySQL - Heaps of random/useful hacks :)
[Major Code Changes]
ArticleFreeTime1-3
Ability to search ArticleFreeText
Locked