I would also like to know that...
Indeed, i'm trying to update the CI's with SQL depending on OCS
Thanks for your help
Le 02/08/2011 02:37, Oscar Retana a écrit :
I'm afraid to be asking something that might be obvious, but I have
already googled for several hours with no results yet.
I'm looking for a module or any way to "query" OTRS's CMDB.
By "quering" the CMDB, I *don't* mean:
- To use any of the available "Stats" (reports) that only provide
a.f.a.i.k lists of CI's that have been modified or similar stats.
- To use the "Search" module, which only provides lists of CI's that
match certain criteria
- To use the "Import/Export" module, which is not of practical use for
the purposes I'm going to explain
Somehow, I'd like to be able to query the CMDB like if it is a
relational database, with SQL-like queries. Something like this example:
select cost_attribute from contract_item where ...
The "Import/Export" module could be used for this work, I know. But to
use its graphical interface is practical only for simple definitions
of CI's. When the CI's definitions are more complex, with several
nested definitions and with definitions that can be optionally
repeated (lists?) tens or hundreds of times, to use this graphical
interface is not practical at all. It would take me hours/days/weeks
to actually construct an "Import/Export" definition clicking and
adding one by one all posible expanded, maybe thousands, fields that
one of these complex CI's have... all that work, for a simple query
that I might use one one time for the purpose of certain needed
Maybe, my question is simple this: Is there a way to dump / extract
the whole CMDB into CSV files or any other flexible format that I can
more easily handle?
Thanks in advance for any advice!
OTRS mailing list: itsm - Webpage: http://otrs.org/
To unsubscribe: http://lists.otrs.org/mailman/listinfo/itsm
BARON Loïc (01 44 96 49 46)
CNRS - Délégation Paris Michel Ange
SSI (Service des Systèmes d'Information)