Q: Will that do every collection we created?

A: Yes, as written it would change every collection. Modify this part: 
$collections = Get-CMCollection to do only certain collections.

Q: Does it 'uncheck' the Incremental option?

A: Not as written, to also remove incremental checkbox you could modify the 
set-cmcollection part to include the “–refreshtype periodic” parameter.

Q: Also, is there a way within it to set the actual time to do the 'Full 
Update' during that 7th day?

A: I ran in to some errors trying to get this nailed in the way I think it 
should work due to data types not converting, but this does seem to work for 
me, just adjust the time to be what you need:

$collections = Get-CMCollection

foreach ($collection in $collections)
{
Set-CMDeviceCollection  -CollectionId $collection.Collectionid -RefreshSchedule 
(New-CMSchedule -Start "12/06/16 7:30 PM" -RecurInterval Days -RecurCount 7) 
-RefreshType Periodic
}



From: listsad...@lists.myitforum.com [mailto:listsad...@lists.myitforum.com] On 
Behalf Of Adam Juelich
Sent: Tuesday, December 06, 2016 12:27 PM
To: mssms@lists.myitforum.com
Subject: Re: [mssms] Collection Update Query

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 
<matt.atkin...@providence.org<mailto:matt.atkin...@providence.org>> 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: mssms@lists.myitforum.com<mailto:mssms@lists.myitforum.com>
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<https://na01.safelinks.protection.outlook.com/?url=http%3A%2F%2Fcollection.id&data=01%7C01%7Cmatt.atkinson%40providence.org%7C1a1fa9ebec7d450aba5b08d41e17357d%7C2e3190869a2646a3865f615bed576786%7C1&sdata=Ziq5KHoqGJwmcICkudQGzJUDezSc3O%2BtjL9c7OHrUjg%3D&reserved=0>
 -RefreshSchedule $schedule
}


From: listsad...@lists.myitforum.com<mailto:listsad...@lists.myitforum.com> 
[mailto:listsad...@lists.myitforum.com] On Behalf Of Adam Juelich
Sent: Tuesday, December 06, 2016 9:40 AM
To: mssms@lists.myitforum.com<mailto:mssms@lists.myitforum.com>
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.




________________________________

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.

Reply via email to