SCCM Queries
-
This is a complete n00b question, but for whatever reason, I'm having a hard time wrapping my head around this.
Here is an example query for a device collection from this book. The tutorial walked you though making it via the wizard, then later viewing the actual query statement, which yielded.
select * from SMS_R_System where SMS_R_System.OperatingSystemNameandVersion = "%Workstation 10%"My point of confusion is what exactly is being queried. From what I've gathered it's checking against whatever database SCCM uses, which in this case is a SQL Server database. Just for giggles (since this is a test server), I decided to view the database through SQL Server Management Studio, and I noticed there are no tables named
SMS_R_SYSTEM. I'm wondering how this is possible? Clearly there's something I'm not understanding, and in the scheme of things I might not need to know the answer to this question, but it has piqued my curiosity nonetheless. -
I am not an SCCM guru, nor do I play one on tv, but it could be an alias for backwards compatibility.
-
-
@obsolesce said in SCCM Queries:
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?
