Cool Solutions

Novell Service Desk – Creating custom reports using ZENworks Reporting 5 (ZR5)


May 1, 2014 3:29 pm





As most of you know, Novell Service Desk

  • has inbuilt reporting capabilities that enables users to generate management reports from the captured record details. It provides a graphical snapshot of the overall performance of the Service Desk and its Users
  • also provides the capacity to build simple custom reports using the internal system report builder without requiring in-depth knowledge of the database schema

The intent of this cool solution is to provide you with Novell Service Desk Reporting package (domain) and provide few basic steps for using ZENworks Reporting 5 (ZR5) for creating customized reports outside of the service desk product.


  • Entity Relationship document: Before you start creating customized reports, I encourage you to refer Novell Service Desk’s Entity relationship details document to understand the key tables and table relationships
  • You have the Novell Service Desk database details – host name/IP address, port, database name, and database credentials
  • You have installed ZENworks Reporting Server(ZR5) and it can establish a network connection to the server
  • You have downloaded the Novell Service Desk Reporting Package NSD-7.0.3

Environment: For the purpose of this example, I have used Novell Service Desk 7.0.3 and MSsql database.

Steps: The Novell Service Desk Reporting using ZENworks Reporting (ZR5) document has detailed steps on creation & usage of domain.

1 vote, average: 5.00 out of 51 vote, average: 5.00 out of 51 vote, average: 5.00 out of 51 vote, average: 5.00 out of 51 vote, average: 5.00 out of 5 (1 votes, average: 5.00 out of 5)
You need to be a registered member to rate this post.

Tags: , , , , , ,
Categories: Endpoint Protection Suite, Service Desk, Technical, ZENworks, ZENworks Reporting, ZENworks Suite


Disclaimer: This content is not supported by Micro Focus. It was contributed by a community member and is published "as is." It seems to have worked for at least one person, and might work for you. But please be sure to test it thoroughly before using it in a production environment.


  1. By:vgalino

    Hello. I Have Novell Service Desk on mysql, This procedure does not work with mysql, only with postgre, oracle and mssql. ¿ how can i connect zrs 5 to nds with mysql ?

  2. By:Adharsh Praveen R

    Hi VGalino, for mysql and postgresql, suggest you to use pentaho report designer as mentioned in comment 1

  3. By:sperrin

    this needs to be updated for 5.6 appliance zrs