Finding hotfixs etc

[PaulVa214]

Hi,

Understanding I have limited SQL skills. How would I generate a report or export to excel to find all the machines with hotfix kb925876 and/or the ones missing that hotfix??

Thanks in advance.

[PaulVa214]

Thanks, appreciated.

[Hemoco]

To find pc's with the hotfix installed:

select distinct computername from tblQuickfixEngineering where hotfixid = 'kb925876'

No hotfix:

select computername from tblcomputers where computername not in (select distinct computername from tblQuickfixEngineering where hotfixid = 'kb925876')