1.3 Migrating ZRS Custom Reports that have Multiple Measures

If you have more than one measure in a ZRS custom report, then depending on the number of measures, the number of queries is displayed. For example, in a custom report if you have two measures, then two queries are displayed for that report. Thus, getting a single query from multiple queries is difficult. However, by importing an updated Universe (.biar) file, you can get a single query for multiple queries.

  1. Back up the ZENworks Configuration Management_MSSql.biar and ZENworks Configuration Management_SybOra.biar files. The files are located at the following path:

    • For Windows: %ZRS_HOME%\share\boe-publish\universe

    • For Linux: /opt/novell/zenworks/share/boe-publish/universe

  2. Replace the ZENworks Configuration Management_MSSql.biar and ZENworks Configuration Management_SybOra.biar files with updated files.

  3. Run the novell-zenworks-configure -c UpdateBOEConfigureAction command from a command prompt. 

  4. Perform Step 1 to Step 5 in Section 1.1, Migrating ZRS Custom Reports with Simple Filters and without Filters.

  5. (Conditional) If your custom report has Input Control (filters).

    For example, if you have prompt filter for Platform, then create a report and select Platform in the Result Objects panel, instead of Query Filters panel.

    1. Click View SQL.

    2. In the SQL Viewer panel, copy the query and save it on your device.

  6. Perform Step 6 to Step 23 in Section 1.1, Migrating ZRS Custom Reports with Simple Filters and without Filters.

  7. Paste the copied query (from ZRS report) in Step 5 under Section 1.1, Migrating ZRS Custom Reports with Simple Filters and without Filters.

  8. (Conditional) If your custom report has a prompt, delete the content from the SQL keyword WHERE through the end.

    For example, the original query is as follows:

    SELECT
     zDevice1.Platform
    
    FROM
     zDevice zDevice1 INNER JOIN zZENObject zZENObject1 ON (zDevice1.ZUID=zZENObject1.ZUID AND zZENObject1.PrimaryType='Device')
      
    WHERE
     zZENObject1.Name IN @prompt('Enter value(s) for Device Name:','A','Managed Device Status\Device Name',Multi,Free,Persistent,,User:0)
     AND (zZENObject1.Path like '/~dev%')
    

    The modified query is as follows:

    SELECT
     zDevice1.Platform
    
    FROM
     zDevice zDevice1 INNER JOIN zZENObject zZENObject1 ON (zDevice1.ZUID=zZENObject1.ZUID AND zZENObject1.PrimaryType='Device')
    

    All fields related to the query are displayed. If an error is displayed, it indicates that the query has issues, and it must be modified.

  9. Click OK.

  10. In the Report Inspector panel, expand Fields.

  11. Select all of the fields and drag them into the Designer > Detail band.

    All of the fields are added to the report, with their respective names on Column Header.

    If you want to format the report, for example, to change the Column Header, select Column Header > Properties, then change the Height, Width, Border, Font Size, Font Style, and so forth.

  12. After creating a report, perform the following to upload it into ZENworks Reporting 5:

    1. In the Repository Navigator panel, expand the Server tree.

    2. Select the folder location, then right-click > Add > JasperServer Report.

    3. In the ReportUnit Wizard, specify the details, then click Next.

    4. Select Locally Defined and browse to a report.

    5. Click Next.

    6. In the From the repository list, select /datasources/ZENworks_Datasource.

    7. Click Finish.

  13. (Conditional) If your custom report has an input control, perform Step 11 to Step 32 in Section 1.2, Migrating ZRS Custom Reports with Prompt Filters.

  14. Run the report in ZENworks Reporting 5.