Video Screencast Help
Symantec to Separate Into Two Focused, Industry-Leading Technology Companies. Learn more.

Patch management 7.5

Created: 28 Jul 2014 • Updated: 15 Nov 2014 | 6 comments
ronak8590's picture
This issue has been solved. See solution.

HI,

I want compliance report bulletin wise and with hostname or computer name along with it, so that we can see which are the patches pending on specific machine. How do I generate that report?

Thanks.

Operating Systems:

Comments 6 CommentsJump to latest comment

James007's picture

You can check this

Windows Compliance by Bulletin report (Reports > Software > Patch Management > Compliance > Windows Compliance by Bulletin

ronak8590's picture

Hi James,

I checked that but it shows only the bulletins and its compliance, doesn't show hostname or computer name.

I want name of computer and the patches or bulletins that are applicable or installed or yet to be installed on that machine.

Thanks.

Sumit G's picture

Not be sure, is this report you are require?

Check the thread

https://www-secure.symantec.com/connect/forums/patch-management-compliance-report-question

Regards

Sumit G.

Igor Perevozchikov's picture

Did you check these reports?

PatchReport_StatusInstall.jpg

  1. Don't forget that, first you can find an answer for your question in Knowledge base
  2. If answer solves your question, then please mark as solution to close a thread
Joshua Rasmussen's picture

Hello ronak8590,

The reporting is in place to give this data in a way to maximize the best performance, for the data will return and display rows exponentially for each client and for each update.

The Compliance by Computer report is the best out of box for this request, for then you can quickly see the Computer Name and the count of updates not installed. You may change the parameters of dates in the report to reflect a specific month of deployments and see a count of what has not been deployed. Most of the time you will see a common value of 'Vulnerable' updates, and you may hightlight a client right-click > View Not Installed Updates to see details of which they are. Spot check a few and you will see they are generally the same updates due to a problem with the deployment, client execution, returned data from the client or processing of Patch Inventories. Then you may correct the issue.

Additionally, I have attached a SQL report that will give you what you are asking, but again please keep in mind that this report is going to hit the database for each update and return a row for each client. Example: If you have 200 updates applicable to each machine, and 5k machines, you will get 1m rows returned. 

Hope this helps,

Joshua

AttachmentSize
SQL Query - Ultimate Patch Report - all updates & bulletins.txt 2.48 KB
SOLUTION