SCCM Client Status Reporting issue with multiple sites

Agent health is one of our top priorities in every SCCM deployment, we know if agents are good we can achieve a three nines success in software distributions or software updates. This is the reason we developed a combined strategy for agent health, on one side we use the SCCM Client Status Reporting tool, on the other we developed our complementary solution. Once the data from both systems flows in, reporting helps us to keep under control the agents.

Working on this topic we hit a known bug supposed to be fixed in SCCM Service Pack 2 (http://support.microsoft.com/default.aspx/kb/960634). When multiple sites are present the Client Status Reporting Tool doesn’t return the correct last DDR time, this means the agent is marked as unhealthy even if it is not.

After applying SP2 we found the issue is still there, so with a little reverse engineering I tracked the guilty stored procedure and modified it so that it would return the latest DDR received for any site the agent is reporting to. ** totally unsupported mod, as always **