That was precisely what I needed … thanks Todd! It’s an old trick that I had completely forgotten about.
Nick | http://t3chn1ck.wordpress.com From: [email protected] [mailto:[email protected]] On Behalf Of Todd Hemsell Sent: Thursday, August 7, 2014 11:01 AM To: [email protected] Subject: Re: [mssms] Compliance Baseline Report yea, open the smsprov log and refresh that view,. Pull the sql out of the log. Everything you view in the console is a SQl query logged in smsprov.log look for execute sql = On Thu, Aug 7, 2014 at 7:17 AM, Nick Moseley <[email protected] <mailto:[email protected]> > wrote: Hello everyone, I have a reporting need which has stumped me :) I’m hoping the collective knowledge of others much better at SQL than myself may be able to give me a tip. When viewing the status of a Compliance Baseline's deployment within the ConfigMgr console, we're able to see the non-compliant results of each item in the pane below (such as the screen shot below). This view shows the particular CI (or other included baselines) with the PCs for each. We're trying to get this into a report format, but it's been difficult to match data from the out-of-box reports or even through a querying SQL directly. Any thoughts on how this might be accomplished? Nick | http://t3chn1ck.wordpress.com
