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

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