Hello all,We are in the process of upgrading from SMS to SCCM in a very large environment (126,000 machines). I'm sure you can all guess that we have quite a few collections and advertisements. As part of our upgrade, we are looking to clean out all advertisements older than 60 days, but not remove advertisments that are recurring to help clean up our database.I've looked through the records in the SMS views for Advertisement and Advertisement Info and it appears I can use the 'present time' field to query against. Problem is, the present time field's data shows up like this:PresentTime = "20060423192300.000000+***"I've checked multiple advertisements and these fields are all different, so it appears the 'timeclock' is being incremented, but in just some weird format. I can build the procedure if I can get some clarification on this field format and how to 'treat' in in the procedure.How anyone else done anything like this and could shed some light on how you approached it? I'd be greatly appreciated!Thanks,MDH

The only supported way to do this would be to use the SDK. Editing the db directly is not supported and might not do what you want either, particularly in a n-teir setup.http://www.enhansoft.com/