No link for "Computer" in report.

[AdmJLovejoy]

No link for "Computer" in the following report.

OS: KB932370 (WMI CPU) Hotfix NOT Installed

Select Distinct Top 10000 dbo.tblComputers.Computer, dbo.tblOperatingsystem.Caption As [OS Version], dbo.tblComputers.Domain, dbo.tblComputers.FQDN, dbo.tblComputers.LastknownIP, dbo.TsysLastscan.Lasttime As Lastscanned From dbo.tblComputers Inner Join dbo.TsysLastscan On dbo.tblComputers.Computername = dbo.TsysLastscan.Computername Left Outer Join dbo.tblOperatingsystem On dbo.tblComputers.Computername = dbo.tblOperatingsystem.Computername Inner Join TsysWaittime On TsysWaittime.CFGCode = dbo.TsysLastscan.CFGcode Where dbo.tblComputers.Computername Not In (Select tblquickfixengineering.Computername From tblquickfixengineering Where tblquickfixengineering.HotFixID Like '%KB932370%') And dbo.tblOperatingsystem.Caption Like '%Server 2003%' And TsysWaittime.CFGname = 'QUICKFIX' Order By dbo.tblComputers.Computer, dbo.tblComputers.Domain

Am I missing something here?

[Hemoco]

I'll better add it to the documentation.

[AdmJLovejoy]

Cumbersome requirement, but that did it.

[Hemoco]

Add field "computername" to the output, this is the primary key used to make the link