Reports
Applies for EMv6 & EMv7.
Reports
The "Reports" section can be used to search for computers that meet specific criteria; the reports are based on the inventory elements.
It is possible to relaunch reports or view the results. You can also export them into an Excel format or edit existing reports.
When a new report is generated, you must first define which computers shall be included into the report. You may either select specific computers, access the Active Directory structure or select a computer group. It is also possible to remove specific computers from the selection.
Now you must set filters to define which computers shall ultimately be displayed in the report, for instance, a filter on the installed version of the EM Agent. Click on the magnifier in the rear part of the window to list all content of the related table of the EM database.
In step 2, you differentiate between two result types:
- Inventory result
- Target-actual comparison
Depending on the selected result type, the mask of the second step will change. If the simple inventory result type as downloadable Excel list is selected, the window looks as follows:
The familiar inventory fields that you want to display as results are selected and you may set a scheduler for the report to ensure automatic updates.
For target-actual comparisons, the window changes as follows:
In addition to the familiar inventory elements that can be selected and the scheduler you also select a target. A new window will open, displaying a view, similar to the filter.
In a last step, you can define the visibility of the report.
The calculation and calculation of a report is divided into different steps, which look as follows:
1. Calculate affected computers...
Determines all computers that belong to the report by selecting them in the menu...
...and pulls out all the computers that have been excluded.
This is the total amount of all computer objects that fall into this report.
2. Calculate temporary result...
Determines all computers that may be included in the report by individual parts of the filter. This intermediate step is done to keep the amount of data read from the DB (EM and SCCM) as small as possible.
3. Calculate final result...
Determines the final result for the report. Here the calculators that were calculated in the previous step are computed with the data that you want to output in the report.
4. Calculate members of report...
Determines the members and excluded computer objects (through the filters) for display in status.
5. Create Excel file...
The Excel file is created here.