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.
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
Replace the ZENworks Configuration Management_MSSql.biar and ZENworks Configuration Management_SybOra.biar files with updated files.
Run the novell-zenworks-configure -c UpdateBOEConfigureAction command from a command prompt.
Perform Step 1 to Step 5 in Section 1.1, Migrating ZRS Custom Reports with Simple Filters and without Filters.
(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
panel, instead of panel.Click
.In the
panel, copy the query and save it on your device.Perform Step 6 to Step 23 in Section 1.1, Migrating ZRS Custom Reports with Simple Filters and without Filters.
Paste the copied query (from ZRS report) in Step 5 under Section 1.1, Migrating ZRS Custom Reports with Simple Filters and without Filters.
(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.
Click
.In the
panel, expand .Select all of the fields and drag them into the
band.All of the fields are added to the report, with their respective names on
.If you want to format the report, for example, to change the
, select s, then change the Height, Width, Border, Font Size, Font Style, and so forth.After creating a report, perform the following to upload it into ZENworks Reporting 5:
In the
panel, expand the tree.Select the folder location, then
.In the
, specify the details, then click .Select
and browse to a report.Click
.In the /datasources/ZENworks_Datasource.
list, selectClick
.(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.
Run the report in ZENworks Reporting 5.