Report on one fixlet with multiple properties

(imported topic written by christyshum91)

Hi I need help on running a report on one particular fixlet with the affected computers information.

The report should look like this:

Fixlet - Windows XP Service Pack 4

1st column - Affected Computer Name

2nd column - User name

3rd column - Computer Group

Is this possible?

Thanks!!

(imported comment written by BenKus)

This turns out to be pretty difficult… but here is a shot:

<?relevance trs of (td of item 0 of it & td of item 1 of it & td of item 2 of it) of (name of item 0 of it, values of result (item 0 of it, bes property "user name"), item 1 of it ) of (members whose (exists relevant fixlet whose (name of it as lowercase contains "windows xp service pack 4") of it) of it, names of it) of bes computer groups ?>
Computer Name Username Group

I think this will have performance issues if you lots of computers, but I would guess it works for most deployments under 10,000 agents… Let me know if it works for you…

Ben

(imported comment written by christyshum91)

Thank you so much!!! I got the report the way I wanted it!

(imported comment written by christyshum91)

follow up question -

Is it easier to use fixlet ID instead of the fixlet name? If this is possible, how do I replace the name with the ID in the code?

Thanks!!

(imported comment written by BenKus)

Just replace:

… exists relevant fixlet whose (name of it as lowercase contains “windows xp service pack 4”) of it …

with:

… exists relevant fixlet whose (id of it = 12345) of it …

Ben

(imported comment written by christyshum91)

Thank you very much!!