Relevant Fixlets grouped by computer name or AD group

Reporting
1

(imported topic written by mauricem)

At our company our computers have a common naming scheme that identifes what location they are in (USSC = US Scottsdale for example). We’d like to build a custom report similar to the “Relevant Fixlets” report but that isolates it to the “Affected computers” output and groups them by either the computer name or the AD group they’re in. That way sites can use it to identify systems under their control out of compliance. We can do it by exporting the report to a CSV file and using formulas to count the numbers of systems with a common name, but is there a way to build a custom report to do this for us?

Thanks in advance for any help with this.

2

(imported comment written by BenKus)

Hi mauricem,

The best way to accomplish this will probably be to make a retrieved property that exposes the naming scheme. Once you have a property, you can easily filter your report or group them by these values.

Here is an example:

If your naming scheme is the first 4 letters of the computer name, you can make a property like:

first 4 of computer name

If you have a more complicated naming scheme, post some of the details and we can help you make better properties.

Ben

3

(imported comment written by mauricem)

We created the retrieved property that you recommended (which works very well BTW), but now I can’t find the option to group it in the report I’m looking for.

I go to Create Report \ Relevant Fixlets \ and it creates a report, but I don’t see an option to group it by using the retrieved property.

Am I missing something?

4

(imported comment written by jessewk)

In Web Reports:

  1. Choose ‘Create’ from the top navigation bar.

  2. Choose ‘Computer Properties Report’ and click next.

  3. Use the top 3 boxes to choose how the results are organized. You would chose your group property.

  4. Use the bottom box to select any properties you would like to appear as columns.

  5. Check the box at the bottom ‘Show relevant Fixlets’

  6. (optional) apply a filter to remove fixlets you don’t care about. For example, apply a filter that shows only fixlets from Enterprise Security.