Hi all,
i have a relevance which give me the details of total installed HOTFIXID details with installed on , and Description for the HOTFIX now i want to do some more customization on this relevance so that i can give a report to my cleint with in this year total installed Hot fix details.
2016 :
KBXXXXXX MM/DD/YYYY Hot fix description
My relevance is as below :
(( if ( exists property "HotFixID" of it ) then (string value of property "HotFixID" of it ) else ( "" )) , ( if ( exists property "InstalledOn" of it ) then (( if ( exists hexadecimal integer ( it )) then (((month of it as integer as string & "/" & day_of_month of it as integer as string & "/" & year of it as string) of ((january 1 of 1601 ) + ((hexadecimal integer ( it ) / ( 864000000000 )) * day))) of it ) else ( it )) of string value of property "InstalledOn" of it ) else ( "" )) , ( if ( exists property "Description" of it ) then (string value of property "Description" of it ) else ( "" ))) of select objects "* from Win32_QuickFixEngineering" of WMI
Please help me
Thanks in advance 
Would this work?
(string value of property "HotFixID" of it | "None", string value of property "InstalledOn" of it | "None") of ((select objects "* from Win32_QuickFixEngineering" of WMI) whose (((it as date) of ( ((it as integer as string) of preceding text of last "/" of following text of first "/" of it ) &" "& (preceding text of first "/" of it as integer as month as three letters)&" "& (following text of last "/" of it as integer as string)) of string value of property "InstalledOn" of it) > (january 1 of 2015)))
This is three pieces:
Getting the HotFixID and Installed On:
(string value of property "HotFixID" of it | "None", string value of property "InstalledOn" of it | "None") of
Getting the HotFixes from WMI:
(select objects "* from Win32_QuickFixEngineering" of WMI)
Converting InstalledOn into a date object and then comparing against a given date:
((select objects "* from Win32_QuickFixEngineering" of WMI) whose (((it as date) of ( ((it as integer as string) of preceding text of last "/" of following text of first "/" of it ) &" "& (preceding text of first "/" of it as integer as month as three letters)&" "& (following text of last "/" of it as integer as string)) of string value of property "InstalledOn" of it) > (january 1 of 2015)))
Or for a more compact version of this:
(select objects "* from Win32_QuickFixEngineering" of WMI) whose (date (local time zone) of (time value of property "InstalledOn" of it) | january 1 of 1601 > january 1 of 2015)
Pulling out specific values…
(time value of property "InstalledOn" of it, string value of property "Description" of it | "None" , string value of property "HotFixID" of it | "None" ) of (select objects "* from Win32_QuickFixEngineering" of WMI) whose (date (local time zone) of (time value of property "InstalledOn" of it) | january 1 of 1601 > january 1 of 2015)
