@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 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.