Video Screencast Help

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