Video Screencast Help
Scheduled Maintenance: Symantec Connect is scheduled to be down Saturday, April 19 from 10am to 2pm Pacific Standard Time (GMT: 5pm to 9pm) for server migration and upgrades.
Please accept our apologies in advance for any inconvenience this might cause.

Report that shows what patch is in what policy please

Created: 11 Jan 2013 | 2 comments
rockaby's picture
0 Agree
0 Disagree
0 0 Votes
Login to vote

I would love to have a report that shows what patch is in what policy.  If someone provides me the tables to use in SQL, I would be happy to build it myself.

Comments 2 CommentsJump to latest comment

Roman Vassiljev's picture

Hi rockaby,

There is default drilldown report 'View policies' - this report shows all created SWU policies for one selected bulletin. It uses stored procedure 'spPMCore_GetTaskSummary', i think you may use this default stored procedure in order to create own report that will show same information but for all bulletins
I have attached SQL query as example.

P.S. To open 'View Policies' drilldown report,  navigate to All Reports > Software > Patch Management > Software Bulletins > Software Bulletin Details. Right-click any bulletin included to SWU policy and select View Policies.

Thanks,
Roman

AttachmentSize
sqlQuery.txt 1.23 KB
0
Login to vote
rockaby's picture

Thank you.  That is what I was looking for.

0
Login to vote