Anyone that was looking in that direction can suggest how to fight?
CI class structure in DB for external reporting
Moderator: crythias
-
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
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?
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)
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
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
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
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
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
[Major Code Changes]
ArticleFreeTime1-3
Ability to search ArticleFreeText