These kinds of searches are not currently possible using the web console search bar. We recommend using a custom report to retrieve this information instead. An example report can be seen below. Replace "YourID" with the hotfix ID you would like to report on.
Select tblComputers.Computername, tblComputers.Domain, tblComputers.Computer,
tblComputers.Firstseen, tblComputers.Lastseen, tblComputers.Lasttried,
tblQuickFixEngineering.Description, tblQuickFixEngineering.FixComments,
tblQuickFixEngineering.HotFixID, tblQuickFixEngineering.InstalledBy,
tblQuickFixEngineering.InstalledOn,
tblQuickFixEngineering.ServicePackInEffect, tblQuickFixEngineering.Lastchanged
From tblComputers Inner Join
tblQuickFixEngineering On tblComputers.Computername =
tblQuickFixEngineering.Computername
Where tblQuickFixEngineering.HotFixID = 'YourID'
Order By tblComputers.ComputerUnique
To use the specified report, do the following:
• Open the Lansweeper configuration console and select Reports & Alerts\Report Builder. Hit the “New” button.
• Copy the SQL code provided and paste it at the bottom of the newly created report, replacing the default SQL code.
• Click somewhere near tblComputers so the new code applies.
• Give the report a “View name” and a “Report name” and hit the “Save” button.
• Double-click on the report in the report list to see its results and export options.
