How to find all discovered PCs within the last week

Since I missed blogging yesterday here is a bonus post for today. This query will show you all PCs who DDR is less that 7 days old.

SELECT

            R.Netbios_Name0,

            R.User_Name0,

            R.Creation_Date0

FROM v_R_System R

where Datediff(DD,R.Creation_Date0,Getdate()) < 30

Leave a Reply

Your email address will not be published. Required fields are marked *