SELECT distinct t.name TableName, s.[name] StatName,STATS_DATE(t.object_id,s.[stats_id]) LastUpdated ,dm.row_count FROM sys.[stats] AS s 
JOIN sys.[tables] AS t ON [s].[object_id] = [t].[object_id] 
JOIN sys.dm_db_partition_stats dm ON t.object_id = dm.object_id 
WHERE t.type= 'u' AND s.auto_created = 0 AND s.[stats_id] < (getdate()-7) order by 4 desc
