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