how to skip tempdb in SP_MSFOREACHTABLE and SP_SPACEUSED

SET QUOTED_IDENTIFIER ON 
GO
SET ANSI_NULLS ON 
GO
 
 
 
alter   PROCEDURE sp_spaceused_all_test @action smallint = 0
AS
 
SET NOCOUNT ON
/* 
 
THIS procedures acuracy is dependant on table statistics being up to date
If table statistics are not up-to-date run
sp_msforeachdb 'DBCC UPDATEUSAGE (''?'')' during off peak hours to recalculate stats.
Takes aproximately 10 minutes to run on both servers. 
 
@ACTION statuses: 
0 = normal. Just returns data
1 = summary. Returns data in summary
2 = insert. Inserts data into history table.
 
EXEC sp_spaceused_all_test @action = 2
*/
CREATE TABLE #t1 (name sysname
	, rows INT
	, reserved VARCHAR(200)
	, data VARCHAR(200)
	, index_size VARCHAR(200)
	, unused VARCHAR(200)
	, db sysname
	)
CREATE TABLE #t2 (
	name sysname
	, rows INT
	, reserved VARCHAR(200)
	, data VARCHAR(200)
	, index_size VARCHAR(200)
	, unused VARCHAR(200)
)
 
DECLARE @sql VARCHAR(2000)
 
 
set @sql = '?.dbo.SP_MSFOREACHTABLE ''INSERT INTO #t2 exec SP_SPACEUSED  ''''|'''''',''|'' INSERT INTO #t1 SELECT *,''?'' FROM #t2 TRUNCATE TABLE #t2'
 
 
EXEC sp_msforeachdb2 @sql
SELECT name
	,rows
	,CAST(REPLACE(reserved,' KB','') AS INT) reserved
	,CAST(REPLACE(data,' KB','') AS INT) data
	,CAST(REPLACE(index_size,' KB','') AS INT) index_size
	,CAST(REPLACE(unused,' KB','') AS INT) unused
	,db
	,Getdate() run_dt
INTO #t3
FROM #t1
WHERE db <> 'tempdb'
 
SELECT name
	,rows
	,CAST(reserved/1024.00/1024.00 AS DEC(18,4)) reserved_gb
	,CAST(data/1024.00/1024.00 AS DEC(18,4)) data_gb
	,CAST(index_size/1024.00/1024.00 AS DEC(18,4)) index_size_gb
	,CAST(unused/1024.00/1024.00 AS DEC(18,4)) unused_gb
	,reserved reserved_kb
	,data data_kb
	,index_size index_size_kb
	,unused unused_kb
	,db
	,run_dt
INTO #t4
FROM #t3
ORDER BY reserved DESC
 
 
IF @action = 1 --Summary
BEGIN
	SELECT db
		,sum(reserved_gb) reserved_gb
		,sum(data_gb) data_gb
		,sum(index_size_gb)index_size_gb
		,sum(unused_gb) unused_gb
		,CAST(CAST(run_dt AS VARCHAR(11)) AS DATETIME) run_dt
	FROM #t4
	GROUP BY db, CAST(CAST(run_dt AS VARCHAR(11)) AS DATETIME) 
	ORDER BY reserved_gb DESC
END
ELSE IF @action = 0 --Detail
BEGIN
	SELECT *
	FROM #t4
	ORDER BY reserved_gb DESC, db, name
END
ELSE IF @action = 2
BEGIN 
 
	--CHECK IF TABLE EXISTS If Not Create
	if not exists (select * from dba_maintenance.dbo.sysobjects where name = 'LT_AUDIT_Test' and xtype = 'U')
	BEGIN 
		CREATE TABLE TestDB.DBO.LT_AUDIT_Test (
		name sysname
		,rows INT
		,reserved_gb DEC(18,4)
		,data_gb DEC(18,4)
		,index_size_gb DEC(18,4)
		,unused_gb DEC(18,4)
		,reserved_kb INT
		,data_kb INT
		,index_size_kb INT
		,unused_kb INT
		,db sysname
		,run_dt DATETIME
		,server sysname
		)
	END
 
	INSERT INTO [Testdb].[dbo].[LT_AUDIT_Test]
	SELECT [name]
		, [rows]
		, [reserved_gb]
		, [data_gb]
		, [index_size_gb]
		, [unused_gb]
		, [reserved_kb]
		, [data_kb]
		, [index_size_kb]
		, [unused_kb]
		, [db]
		, [run_dt]
		, @@SERVERNAME 
	FROM #t4
 
 
END
ELSE 
BEGIN 
 
	GOTO raise_error
 
END
 
DROP TABLE #t1
DROP TABLE #t2
DROP TABLE #t3
DROP TABLE #t4
RETURN
 
raise_error:
 
RAISERROR ('You have Selected an incorrect Action. Actions must be 0 (detail), 1 (summary) or 2 (insert to history table)', 16, 1)
RETURN
SET NOCOUNT OFF
 
 
 
 
GO
SET QUOTED_IDENTIFIER OFF 
GO
SET ANSI_NULLS ON 
GO