none
SCCM Database architecture

    Domanda

  • Hi,

    I like to learn about the SQL queries for SCCM database. So please share the link for learning sccm database architecture and sccm queries.

    martedì 13 aprile 2010 15:18

Risposte

  • This has all the information you need to create custom reports.

    http://www.microsoft.com/downloads/details.aspx?FamilyId=87BBE64E-5439-4FC8-BECC-DEB372A40F4A&displaylang=en

    Don't confuse this with the WMI schema though that is exposed through the console; they are similar but definitely not the same. Also note that you actually use WQL in the console and not SQL; WQL is a subset of SQL.


    Jason | http://myitforum.com/cs2/blogs/jsandys | http://blogs.catapultsystems.com/jsandys/default.aspx | Twitter @JasonSandys
    martedì 13 aprile 2010 16:05

Tutte le risposte

  • This has all the information you need to create custom reports.

    http://www.microsoft.com/downloads/details.aspx?FamilyId=87BBE64E-5439-4FC8-BECC-DEB372A40F4A&displaylang=en

    Don't confuse this with the WMI schema though that is exposed through the console; they are similar but definitely not the same. Also note that you actually use WQL in the console and not SQL; WQL is a subset of SQL.


    Jason | http://myitforum.com/cs2/blogs/jsandys | http://blogs.catapultsystems.com/jsandys/default.aspx | Twitter @JasonSandys
    martedì 13 aprile 2010 16:05
  • Is there a document that shows the translation of tables/views between the SQL DB and WQL?  Converting a query from one to the other would be easier, knowing the names each uses for the same (basically) things.

    Thanks.

    venerdì 28 maggio 2010 23:52
  • Please visit Technet SCCm documentation. They indeed are very helpful !!

    Abheek Dutta IT Analyst

    giovedì 16 febbraio 2012 19:28