Search for	Example	Results
A single word	`cat`	Topics that contain the word "cat". You will also find its grammatical variations, such as "cats".
A phrase. You can specify that the search results contain a specific phrase.	`"cat food"` (quotation marks)	Topics that contain the literal phrase "cat food" and all its grammatical variations. Without the quotation marks, the query is equivalent to specifying an OR operator, which finds topics with one of the individual words instead of the phrase.

Search for	Operator	Example
Two or more words in the same topic	`AND` `and` `+` (plus symbol) `&` (ampersand)	`cat AND dog` `"cat food"+milk` `"cat food"&"dog food"`
Either word in a topic	`OR` `or` `\|` (pipe)	`cat OR dog` `cat \| dog`
Topics that do not contain a specific word or phrase	`NOT` `not` `!` (exclamation point)	`NOT cat` `! dog`
Topics that contain one string and do not contain another	`^` (caret)	`cat ^ mouse`
A combination of search types	`( )` parentheses	`cat + (dog \| mouse)` `cat \| dog + (! mouse)`

Server Automation10.51

Use > Server patching > Patch management for Windows > Patch management administration > Export Windows patch information

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:

In the navigation pane, select Devices > All Managed Servers.
In the content pane, select one or more managed servers.
From the Show drop-down list, select an option.
From the Actions menu, select Export Patch Info to CSV.
In the Export to CSV window, navigate to a folder and enter the file name.
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.
Click Export to save the patch information in a .csv file or click Cancel if you do not want to export the patch information.

Send Help Center feedback