Home
»
WMUG
»
Lionel's configmgr blog
»
All Tags
»
datetime
Browse by Tags
WMUG
Windows Management User Group Community blogs
Get this RSS feed
Tags
collection query
sccm
sql query
Tagged Content List
Blog Post:
Collection Query to return systems before a specific Install / Creation Date
Lionel
When creating a query that returns systems before a specific date in a collection, you may get no system records back if you had done the query like the following: Incorrect Query SELECT SMS_R_SYSTEM.ResourceID,SMS_R_SYSTEM.ResourceType,SMS_R_SYSTEM.Name,SMS_R_SYSTEM.SMSUniqueIdentifier,SMS_R_SYSTEM...
on
Thu, Apr 21 2011