A total relative fixlet report

Reporting
1

(imported topic written by SystemAdmin)

I need a total relevant fixle treport about the whole system like this:

the number of total relevant fixlet: 555

Serious grading Fixlet Action

Low 0000 0000

Moderate 1111 1111

Important 1111 1111

Critical 2222 2222

total 2222 2222

I dot’n konw how to write the expression,Can somebody help me !

Thanks!

2

(imported comment written by BenKus)

Hey Kolla44,

I would like to help, but I am a bit confused about what you are looking for… Couple questions:

  1. Do you want to know the number of relevant Fixlet messages OR the number of relevant Fixlets messages for each computer (so for instance, if 1000 computers all reported the same Fixlet relevant, should that be counted as 1 or 1000?)

  2. What do you mean by your “Action” column?

  3. Do you want this only for MS patches or for all types of Fixlets?

Take a look at the “Patches for Windows Overview” in your BES Console at “Dashboards > Overviews > Patches for Windows Overview”. Do one of the graphs on the right side represent the information you want?

Ben

3

(imported comment written by SystemAdmin)

hey ben . Thanks for your answer!

  1. What I need is the number of relevant Fixlet messages,Not for each computer.

  2. I mean the number of Actions whose are relevant now.

  3. I need for all types of Fixlets.And maybe , I will need the report For MS patches like this later.

I can’t find the “Dashboards > Overviews > Patches for Windows Overview”,The bes I am using now is the Chinese version.And our customers want to see it in web report,so I need custom it .

thank you very much.

kollo44

4

(imported comment written by BenKus)

Hey Kollo44,

I am still confused by the action number that you are looking for. Are you looking for the sum of the total number of open actions for each severity?

In the meantime, we can start with the attached report. Its output will look something like this:

Relevant Fixlets by Severity

Source Severity Number of Relevant Fixlets

171

Critical 59

High 118

Important 54

Low 73

Medium 75

Moderate 15

To restrict it to Microsoft only Fixlets, you can change the relevance to (note the addition to the end of the relevance:

trs of (td of it & td of (multiplicity of it as string)) of unique values of source severities of bes fixlets whose ( applicable computer count of it > 0 AND source severity of it != “” AND source of it as lowercase = “microsoft”)

Let me know how that works for you.

Ben

5

(imported comment written by SystemAdmin)

Hey ben .

It works well .

Thanks for your answer.

:wink: