Query Newly joined computers

[TrialandError]

I am looking for a query that finds all computers joined to the domain since XX date. I tried using the query below which looks back over the last week for new computers but this also discovers any computers that have been modified in the last 7 days. Does anyone have a query that is based on date created?

select SMS_R_System.Name,
SMS_R_System.CreationDate
FROM
SMS_R_System
WHERE
DateDiff(dd,SMS_R_System.CreationDate, GetDate ()) <= 7

[AaronBISSELL]

I use this in a report

 

select

Creation_Date0,

Name0,

User_Name0,

AD_Site_Name0

from

dbo.v_R_System

where

datediff(dd,Creation_Date0, getdate()) < 14

and Client0 = 1

I have a subscription to it that fires off every two weeks on a Monday so I can see who has ran an image / joined a PC to my domain