Navigation

    ML
    • Register
    • Login
    • Search
    • Recent
    • Categories
    • Tags
    • Popular
    • Users
    • Groups
    1. Home
    2. Tags
    3. system center configuration manager
    Log in to post
    • EddieJennings

      SCCM Queries
      IT Discussion • query sccm sccm 1610 system center configuration manager wql • • EddieJennings

      4
      2
      Votes
      4
      Posts
      289
      Views

      EddieJennings

      @obsolesce said in SCCM Queries:

      https://docs.microsoft.com/en-us/sccm/develop/reference/core/clients/manage/sms_r_system-server-wmi-class

      And I see many of the attributes I can include in a query there. So when a query is run, this class is generated, which populates itself with the relevant data from the database, then the query selects the necessary data from this on-the-fly generated class. Does that seem right?

    • EddieJennings

      System center configuration manager and SQL server
      IT Discussion • design sccm sql server system center configuration manager • • EddieJennings

      2
      0
      Votes
      2
      Posts
      347
      Views

      dafyre

      @eddiejennings said in System center configuration manager and SQL server:

      For those who use SCCM, do you host the database on the same server as the SCCM application, or do you have SQL server as its own VM?

      I am replacing SCCM in our test environment, and will be doing the same eventually in our production environment. The current one has SQL server host locally. But since were looking to start over, I figured it would be worth weighing the pros and cons of keeping SQL Server local or having you be on the remote server.

      In my last job, we ran SCCM for a while and we had everything on one VM. (Small set up with ~200 PCs). It ran OK.

      I'd suggest keeping it to one host for your test environment, and separating them out for your production setup.