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