I would also like to know that...
Indeed, i'm trying to update the CI's with SQL depending on OCS Inventory exports.

Thanks for your help

Le 02/08/2011 02:37, Oscar Retana a écrit :
Hello,

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 information.

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!

--
Oscar Retana



---------------------------------------------------------------------
OTRS mailing list: itsm - Webpage: http://otrs.org/
Archive: http://lists.otrs.org/pipermail/itsm
To unsubscribe: http://lists.otrs.org/mailman/listinfo/itsm

--
BARON Loïc (01 44 96 49 46)
loic.baron@cnrs-dir.fr
CNRS - Délégation Paris Michel Ange
SSI (Service des Systèmes d'Information)