Hi,

I am wondering if there is a way to report on the collection refresh schedule for all of my SCCM collections?  I have 100's of collections and want to minimize the impact of refreshing these collection on the server performance.

Have you looked at this?

select * from dbo.v_Collection

Thanks for the response.  There is some valuable information there, but the query does not show the refresh schedule information.

It looks like this powershell technique gives me some good detail:  http://depsharee.blogspot.com/2011/07/list-configmgr-2007-collections-refresh.html?spref=tw

However, the schedule is shows the schedule in days.  I would like to get more detail and see the exact time of the refresh.

What the above PS script gives you>  Microsoft Updates Tool : Occures every  Day

What I want> Microsoft Updates Tool: Occures every  Day at 4:00am

That info is within the db, but you will need to break out the sdk to read that information.

select * from

dbo.v_Collection

Hi !

I have the same problem, I'm searching about this :

In collections properties, Membership Rules, at the end we can found "Schedule a full update on this collection,  elow we have the occurs, I search this information in my database and I didn't found it.

Can you help me ?

Thank you !