This table describes the list of hotfixes installed on the computer. A hotfix is a corrective patch for the Windows System. Hotfixes included in Windows Service Packs are not listed in this table.
|
Field name |
Data type |
Description |
|
id_snapshot |
number |
Network snapshots auto-numbering |
|
server_name |
string |
Netbios name of the server (without the two back slashs) |
|
hotfix_name |
string |
Name of the hotfix. |
|
comments |
string |
Comments about the hotfix. |
|
description |
string |
Description of the hotfix. |
|
installed_by |
string |
Account used to install the hotfix (usually not retrieved). |
|
installed_on2 |
datetime |
Where the hotfix has been installed (usually not retrieved). |
|
backup_dir |
string |
Backup directory for the hotfix (usually not retrieved). |
|
installed |
boolean |
Indicates if the hotfix is currently installed. |
|
valid |
boolean |
Indicates if the hotfix is currently valid. |
The administrator of a local network has several problems with Exchange 5.5 and IIS 4.0 as described in the Microsoft Knowledge base in the Q147222 article. The problem is corrected with the Q147222 hotfix or with the Service Pack 4.
The following query can be used to list the Windows NT servers where the problem has been fixed:
SELECT DISTINCT hotfixes.server_name FROM hotfixes, servers WHERE hotfixes.server_name = servers.server_name AND ((servers.sp='Service Pack 4') OR (hotfixes.hotfix_name='Q147222'))