Data transformation

DSEMAN~1_img25

Filtering Rules :

In this case we are only processing equipment that contains (cevContainerSFP, cevCpmtaomerCFP and cevContainerCXP) in the eq.cotained-equipment field or (SFP) in eq.Fdn field.

We are not using equipment that contains (container) in fdtn.description field.

We are excluding components that contains (-IDPROM) within the fdtn.name field.

 

CISCO API Field

DDA Field

Field Type

Example

Comment

eq.fdn

Linked Key

Standard

RAMPURA-ASR903-PE01.fiberathome.net 0/2/3


fdtn.description

Name

Standard

GE ZX


eq.partnumber

Component Type

Standard

GLC-BX-U

Note some dodgy data was also found here like defghipqrstuvwxy. Custom will need to map this accordingly

fdtn.name

Slot

Standard

3

Based on modified slot name

eq.serial-number

Serial Number

Custom

CI160819220


eq.is-physically-present

Physically Present

Custom

True


 

Exemptions:

Equipment without part number containing “cevSFPUnknown” have been given (SFPUnknown) as component type.

Equipment without part number containing “1.3.6.1.4.1.9.12.3.1.9.51.0” have been given (PluggableUnknown) as component type.

Equipment without part number containing “cevCPAKUknown” have been given (CPAKUnknown) as component type.