SELECT
t.name AS tenantupper(m.clientid) AS wzm.statusm.end_test_datenull as dt_end_of_testv.name AS vdcp.name AS provider_vdcCASE
WHEN v.name LIKE '%-v1cl1%' THEN 'iaas.ngc.i29'
WHEN v.name LIKE '%-v1cl2%' THEN 'iaas.ngc.i31'
WHEN v.name LIKE '%-v1cl4%' THEN 'iaas.ngc.a28'
WHEN v.name LIKE '%-v1cl5%' THEN 'iaas.ngc.a45'
WHEN v.name LIKE '%-v1cl6%' THEN 'iaas.ngc.i28'
WHEN v.name LIKE '%-v1cl7%' THEN 'iaas.ngc.a40'
ELSE '['||v.name||']'
END AS codesp.name AS storage_profileround(AVG(c."limit")/1024.) AS limit_gbround(AVG(c."used")/1024.) AS alloc_gbtm.ts
FROM ngcloud_ru.capacity_storage c
JOIN ngcloud_ru.storage_profile_types sp ON c.storage_profile_types_id = sp.id
JOIN ngcloud_ru.vdc v ON c.vdc_id = v.id
JOIN ngcloud_ru.provider_vdc p ON v.provider_vdc_id = p.id
JOIN ngcloud_ru.tenant t ON t.id = v.tenant_id
LEFT JOIN LATERAL (
SELECT tm.ts, tm.metadata_id
FROM ngcloud_ru.tenant_metadata tm
WHERE tm.tenant_id = t.id
ORDER BY tm.ts DESC, tm.metadata_id DESC
LIMIT 1
) tm ON true
LEFT JOIN ngcloud_ru.metadata m ON tm.metadata_id = m.id
WHERE c.timestamp >=
GROUP BY
m.clientid, v.name, p.name, sp.name, t.name,
m.status, m.end_test_date, tm.ts
SELECT upper(k.id_klienta) as wz, k.__id as id, c.__name as responsible, c.email as responsible_email, c.__status_status as responsible_status
from elma.companies k
LEFT OUTER JOIN elma.comp_users_ext c on (k.responsible=c.__id)
select
s.tenants.wzs.statuss.end_test_dates.dt_end_of_tests.vdcs.provider_vdcs.codes.storage_profiles.limit_gbs.alloc_gbs.tsr.responsibler.responsible_emailr.responsible_status
from qStorage s
LEFT OUTER JOIN qResponsible r ON (s.wz=r.wz)
ORDER BY
Тесты и хранение