SCCM Report - Systems Reporting In Within Last 30 Days

Hello All,
 
Is there a canned SCCM 2007 report that list all systems that have successfully reporting into SCCM within a certain window of time, ie last 15 days?
 
Thx,
Dave

Check the last hardware scan date as it is generally a good indicator.
http://ninet.org/2011/06/sccm-all-computers-their-ou-and-last-hardware-scan/
 
Just pull the hardware scan bit out from there.

Citrix Desktop Infrastructure Analyst
MCTS: SCCM, CCNA

Blog/Site: http://ninet.org

Thanks, appreciate it, this sounds like what we need.  Have copied and pasted the query from your link into the SCCM report SQL query but when running getting "No matching records could be found".  Any suggestions?
 

Here is Query that I use to build a collection off of. This might help you out. 
 
select SMS_R_System.ResourceId, SMS_R_System.Name, SMS_G_System_WORKSTATION_STATUS.LastHardwareScan from  SMS_R_System inner join SMS_G_System_WORKSTATION_STATUS on SMS_G_System_WORKSTATION_STATUS.ResourceID = SMS_R_System.ResourceId where SMS_G_System_WORKSTATION_STATUS.LastHardwareScan < DateAdd(dd, -30,GetDate())

Here is the exact query
SELECT
a.ResourceID,
a.Netbios_name0,
b.LastHWScan 
FROM v_R_System a
INNER JOIN v_GS_WORKSTATION_STATUS b ON a.ResourceID = b.ResourceID
WHERE b.LastHWScan >= Dateadd(day, -30, getdate())

Citrix Desktop Infrastructure Analyst
MCTS: SCCM, CCNA

Blog/Site: http://ninet.org

That works great!  Thanks! The only remaining piece is, how can I get the report to inlcude operating system?

SELECT
a.ResourceID AS [ID],
a.Netbios_name0 AS [Hostname],
c.Caption0 AS [Operating System],
c.CSDVersion0 AS [Service Pack],
b.LastHWScan AS [Last HW Scan] 
FROM v_R_System a
INNER JOIN v_GS_WORKSTATION_STATUS b ON a.ResourceID = b.ResourceID
INNER JOIN v_GS_OPERATING_SYSTEM c ON a.ResourceID = c.ResourceID
WHERE b.LastHWScan >= Dateadd(day, -30, getdate())

Citrix Desktop Infrastructure Analyst
MCTS: SCCM, CCNA

Blog/Site: http://ninet.org

Worked perfectly!  Thanks!