I have started pushing hotfix 805660 to workstation in my company. I want to create a query to list the PCs that have received the hotfix.
When I add hotfix/patch (VSE) to my filter it doesnt work.
Copy and paste the following Microsoft SQL, and then run it on the Microsoft Query Analyzer or Microsoft SQL Server Management Studio.
select ln.nodename as Hostname, pp.productversion as Version, pp.hotfix as Patch, ps.value as Hotfix from epoleafnode ln join epoproductproperties pp on ln.autoid = pp.parentid join epoproductsettings ps on pp.autoid = ps.parentid where ps.settingname = 'Fixes' and ps.value like '%517265%'
order by hostname
NOTE: This SQL query lists all computers where hotfix (HF517265) was installed. If you need to specify a different hotfix, replace 517265 with the relevant hotfix number.
I know your post is kind of old but I just figured out how to query for the hotfixes in ePO. I am currently on ePO 4.5 but have tested on 4.6 as well.
To create a query to identify installed hotfixes on your managed systems, build a "Managed Systems" query and select the chart type and columns that you would like. In the filter, scroll down to "Product Settings". Configure the following property filters:
Section Name Equals General
Setting Name Equals Fixes
Value Contains <enter the hotfix number(s) you want to query, i.e. 805660>