Getting Report For All Database (Tablespace)

My require is to get all tablespace used,free space report for all the databases. So I have scheduled Job in OEM to get it with below script. But always got error and my job is getting failed again and again. How to get the all tablespace (used,free space) report for all the databases.

sql' select distinct
a.tablespace_name,
SUM(a.bytes)/1024/1024 "Used Size MB",
SUM(decode(b.maxextend, null, A.BYTES/1024/1024, b.maxextend*8192/1024/1024)) "Max Size Mb",
(SUM(a.bytes)/1024/1024 - round(c."Free"/1024/1024)) "Total Used MB",
(SUM(decode(b.maxextend, null, A.BYTES/1024/1024, b.maxextend*8192/1024/1024)) - (SUM(a.bytes)/1024/1024 - round(c."Free"/1024/1024))) "Total
[code]......