evillosa.blogg.se

WITH - Linux packages can come from two different sources (rpm_packages, and debian_packages) - We combine two queries using a UNION ALL and matching the columns union_linux_packages AS ( SELECT device_name, 'dpkg' AS source, name, version AS installed_version, version_major AS installed_version_major, version_minor AS installed_version_minor, version_patch AS installed_version_patch, version_subpatch AS installed_version_subpatch FROM linux_debian_packages UNION ALL SELECT device_name, 'rpm' AS source, name, version AS installed_version, version_major AS installed_version_major, version_minor AS installed_version_minor, version_patch AS installed_version_patch, version_subpatch AS installed_version_subpatch FROM linux_rpm_packages ), zoom_latest_prompted AS ( SELECT version AS latest_prompted_version, CAST ( version_major AS int ) AS latest_major, CAST ( version_minor AS int ) AS latest_minor, CAST ( version_patch AS int ) AS latest_patch, CAST ( version_build AS int ) AS latest_build FROM zoom_latest_releases WHERE platform = 'linux' AND release_type = 'latest_prompted_release' ), merge_data AS ( SELECT ulp.