Hi All,
I'm hoping someone with a deep knowledge of how Compliance Baselines (DCM) and
in particular the SQL database architecture can assist with this question,
because I spent 2hrs on the phone with Microsoft premier support yesterday to
no avail (they didn't seem to know much about Baselines/DCM at all which was
very disappointing).
Environment:
SCCM 2012 R2 SP1 (5.00.8239.100), 1 x Primary site server running on Server
2012 R2 and 6 x DP.
Issue:
Compliance baselines are displaying stale summarization data.
As I understand it the SCCM console and Summary reports pull data from SQL
table "CI_ComplianceSummary" which should be populated when either the
scheduled summarization (set to every 2 hours) or manual "run Summarization"
task is executed, however this data is not updating in my environment.
I know data in the baseline summarization data is stale because if I dig into
the report to display by CI "Summary compliance by configuration items for a
configuration baseline" current data is displayed which is different to the
baseline summarization data within the SCCM console or report "Summary
compliance by configuration baseline".
Troubleshooting steps:
1. I've had my SQL team run a profiler on the database while I manually
execute the summarization task, nothing stands out as being an issue.
2. SMSProv.log shows WQL and SQL queries being executed (see below),
returning 0 of 2 which might point to the problem but why is it retuning 0 of
2? :
[cid:image001.png@01D1A788.F0F95D00]
Can anyone suggest what else I might do to find the root cause of this issue,
or offer any advice on steps to try and resolve this problem?
Many thanks,
Jason
This email, the information therein and any attached materials (collectively
the "Email") are intended only for the addressee(s) and may contain
confidential, proprietary, copyrighted and/or privileged material. If you have
received this Email in error please delete it and notify the sender
immediately. This Email remains the property of Brevan Howard, which reserves
the right to require its return (together with any copies or extracts thereof)
at any time upon request. Any unauthorised review, retransmission,
dissemination, forwarding, printing, copying or other use of this Email is
prohibited. Brevan Howard may be legally required to review and retain outgoing
and incoming email and produce it to regulatory authorities and others with
legal rights to the information. Internet communications cannot be guaranteed
to be secure or error free as information could be intercepted, changed
corrupted, lost, arrive late or contain viruses. Brevan Howard accepts no
liability for any errors or omissions in this Email which arise as a result of
internet transmission. This Email is not an official confirmation of any
transaction. Any comments or statements made herein do not necessarily reflect
the views of Brevan Howard.
This Email is not an offer to sell or solicitation of an offer to buy any
security or investment. It does not constitute or contain any investment advice
and is being made without regard to the recipients investment objectives,
financial situation or means. Past Performance is not an indicator of future
results and Brevan Howard provides no assurance that future results will be
consistent with any information provided herein or attached hereto. Brevan
Howard and the sender make no warranties regarding the accuracy or completeness
of the information in this Email and it should not be relied upon and is
subject to change without notice. Brevan Howard and its representatives,
officers and employees accept no responsibility for any losses suffered as a
result of reliance on the information in this Email or the reliability,
accuracy, or completeness thereof.
In this Email, "Brevan Howard" means Brevan Howard Asset Management LLP
("BHAM"), Brevan Howard Inc., Brevan Howard (Israel) Ltd and their respective
affiliates. BHAM is a limited liability partnership authorised and regulated by
the Financial Conduct Authority of the United Kingdom and registered in England
& Wales (reg. no. OC302636).
