Export Windows patch information

You can export information about patches installed on an SA managed server and patches recommended by the vendor. You can also export information from patches recommended by the vendor along with model information on the selected server, such as patch policies or patch policy exceptions. The following information is exported into a .csv file:

  • ServerName: The name of the managed server.
  • OS: The operating system of the server.
  • Service Pack: The service pack level of the server being reported, such as Service Pack 3, Service Pack 4, and so on.
  • KB#: The Microsoft Knowledge Base Article number for the patch.
  • Bulletin: The MSYY-XXX ID associated with a hotfix, such as MS05‑012, MS06‑012, and so on. If the MSYY-XXX ID is unknown, this column will be blank.
  • Description: A brief description of the purpose of the patch.
  • Time Queried: The last software registration by the Agent.
  • Time Installed: The time that the patch was installed.
  • Type: The patch type.
  • Compliance Level: An integer that represents the compliance level.
  • Compliance: Text that displays when you place your cursor over the Compliance column in the Patch preview pane.
  • Exception Type: The type of exception, such as Always Install or Never Install.
  • Exception Reason: A description that explains the purpose of the exception.

Windows patch management will display all of the text, including commas, from the Description field displayed in the Patch Properties window in the Description column in the .csv file. To ensure that all of the text about a patch displays in the Description field in the .csv file, Patch Management surrounds the entire description (that you see in the Patch Properties window) with double quotes.

To export the patch information to a .csv file:

  1. In the navigation pane, select Devices > All Managed Servers.
  2. In the content pane, select one or more managed servers.
  3. From the Show drop-down list, select an option.
  4. From the Actions menu, select Export Patch Info to CSV.
  5. In the Export to CSV window, navigate to a folder and enter the file name.
  6. Verify that the file type is Comma Separated Value Files (.csv).

    If you did not include the .csv extension in the file name field, SA will append it only if you have the .csv file type selected.

  7. Click Export to save the patch information in a .csv file or click Cancel if you do not want to export the patch information.