query based collection problem

[troy]

Hi

 

I need to build a collection that gathers all 2008 R2 servers that were installed in the last two weeks.

 

I wrote a query, but it doesn't work.

 

I will be happy for any kind of assistance

 

I SELECT SMS_R_System.ResourceID,
SMS_R_System.Name,
SMS_R_System.ResourceDomainORWorkgroup,
SMS_G_System_OPERATING_SYSTEM.InstallDate
FROM
SMS_R_System inner join SMS_G_System_OPERATING_SYSTEM on
SMS_G_System_OPERATING_SYSTEM.ResourceId = SMS_R_System.ResourceId
WHERE

(DATEPART(year,SMS_G_System_OPERATING_SYSTEM.InstallDate) > 2010)

 

10x

troy