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]> wrote: > Hello everyone, I have a reporting need which has stumped me J 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 > > > >
