Video Screencast Help
Give us your opinion and win with Symantec! Please help us by taking this survey to tell us about your experience with Symantec Connect, so that we can continue to grow and improve.  Take the survey.

Report that shows what patch is in what policy please

Created: 11 Jan 2013 | 6 comments
rockaby's picture
1 Agree
0 Disagree
+1 1 Vote
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 6 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
+1
Login to vote
rockaby's picture

Thank you.  That is what I was looking for.

0
Login to vote
Elvizen's picture

Hi guys, thanks for share this SQL
 

Based on this, i want to obatin targets including in each policy, but i am not finding the right join for this ..
What would be the relationship to obatin targets in each policy ??
 

Thanking in advance!

0
Login to vote
Anton_Nejolov's picture

Elvizen,

Try to make join with ItemAppliesTo table, where ResourceTargetGuid is a target guid and ItemGuid is a policy guid.

AN

+1
Login to vote
Elvizen's picture

Thanks for your suggestion  Anton_Nejolov ,

Now I have got my report based on the original and add the target column , now i will try to obtain the compliance level by each target.
 

Thanks to all

AttachmentSize
Bulletins_Policy_Target.txt 1.99 KB
0
Login to vote
Elvizen's picture

Any suggestion for obtain the % compliance by Target ??

I couldn't find the right "Count"

Thanks !

0
Login to vote