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
