Accedi
 
HomeLibraryRisorseFormazioneDownloadSupportoCommunityForumBlog
Risorse per professionisti IT >
> 
> 
SCCM Database architecture

Answered SCCM Database architecture

  • martedì 13 aprile 2010 15:18
     
     
    Registrati per votare
    0

    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.

     

Tutte le risposte

  • martedì 13 aprile 2010 16:05
     
     Con risposta
    Registrati per votare
    0

    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
     
  • venerdì 28 maggio 2010 23:52
     
     
    Registrati per votare
    0

    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.

     
  • giovedì 16 febbraio 2012 19:28
     
     
    Registrati per votare
    0
    Please visit Technet SCCm documentation. They indeed are very helpful !!

    Abheek Dutta IT Analyst