<?relevance
(trs of
(
td of name of computer of it &
td of (name of action of it as string) &
td of (if (exists source of source fixlet of action of it) then source of source fixlet of action of it else "n/a") &
td of (if (exists category of source fixlet of action of it) then category of source fixlet of action of it else "n/a" ) &
td of (if (exists source release date of source fixlet of action of it) then source release date of source fixlet of action of it as string else "n/a") &
td of (id of action of it as string) &
td of (status of it as string ) ) )
of results
of bes actions whose (exist source fixlet of it)
?>
Note that the last column isn’t stored in the Web Reports “session” so it isn’t possible to get this information in this report. Also, only actions with a “Source Fixlet” will show up in this report.
Note that this isn’t a small report either… Depending on how many actions/computers you have, it will be quite a huge report. You might want to filter it before running it.
I want to also add the patches that is recommended to the computer but not implement yet and filter the patch to
microsoft
source only.
I also trying if i can write a new statement
Using bes fixlet for this instate, but i get errors. i am not sure how can i write it correctly.
(trs of(
td of (name of it) )) of bes fixlets (fixlet flag of it = true) AND whose (exist results (bes property “first became relevant”, it) whose (value of it > now - 6*month))
Alright chass… Sorry I misread your requirements before…
How about this:
Computer Name
Fixlet Name
Source
Category
Source Release Date
Fixlet ID
Relevant?
First became relevant
Fixed time
<?relevance
(trs of
(
td of name of computer of it &
td of (name of fixlet of it as string) &
td of (if (exists source of fixlet of it) then source of fixlet of it else "n/a") &
td of (if (exists category of fixlet of it) then category of fixlet of it else "n/a" ) &
td of (if (exists source release date of fixlet of it) then source release date of fixlet of it as string else "n/a") &
td of (id of fixlet of it as string) &
td of (relevant flag of it as string ) &
td of (if (exists first became relevant of it) then first became relevant of it as string else "n/a") &
td of (if (exists last became nonrelevant of it) then last became nonrelevant of it as string else "n/a")
) )
of results
of bes fixlets whose (exists source of it AND source of it as lowercase = "microsoft" AND exists source release date of it AND source release date of it > (current date - 6 * 30 * day))
?>
That seems to meet your requirements… What do you think?
td of (unique values of name of fixlet of it as string)
) )
of results
of bes fixlets whose (exists source of it AND source of it as lowercase = “microsoft” AND exists source release date of it AND source release date of it > (current date - 6 * 30 * day))
of bes fixlets whose (exists source of it AND source of it as lowercase = “microsoft” AND exists source release date of it AND source release date of it > (current date - 6 * 30 * day))
Try this. It’s more in the spirit of your origninal code.
How about this? (only works in web reports and not in the console):
(trs of
(
td of (it as string)
) )
of unique values of names of fixlets of results whose (last became nonrelevant of it > (now-30*day))
of bes fixlets whose (exists source of it AND source of it as lowercase = “microsoft” )
i think this is something that i’ve been looking for in another thread… however when i paste into the colnsole I get what seesm to be no results and it doesn’t like the syntax in the webreports QNA page …
Computer Name
Fixlet Name
Source
Category
Source Release Date
Fixlet ID
Relevant?
First became relevant
Fixed time
<?relevance
(trs of
(
td of name of computer of it &
td of (name of fixlet of it as string) &
td of (if (exists source of fixlet of it) then source of fixlet of it else "n/a") &
td of (if (exists category of fixlet of it) then category of fixlet of it else "n/a" ) &
td of (if (exists source release date of fixlet of it) then source release date of fixlet of it as string else "n/a") &
td of (id of fixlet of it as string) &
td of (relevant flag of it as string ) &
td of (if (exists first became relevant of it) then first became relevant of it as string else "n/a") &
td of (if (exists last became nonrelevant of it) then last became nonrelevant of it as string else "n/a")
) )
of results
of bes fixlets whose (exists source of it AND source of it as lowercase = "microsoft" AND exists source release date of it AND source release date of it > (current date - 6 * 30 * day))
?>
Create a “blank report” in web reports and paste in your custom report code and it should work… The Web Reports QnA will only accept the session relevance (the part between the <?Relevance ... ?> block).
hi folks … its been a while … can you help me getting the logic correct to add this logic into a format for web reports… works fine in the debugger … but carn’t get the web logic rights …
name of computer of it, values of it) of results (bes property “Windows Server block size”,bes computers) whose (value of it != “OK”)
<?Relevance
trs of (td of name of computer of it & td of (concatenation ";" of values of it)) of results (bes property "Windows Server block size",bes computers) whose (value of it != "OK")
?>
I didn’t test this so hopefully I got the syntax right… Note that you can also use a “Computer Properties” report built into web reports to show the same data without having to write custom reports code.
