VmDk not used since 90 days SQL script

[fthivier]

this example shows all the vmdk on the SAN disks not referenced since 90 days

with
t77 as (select to_char(sysdate -90, 'DD-Mon-YYYY') DATE_OUTPUT
from dual)

select file_name,
datastore_Name,
file_size /1024/1024 file_IN_GB,
last_updated
from apt_v_vmw_vmfile,t77
where file_size > 10000000 and datastore_name not like
'%storage%' and
last_updated < to_date(t77.date_output,'dd-mm-yyyy')
order by last_updated asc