(imported topic written by Darknight)
Hi All,
i have created below relevance to create a custom report which will give all the details of windows patches (fixlets) , it has five columns as :
Computer Name , KB-Article , Update Title , Classifications , Published.
i want to add one more filter into this relevance that is the report should only check for the computers which are members of computer group “abc” , can someone please help me in modifying the below relevance in order to get desired result :
relevance :
<?Relevance concatenation of trs of ( td of (item 0 of it & "$" as string ) & td of (item 1 of it & "$" as string ) & td of (item 2 of it & "$" as string ) & td of (item 3 of it & "$" as string ) & td of (item 4 of it as string ) ) of ( (if (exists Names of Applicable Computers of it) then (Names of Applicable Computers of it as string) else ("$")), (if (exists Source ID of it) then (Source ID of it as string) else ("$")), (if (exists Name of it) then (Name of it as string) else ("$")), (if (exists Category of it) then (Category of it as string) else ("$")), (if (exists Source Release Date of it) then (Source Release Date of it as string) else (""))) of ( elements of ( member sets of bes computer groups whose (name of it as lowercase = "media saturn - wintel"), bes fixlets whose ( (display name of site of it = "Patches for Windows (English)") AND (((Category of it as lowercase contains "critical updates") OR (Category of it as lowercase contains "security update") OR (Category of it as lowercase contains "security advisory") OR (Category of it as lowercase contains "update rollup") OR (Category of it as lowercase contains "updates") OR (Category of it as lowercase contains "definition updates") OR (Category of it as lowercase contains "service pack") OR (Category of it as lowercase contains "rollup") OR (Category of it as lowercase contains "update") OR (Category of it as lowercase contains "security hotfix")) AND ((Name of it as lowercase does not contain "sql") AND (Name of it as lowercase does not contain "office") AND (Name of it as lowercase does not contain "visio") AND (Name of it as lowercase does not contain "excel") AND (Name of it as lowercase does not contain "sharepoint") AND (Name of it as lowercase does not contain "outlook") AND (Name of it as lowercase does not contain "powerpoint") AND (Name of it as lowercase does not contain "word") AND (Name of it as lowercase does not contain "player") AND (Name of it as lowercase does not contain "infopath") AND (Name of it as lowercase does not contain "groove") AND (Name of it as lowercase does not contain "visual") AND (Name of it as lowercase does not contain "lync") AND (Name of it as lowercase does not contain "onenote") AND (Name of it as lowercase does not contain "silverlight 5") AND (Name of it as lowercase does not contain "hotfix:") AND (Name of it as lowercase does not contain "frontpage") AND (Name of it as lowercase does not contain "corrupt patch") AND (Name of it as lowercase does not contain "access")) AND (Applicable Computer Count of it > 0)))) ?>result of above code :
Computer Name$ KB-Article$ Update Title$ Classifications$ Published
FFM04CTXCG005$ $ UPDATE: Internet Explorer 9 Available - Windows Server 2008 R2 (x64)$ Update$ Tue, 15 Mar 2011
FFM04APPSTAR01B$ $ UPDATE: Internet Explorer 9 Available - Windows Server 2008 R2 (x64)$ Update$ Tue, 15 Mar 2011
FFM04CCRDSR01$ $ UPDATE: Internet Explorer 9 Available - Windows Server 2008 R2 (x64)$ Update$ Tue, 15 Mar 2011
FFM04CTXCG006$ $ UPDATE: Internet Explorer 9 Available - Windows Server 2008 R2 (x64)$ Update$ Tue, 15 Mar 2011