Yes there were 3 Deployment's targeted to collection .
On Wed, Oct 9, 2013 at 1:52 AM, Stephen Owen <[email protected]> wrote: > I agree, I don't think colleciton history is tracked, at least not from > what I've seen looking through the tables and views in SQL. > > Maybe there is some other way we can determine if they were a member of > the collection. Are there any advertisements associated with that > collection? > > > On Tue, Oct 8, 2013 at 3:01 PM, Siddharth Sharma < > [email protected]> wrote: > >> Hi >> >> I had this one , so can this be tweaked to get systems that were partof >> particular collection between certain time period . >> SELECT >> >> SMS_R_SYSTEM.ResourceID,SMS_R_SYSTEM.ResourceType,SMS_R_SYSTEM.Name,SMS_R_SYSTEM.SMSUniqueIdentifier,SMS_R_SYSTEM.ResourceDomainORWorkgroup,SMS_R_SYSTEM.Client >> FROM >> SMS_R_System >> WHERE >> SMS_R_System.CreationDate < "20130821090527.000000+***" >> >> >> On Tue, Oct 8, 2013 at 7:53 PM, Ryan <[email protected]> wrote: >> >>> I don't think collection history for objects is tracked. You said you >>> wanted to tweak one, which one were you looking at? >>> >>> >>> On Tue, Oct 8, 2013 at 6:51 AM, Siddharth Sharma < >>> [email protected]> wrote: >>> >>>> >>>> Hi Guys, >>>> I am not good at queries , so just wanted to tweak this one if i can >>>> get machines which part of collection between a time frame for example >>>> machines that were part of collection for xyz collection between 19th >>>> August to 22nd august . >>>> >>>> >>>> >>>> -- >>>> Thanks >>>> Siddharth Sharma >>>> >>>> >>> >>> >> >> >> -- >> Thanks >> Siddharth Sharma >> >> > > -- Thanks Siddharth Sharma
