Creating Reports

You can create a report in ZENwork 7 Linux Management by executing the following steps:

Open your browser and enter the URL for the ZENworks Linux Management primary server (for example, http://server/zenworks).

Click on the Reports menu at the top of the toolbar on the page. You should see a display similar to Figure 10.1.

Figure 10.1. Initial Reports home page in the ZENworks Control Center.

Click on the New menu selection and choose Report from the drop-down list. This starts the Create a New Report Wizard, which walks you through the creation of a report. Step 1 of the wizard should be similar to Figure 10.2.

Figure 10.2. Step 1 (Report Information) of the Create a New Report Wizard.

Browse to and select any folders under the Reports category where you want this report definition to reside. By default all reports are under the root /Reports folder.

Enter a report name into the Report Name field.

Optionally enter a report description into the supplied text box. Press Next. Step 2 of the wizard should be similar to Figure 10.3.

Figure 10.3. Step 2 (Columns) of the Create a New Report Wizard.

In Step 2 of the report wizard you define the columns that you want in your report. Don't worry about getting everything right at this point; you can always edit this aspect after the report is created. Begin by pressing the drop-down arrow on the Columns field to select the data you want reported. The name of the column is the name of the data member that you select.

The available data members are listed in Table 10.1.

Table 10.1. Report and Filtering Data Members, Expressions, and Value Types
DATA MEMBER	OPERATOR	VALUES
Battery Chemistry	Has, Doesn't have	Lithium-ion, Nickel Metal Hydride, Nickel Cadmium, Lead Acid, Unknown, Lithium Polymer, Zinc air
Battery Design Capacity	<, >, =, >=, <=,<>	Numerical
Battery Design Voltage	<, >, =, >=, <=,<>	Numerical
Battery Manufacturer	Equal to, Contains	String
Battery Name	Equal to, Contains	String
Battery Serial Number	Equal to, Contains	String
Bios Manufacturer	Equal to, Contains	String
Bios Name	Equal to, Contains	String
Bios Primary	<, >, =, >=, <=,<>	Numerical
Bios Release Date	Before, After, Relative	Date and Time or Hours ago
Bios SMBios Version	Equal to, Contains	String
Bios Size (bytes)	<, >, =, >=, <=,<>	Numerical
Bios Version	Equal to, Contains	String
Bundle Creation Date	Before, After, Relative	Date and Time or Hours ago
Bundle Description	Equal to, Contains	String
Bundle Display Name	Equal to, Contains	String
Bundle Explorable	Is True, Is False
Bundle Hidden	Is True, Is False
Bundle Latest	Is True, Is False
Bundle Name	Equal to, Contains	String
Bundle Path	Equal to, Contains	String
Bundle Version	<, >, =, >=, <=,<>	Numerical
Bus Description	Equal to, Contains	String
CD Rom Description	Equal to, Contains	String
CD Rom Manufacturer	Equal to, Contains	String
Chassis Asset Tag	Equal to, Contains	String
Chassis Manufacturer	Equal to, Contains	String
Chassis Serial Number	Equal to, Contains	String
Chassis Type	Has, Doesn't Have	SubChassis, Expansion Chassis, Match System Chassis, Lunch Box, Space-Saving, Sub Notebook, All in One, Docking Station, Hand Held, Notebook, LapTop, Portable, Tower, Mini Tower, Pizza Box, Low Profile Desktop, Multi-system Chassis, Desktop, Sealed-Case PC, Unknown, Rack Mount Chassis, Other, Storage Chassis, Peripheral Chassis, Buss Expansion Chassis
Chassis Version	Equal to, Contains	String
Device Alias	Equal to, Contains	String
Device Code Page	Equal to, Contains	String
Device GUID	Equal to, Contains	String
Device Hostname	Equal to, Contains	String
Device Inventory Scan Time	Before, After, Relative	Date and Time or Hours ago
Device Last Contact	Before, After, Relative	Date and Time or Hours ago
Device Port	<, >, =, >=, <=,<>	Numerical
Device Primary Address	Equal to, Contains	String
Device Registered Date	Before, After, Relative	Date and Time or Hours ago
Device Virtual Memory	Equal to, Contains	String
Device Visible Memory	Equal to, Contains	String
Floppy Disk Capacity (bytes)	<, >, =, >=, <=,<>	Numerical
Floppy Disk Description	Equal to, Contains	String
Keyboard Description	Equal to, Contains	String
Logical Disk Available Space (bytes)	<, >, =, >=, <=,<>	Numerical
Logical Disk File System Size (bytes)	<, >, =, >=, <=,<>	Numerical
Logical Disk File System Type	Equal to, Contains	String
Logical Disk Label	Equal to, Contains	String
Machine Asset	Equal to, Contains	String
Machine Model	Equal to, Contains	String
Machine Model Number	Equal to, Contains	String
Machine Serial #	Equal to, Contains	String
Machine Vendor	Equal to, Contains	String
Message	Equal to, Contains	String
Message Acknowledged	Before, After, Relative	Date and Time or Hours ago
Message Additional Information	Equal to, Contains	String
Message Cleared	Before, After, Relative	Date and Time orHours ago
Message Component Name	Equal to, Contains	String
Message from This Type Object	Equal to, Contains	String
Message ID	Equal to, Contains	String
Message Logged Time	Before, After, Relative	Date and Time orHours ago
Message Raised by UID	Equal to, Contains	String
Message Severity	Equal, Not Equal	Informational, Warning, Error
Message Type	Equal, Not Equal	Client, Server
Modem Manufacturer	Equal to, Contains	String
Modem Name	Equal to, Contains	String
Monitor Description	Equal to, Contains	String
Monitor Manufacture Date	Before, After, Relative	Date and Time or Hours ago
Monitor Manufacturer	Equal to, Contains	String
Monitor Model	Equal to, Contains	String
Monitor Serial Number	Equal to, Contains	String
Monitor Viewable Size	<, >, =, >=, <=,<>	Numerical
Motherboard Description	Equal to, Contains	String
Motherboard Manufacturer	Equal to, Contains	String
Motherboard Number of Slots	<, >, =, >=, <=,<>	Numerical
Motherboard Version	Equal to, Contains	String
Network Adapter MAC Address	Equal to, Contains	String
Network Adapter Manufacturer	Equal to, Contains	String
Network Adapter Maximum Speed (Mbps)	<, >, =, >=, <=,<>	Numerical
Network Adapter Name	Equal to, Contains	String
Network Adapter Slot	Equal to, Contains	String
Network Adapter Type	Equal to, Contains	String
Operating System Architecture	Equal to, Contains	String
Operating System Detected	Equal to, Contains	String
Operating System ID	<, >, =, >=, <=,<>	Numerical
Operating System Is Product Enabled	Is True, Is False
Operating System Package Manager	Equal to, Contains	String
Operating System Primary Role	Equal to, Contains	String
Operating System Product Name	Equal to, Contains	String
Operating System Product Version	Equal to, Contains	String
Operating System	Equal to, Contains	String
Operating System Target Vendor	Equal to, Contains	String
Parallel Port Name	Equal to, Contains	String
Physical Disk Capacity (bytes)	<, >, =, >=, <=,<>	Numerical
Physical Disk Description	Equal to, Contains	String
Physical Disk Free Size (bytes)	<, >, =, >=, <=,<>	Numerical
Physical Disk Manufacturer	<, >, =, >=, <=,<>	Numerical
Physical Disk Number of Partitions	<, >, =, >=, <=,<>	Numerical
Physical Disk Removable	Has, Doesn't Have
Physical Disk Serial Number	Equal to, Contains	String
Pointer Name	Equal to, Contains	String
Pointer Number of Buttons	<, >, =, >=, <=,<>	Numerical
Power Supply Description	Equal to, Contains	String
Processor Clock Speed (MHz)	<, >, =, >=, <=,<>	Numerical
Processor Description	Equal to, Contains	String
Processor Family Type	Has, Doesn't Have	AMD AthlonMP™ Processor Family, AMD AthlonXP™ Processor Family, Intel Xeon processor MP, K602+, AMD29000 Family, Itanium Processor, Pentium III, Pentium II Xeon, 6x86, Celeron, Pentium Processor with MMX Technology, Pentium Pro, Pentium Brand, Pentium 4 Processor, Pentium III Processor with Intel SpeedStep Technology, Pentium III Xeon, AMD Athlon Processor Family, K6-3, K6-2, K6 Family, K5 Family, AMD Duron Processor Family, Unknown, Other
Processor Maximum Speed (MHz)	<, >, =, >=, <=,<>	Numerical
Processor Name	Equal to, Contains	String
Processor Other Family Description	Equal to, Contains	String
Processor Role Description	Has, Doesn't Have	Video Processor, DSP Processor, Math Processor, Central Processor, Unknown, Other
Processor Upgrade Method	Has, Doesn't Have	Slot 2, Slot 1, LIF Socket, None, Replacement/Piggy Back, ZIF Socket, Slot M, Daughter Board, Unknown, Slot A, Other, 370 Pin Socket
RPM Architecture	Equal to, Contains	String
RPM Conflicts	Equal to, Contains	String
RPM Description	Equal to, Contains	String
RPM Epoch	<, >, =, >=, <=,<>	Numerical
RPM Formal Name	Equal to, Contains	String
RPM Name	Equal to, Contains	String
RPM Obsoletes	Equal to, Contains	String
RPM Provides	Equal to, Contains	String
RPM Releases	Equal to, Contains	String
RPM Requires	Equal to, Contains	String
RPM Section	Equal to, Contains	String
RPM Summary	Equal to, Contains	String
RPM Version	Equal to, Contains	String
Serial Port Name	Equal to, Contains	String
Sound Adapter Description	Equal to, Contains	String
Sound Adapter Name	Equal to, Contains	String
Video Description	Equal to, Contains	String
Video Manufacturer	Equal to, Contains	String
Video Slot	Equal to, Contains	String

Continue to create columns by selecting additional columns from the list and pressing the Add button. Figure 10.4 shows a sample of the screen to select columns for your report.

Figure 10.4. Step 2 (Columns) of the Create a New Report Wizard after a column is defined.

10.

You can rearrange the columns by selecting the blue arrow above a column name. A left arrow moves that column one to the left, whereas a right arrow moves that column one to the right.

11.

To remove a column, press the X in the top-right corner of the column you want to remove.

12.

ZENworks Linux Management reporting also enables you to sort the report by specifying a primary and a secondary sort. If no sort is specified, the report is sorted automatically by the first column. Choose the primary sort by selecting the drop-down menu just to the right of the Primary Sort field. This displays a list of all of the columns in your report. Figure 10.5 shows a sample of selecting a filter for your report.

Figure 10.5. Step 2 (Columns) of the Create a New Report Wizard, selecting a sort.

13.

Next choose whether the sort should be ascending or descending based on the primary sort. Make the same selection for the secondary sort, if you choose. Press Next. Step 3 of the wizard should now be shown (see Figure 10.6).

Figure 10.6. Step 3 (Filters) of the Create a New Report Wizard.

14.

On Step 3 of the wizard you may choose any filters that you want to limit the data that is selected from the system. If you chose not to do filtering, just press Next. If you want to filter the selections, complete the following:

a. Select the New Filter menu item; this adds a filter line to the page.

b. In the first field of the filter line, choose whether the filter should have a NOT.

c. In the second field select one of any of the possible data members that are available in the system.

d. In the third field you can select any Boolean or comparison operator that is appropriate for the member selected. Refer to Table 10.1 for a listing of these operators.

e. If you want to remove a filter line, mark the check box next to the filter line and press the Remove menu item.

f. As you add more filter lines, you will notice a small "or" is presented to the right. This helps you understand that the filter lines will be logically ORed together. For example, a two-filter line has the Boolean equivalent of saying "If filter1 or filter2 is true then include in the report."

g. If you want to have the system perform a logical AND between filter lines rather than an OR, select the OR in the Sets Are to Be field. This causes all individual filters to be ANDed together and all groups (explained later) to be ORed together. So, for example, with a two-filter line and the Sets Are to Be field set to OR, the logic is "If filter1 and filter2 are both true for that record then include the item in the report."

h. For more complex filtering, you may construct groups of filters and have those groups ANDed or ORed together into a more complex Boolean expression. To add a group, press the New Sets menu item. When you do, all existing filters are considered to be in a group and a new group is presented on the page.

i. After you have constructed more than one filter set, changing the Sets Are to Be field causes a logical opposite effect to the full expression.

For example, if I have two filter sets, the first one saying "filter1 or filter2," and the second set saying "filter3 or filter4," and the Sets Are to Be field is set to AND, these sets will be ANDed together. This results in the following Boolean expression:

If (filter1 or filter2) and (filter3 or filter4) then include in report.

If you choose to have Sets Are to Be field set to OR, these sets are ORed together and the resulting Boolean logic is

If (filter1 and filter2) or (filter3 and filter4) then include in report.

You will notice that both the logic between the sets and the logic within the set flips to the opposite Boolean operator. This is necessary to keep the Boolean expression valid.

15.

After you have completed your filter for the report, press Next.

16.

The last page of the wizard gives a summary of your report. Press Back to return to the previous pages to make changes, or press Finish to complete the creation of the report.

17.

The next screen shows a success or failure of the report creation.

18.

Press OK. Now the new report you created appears in the report list.