database questio - location of CMDB data

Moderator: crythias

Locked
kruegerM
Znuny expert
Posts: 213
Joined: 02 Dec 2010, 16:53
Znuny Version: 6.0.29
Real Name: Marc
Company: National Jewish Health
Location: Denver, CO

database questio - location of CMDB data

Post by kruegerM »

OTRS 4.0.11

What table in the database holds the Configuration Item Version Details? We are tracking information such as equipment asset tags, serial numbers, etc - I've been asked to investigate pulling a spreadsheet from the database but I'm not finding which table would have this information that displays under the 'Version Details' when viewing a config item.

Any help much appreciated.

M
reneeb
Znuny guru
Posts: 5018
Joined: 13 Mar 2011, 09:54
Znuny Version: 6.0.x
Real Name: Renée Bäcker
Company: Perl-Services.de
Contact:

Re: database questio - location of CMDB data

Post by reneeb »

xml_storage
Perl / Znuny development: http://perl-services.de
Free Znuny add ons from the community: http://opar.perl-services.de
Commercial add ons: http://feature-addons.de
kruegerM
Znuny expert
Posts: 213
Joined: 02 Dec 2010, 16:53
Znuny Version: 6.0.29
Real Name: Marc
Company: National Jewish Health
Location: Denver, CO

Re: database questio - location of CMDB data - RESOLVED

Post by kruegerM »

perfect - thanks!
jojo
Znuny guru
Posts: 15020
Joined: 26 Jan 2007, 14:50
Znuny Version: Git Master
Contact:

Re: database questio - location of CMDB data

Post by jojo »

use 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
Locked