I’m creating several properties that will be used as baselines for our workstation builds. We would like to use those properties to generate a report (one property at a time), that will show us only computers with “X” not installed. Management doesn’t want to receive emailed reports where or “False” is listed.
For example: I want to produce a report that lists all computers that do not have antivirus running, using the following relevance:
(not exists service “ntrtscan”) OR (state of service “ntrtscan” = “Stopped”)
I’d like the report to only show computers where that statement comes back True so we can narrow dow the list a bit. Is this possible or will the report always require some manual manipulation to clean up?
If you have a property that is just returning true or false to represent a problem, you should consider using a Fixlet with the same relevance. Then you can create all your reports based on whether the Fixlets are relevant (and you have lots of report options for Fixlets).
You can use web reports to filter out the unwanted results. In this case, you might want to create a ‘Computer Properties’ report, and then filter out any results. Here are the steps to take in web reports:
Click the ‘Create Report’ link in the Web Reports menu bar.
Chose ‘Computer Properties’ and click next.
Use the top 3 select boxes to chose how you would like to organize the results. You can leave them all at ‘none’ if you want a flat report with one computer per line.
In the ‘Summarize’ select box, chose the property you’d like to report on, then click next.
At this point, you’ll have the unfiltered report. Now we need to remove the results you are not interested in.
In the side bar on the left, chose ‘Create Filter’ from the ‘Filter Report’ select drop down.
Expand to Computer —> Retrived Property —> The property you want to report on.
Under ‘Type:’ chose ‘Exclude’
Under ‘Values:’ select any of the values you’d like to exclude, and then click the + icon.
If you’d like to save the filter for future use, click the ‘save filter’ button, and give the filter a name, otherwise click ‘Done’. The report will be regenerated with the appropriate results excluded.
If you saved the filter it will now be available for all your reports in the ‘Filter Report’ drop down in your sidebar. Anytime you are viewing a report, you can select the filter to have it applied to the current report.
Let us know if this was the report you were looking for.