spot on. Kevin told me (offline) that he needed a different type of join to pull in some Null columns he need to pull into the report he wasn't in the collection query. He's got it now.
Sherry Kissinger
Microsoft MVP - ConfigMgr
mofmaster@myitforum.com
--- On Thu, 6/11/09, Steve Thompson <sthompson@myitforum.com> wrote:
WQL is the translated/interpeted language of SQL by SMS/ConfigMgr. WQL is designed to run in SMS/ConfigMgr queries, collections, etc. WQL is a subset of SQL, and somewhat limited. If you notice WQL uses different resource names for objects.
Is it possible that you may be seeing a difference in clients vs non clients, in other words is the count higher using the SQL. Also, I would not run the WQL query in Query Analyzer, only the SQL...
From: "Schwartzmiller, Kevin J." <KSchwartzmiller@foley.com>
Sent: Thursday, June 11, 2009 7:55 AM
To: mssms@lists.myitforum.com
Subject: [mssms] WQL vs SQL Differnet Results
Can someone explain to me why I see differences between a WQL result set and a the SQL result set in term of items found? If I capture the WQL query in SQL Profiler and then run the query I will get the same results as the WQL query. However, that query uses tables which I know you are not suppose to use tables to report from. When I change the query to use views I get different results by approximately 200 results.
Seems like I could use some direction as to how this should work.
The preceding email message may be confidential or protected by the attorney-client privilege. It is not intended for transmission to, or receipt by, any unauthorized persons. If you have received this message in error, please (i) do not read it, (ii) reply to the sender that you received the message in error, and (iii) erase or destroy the message. Legal advice contained in the preceding message is solely for the benefit of the Foley & Lardner LLP client(s) represented by the Firm in the particular matter that is the subject of this message, and may not be relied upon by any other party.
Internal Revenue Service regulations require that certain types of written advice include a disclaimer. To the extent the preceding message contains advice relating to a Federal tax issue, unless expressly stated otherwise the advice is not intended or written to be used, and it cannot be used by the recipient or any other taxpayer, for the purpose of avoiding Federal tax penalties, and was not written to support the promotion or marketing of any transaction or matter discussed herein.
==============
Missed an email? Check out the list archive:
http://myitforum.com/cs2/blogs/smslist/
==============
Missed an email? Check out the list archive:
http://myitforum.com/cs2/blogs/smslist/
