We sent this e-mail to otrs@otrs.org earlier but we realised that this e-mail should actually go to dev@otrs.org

For a client we are asked to implement a connection between otrs2 ITSM

and Novell ZENWorks Asset Manager. The client uses ZENWorks to
automatically fill it's inventory database with assets (for example
pc's, printers,...), using agents on it's systems. In this case Novell

ZENWorks Asset Manager uses a MS SQL Server database at the backend so
being able to talk to this database would also be fine.

The client would like a way to easily create reports to be able to find
relationships between tickets (volume) and assets. For example they

would like to find out which asset has the most tickets, which type of
asset has the most tickets and other statistics like that. So we figured
we would need to be able to match tickets with the id's of assets. The

client wouldn't like to manually type in all asset id's in OTRS so we
need to pull these id's from the Zenworks/SQL end.

We don't need to be able to write anything to this Asset Manager
database. We are not in the possesion of Novell ZENWorks Asset Manager.

So we're stuck with a couple of questions:

1.) Does there exist a public SOAP/XML-RPC/JSON-RPC interface at the MS
SQL/ZENWorks end which we can talk to?
2.) Should we create our own plugin to be able to talk to MS SQL or

Novell ZENWORKS Asset Manager?
3.) Does there exist an OTRS plugin HOWTO?
4.) Which perl module should we use? We would prefer to use some kind of
SOAP/XML-RPC/JSON-RPC module.

Thanks a bunch in advance...


Regards,

Roald and Matthijs