SQL Query to check when collection were updated

Hi

Use the below Query to check, when the collections were updated in SCCM 2007

Select

 CC.CollectionID,

CN.CollectionName,

Convert (VarChar(10), CC.TimeUpdated, 101)‘Last Updated’

From

Collection_MemberChg_Notif CC

Join Collections CN on CC.CollectionID = CN.SiteID

Order By [Last Updated] DESC

Advertisements
This entry was posted in SMS Query. Bookmark the permalink.

2 Responses to SQL Query to check when collection were updated

  1. Manju says:

    Thanks for the solution,…

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s