SELECT RESOURCE, ASP_NUM, ASP_STATE,
DISK_UNITS, TOTCAP, TOTCAPA,
((TOTCAP - TOTCAPA) * 100.0 /TOTCAP), THRESHOLD
FROM QSYS2.ASP_INFO
WHERE PRESENT <> 'NONE'