SCCM 2012 SQL Views

Posted in CM07, CM12, Configuration Manager, SQL

By Garth Jones

Awhile ago, I was looking at MOF edits and importing them into CM12. After some time I noticed that the SQL view name changed between CM07 and CM12.

Perfect, I thought, this is going to be a pain because it will mean that I have to change thousands of CM07 SQL queries to work with CM12!

CM12                                                       CM07

clip_image001   clip_image002

Without thinking about it, I started testing one of the existing SQL queries….

Read more here. 

email

Written by , Posted .