DcTrack : Différence entre versions
Sauter à la navigation
Sauter à la recherche
| Ligne 12 : | Ligne 12 : | ||
left outer join am_asset serveur on LK.CHILD_CI_ID = serveur.ASSET_ID | left outer join am_asset serveur on LK.CHILD_CI_ID = serveur.ASSET_ID | ||
Where AM.ASSET_TAG like 'IF30%' and am.STATUS_ID =8 | Where AM.ASSET_TAG like 'IF30%' and am.STATUS_ID =8 | ||
| + | |||
| + | |||
| + | ===Export EZV BC=== | ||
| + | |||
| + | select '#ADD' + ';' + 'DEVICE-BLADE CHASSIS-RACKABLE' + ';' + AM.NETWORK_IDENTIFIER + ';' + serveur.network_identifier + ';' + MAN.MANUFACTURER + ';' + CAT.ARTICLE_MODEL + ';' + 'EQUINIX-VH' + ';' + AM.E_NUM_BAIE + ';' + 'Back' + ';' + AM.E_NUM_BAIE_U + ';' + 'Both' + ';' + 'Item Front Faces Cabinet Front' + ';' + AM.SERIAL_NUMBER | ||
| + | from AM_ASSET AM | ||
| + | inner join AM_CATALOG CAT on CAT.CATALOG_ID = AM.CATALOG_ID | ||
| + | inner join AM_MANUFACTURER MAN on CAT.MANUFACTURER_ID = MAN.MANUFACTURER_ID | ||
| + | left outer join configuration_item_link LK on AM.ASSET_ID = LK.PARENT_CI_ID | ||
| + | left outer join am_asset serveur on LK.CHILD_CI_ID = serveur.ASSET_ID | ||
| + | Where AM.ASSET_TAG like 'HW00%' and am.STATUS_ID !=7 and serveur.NETWORK_IDENTIFIER like 'Bl%' | ||
Version actuelle datée du 28 octobre 2016 à 13:54
dcTrack[modifier]
Requêtes pour Import[modifier]
Export EZV PDU[modifier]
select '#ADD' + ';' + 'RACK PDU-ZERO U' + ';' + AM.NETWORK_IDENTIFIER + ';' + serveur.network_identifier + ';' + MAN.MANUFACTURER + ';' + CAT.ARTICLE_MODEL + ';' + 'EQUINIX-VH' + ';' + AM.E_NUM_BAIE + ';' + 'Back' + ';' + AM.E_NUM_BAIE_U + ';' + '1' + ';' + serveur.E_IP + ';' + 'Eth01' + ';' + 'publivac' + ';' + 'admin' + ';' + 'houlgate' + ';' + AM.SERIAL_NUMBER from AM_ASSET AM inner join AM_CATALOG CAT on CAT.CATALOG_ID = AM.CATALOG_ID inner join AM_MANUFACTURER MAN on CAT.MANUFACTURER_ID = MAN.MANUFACTURER_ID left outer join configuration_item_link LK on AM.ASSET_ID = LK.PARENT_CI_ID left outer join am_asset serveur on LK.CHILD_CI_ID = serveur.ASSET_ID Where AM.ASSET_TAG like 'IF30%' and am.STATUS_ID =8
Export EZV BC[modifier]
select '#ADD' + ';' + 'DEVICE-BLADE CHASSIS-RACKABLE' + ';' + AM.NETWORK_IDENTIFIER + ';' + serveur.network_identifier + ';' + MAN.MANUFACTURER + ';' + CAT.ARTICLE_MODEL + ';' + 'EQUINIX-VH' + ';' + AM.E_NUM_BAIE + ';' + 'Back' + ';' + AM.E_NUM_BAIE_U + ';' + 'Both' + ';' + 'Item Front Faces Cabinet Front' + ';' + AM.SERIAL_NUMBER from AM_ASSET AM inner join AM_CATALOG CAT on CAT.CATALOG_ID = AM.CATALOG_ID inner join AM_MANUFACTURER MAN on CAT.MANUFACTURER_ID = MAN.MANUFACTURER_ID left outer join configuration_item_link LK on AM.ASSET_ID = LK.PARENT_CI_ID left outer join am_asset serveur on LK.CHILD_CI_ID = serveur.ASSET_ID Where AM.ASSET_TAG like 'HW00%' and am.STATUS_ID !=7 and serveur.NETWORK_IDENTIFIER like 'Bl%'