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:[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.
