1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19
| Select AM_ASSET.ASSET_TAG AS "Code matériel", AM_ASSET.SERIAL_NUMBER AS "N° de série", AM_UN_CLASSIFICATION.UN_CLASSIFICATION_FR AS "Catégorie",
AM_CATALOG.ARTICLE_MODEL AS "Modèle", AM_MANUFACTURER.MANUFACTURER AS "Marque", AM_STATUS.STATUS_FR AS "Statut",
AM_EMPLOYEE.LAST_NAME AS "Utilisateur principal", AM_ASSET.NETWORK_IDENTIFIER AS "Identifiant réseau", AM_catalog.AVAILABLE_FIELD_5 AS "Modele de remplacement", AM_catalog.AVAILABLE_FIELD_6 AS "Statut de retour",
AM_MAIN_USAGE.REFERENCE_FR AS "Emploi principal", AM_LOCATION.AVAILABLE_FIELD_1 AS "Type de site",
lpth.location_path_fr as "Localisation complète", Dpth.department_path_fr as "Entité complète"
From
AM_ASSET INNER JOIN AM_CATALOG
ON AM_ASSET.CATALOG_ID = AM_CATALOG.CATALOG_ID
INNER JOIN AM_LOCATION_PATH LPTH ON LPTH.LOCATION_ID = AM_asset.LOCATION_ID
INNER JOIN AM_DEPARTMENT_PATH DPTH ON DPTH.DEPARTMENT_ID = AM_asset.DEPARTMENT_ID
INNER JOIN AM_UN_CLASSIFICATION ON AM_CATALOG.UN_CLASSIFICATION_ID = AM_UN_CLASSIFICATION.UN_CLASSIFICATION_ID INNER JOIN AM_REFERENCE ON
AM_UN_CLASSIFICATION.ARTICLE_TYPE_ID = AM_REFERENCE.REFERENCE_ID LEFT OUTER JOIN AM_EMPLOYEE ON
AM_ASSET.EMPLOYEE_ID = AM_EMPLOYEE.EMPLOYEE_ID LEFT OUTER JOIN AM_LOCATION ON
AM_ASSET.LOCATION_ID = AM_LOCATION.LOCATION_ID LEFT OUTER JOIN AM_DEPARTMENT ON
AM_ASSET.DEPARTMENT_ID = AM_DEPARTMENT.DEPARTMENT_ID LEFT OUTER JOIN AM_MANUFACTURER ON
AM_CATALOG.MANUFACTURER_ID = AM_MANUFACTURER.MANUFACTURER_ID LEFT OUTER JOIN AM_STATUS ON
AM_ASSET.STATUS_ID = AM_STATUS.STATUS_ID LEFT OUTER JOIN V_MAIN_USAGE AM_MAIN_USAGE ON
AM_ASSET.MAIN_USAGE_ID = AM_MAIN_USAGE.REFERENCE_ID
where status_fr = 'En service' and (AM_UN_CLASSIFICATION.UN_CLASSIFICATION_id = '150' or AM_UN_CLASSIFICATION.UN_CLASSIFICATION_id = '168' or aM_UN_CLASSIFICATION.UN_CLASSIFICATION_id = 169) and am_location.available_field_1 like 'Point%' |
Partager