Matt, Will that do every collection we created? Does it 'uncheck' the Incremental option? Also, is there a way within it to set the actual time to do the 'Full Update' during that 7th day?
Thanks! On Tue, Dec 6, 2016 at 1:30 PM, Atkinson, Matt T < [email protected]> wrote: > Sorry, just noticed a small typo, here is the correction: > > > > $collections = Get-CMCollection > > > > $schedule = New-CMSchedule -RecurInterval Days -RecurCount 7 > > > > foreach ($collection in $collections) > > { > > Set-CMCollection -CollectionId $collection.collectionid -RefreshSchedule > $schedule > > > } > > > > *From:* Atkinson, Matt T > *Sent:* Tuesday, December 06, 2016 11:24 AM > *To:* [email protected] > *Subject:* RE: [mssms] Collection Update Query > > > > Try this out, will set them to refresh every 7 days, you probably will > need to limit or modify the command used to populate $collections to better > fit your environment: > > > > $collections = Get-CMCollection > > > > $schedule = New-CMSchedule -RecurInterval Days -RecurCount 7 > > > > foreach ($collection in $collections) > > { > > Set-CMCollection -CollectionId $collection.id -RefreshSchedule > $schedule > > > } > > > > > > *From:* [email protected] [mailto:listsadmin@lists. > myitforum.com <[email protected]>] *On Behalf Of *Adam > Juelich > *Sent:* Tuesday, December 06, 2016 9:40 AM > *To:* [email protected] > *Subject:* [mssms] Collection Update Query > > > > Hello Everyone, > > > > I just started a new gig and am taking over an existing v1511 site. SQL > is on a separate server which is a problem in itself but I was noticing > that queries were running very slowly even though that server had 28GB of > memory and we are a smaller environment (1600 clients). > > > > I started going through collections and noticed that my predecessor set > just about every Collection to do a Full Update every 15 minutes which is > just crazy. I'm weeding through them but this is getting tedious. > > > > Is there a script out there where I can modify all collections to reset to > something like every 3-7 days at 12AM? I can then go through and modify > the few I would want to have Incremental and/or more aggressive settings. > > > > Thanks! > > > > ------------------------------ > > This message is intended for the sole use of the addressee, and may > contain information that is privileged, confidential and exempt from > disclosure under applicable law. If you are not the addressee you are > hereby notified that you may not use, copy, disclose, or distribute to > anyone the message or any information contained in the message. If you have > received this message in error, please immediately advise the sender by > reply email and delete this message. > >
