Client Management Suite

If you find it difficult to identify patch categories within the Symantec Patch Management reports this article may be of help. I will not discuss the SQL side of the store procedures as this is built-in store procedures that I have used to add the patch categories to, it has been fully commented if you want to see how this was accomplished.

Attached are two store procedures that will be used, please note the order of events as console time-out and errors may occur if this is not followed.

The attachments has been provided in the zip attached.

Patch Management data must exist before report will have results.

Step 1: Import store procedures

This step assumes that the Symantec database is called Symantec_CMDB if not please amend in the SQL scripts.

• spPMWindows_ComplianceByBulletin_Custom.sql
• spPMCoreReport_SoftwareBulletinSummary_Custom.sql

1. Open the store procedures in SQL Management Studio
2. Login as a sysadmin or dbowner user
3. Execute the two store procedures
   1. If the name already exists rename the store procedures
   2. Make sure you note the new name as you will need to update the reports to use the new name.

Step 2: Import Parameter Report

The custom reports uses a parameter report to populate the drop down menu (combobox) in the reports for the patch categories.

• Patch Category - Custom.xml

1. Open the Symantec Management Console (SMC)
2. Navigate to Reports > All Reports
3. At any location where you want custom reports to be stored, right click the folder and select import
4. Browse to the location where you have saved the Patch Category - Custom.xml and import the report

Step 3: Import Custom Reports

• Windows Compliance by Bulletin - Custom.xml
• Software Bulletin Details - Custom.xml

1. Open the Symantec Management Console (SMC)
2. Navigate to Reports > All Reports
3. At any location where you want custom reports to be stored, right click the folder and select import
4. Browse to the location where you have saved the Windows Compliance by Bulletin - Custom.xml and import the report
5. Repeat steps 3 - 4 for the Software Bulletin Details - Custom.xml report
6. If you renamed the store procedures in step 1 edit the reports and update only the name of the store procedure, click save when done.

Once this is done the two custom report should display as per below: