Solution - Communication/Data Circuits in CMDb

[cyked]

Our Network and Telephony teams wanted a way to manage their circuits in the CMDB and be able to use them for things like Incident/Problem/Change Management.  The existing circuit table in CMDB is for power circuits (contains fields like phase, max amps, and voltage) , so I created a new table with some additional fields to meet their needs.  The new table is extended from cmdb_ci.

Below the process requirements are most specifics like field choice list detail.

Process Requirements

• Fields which are required to be populated to create a new record or update an existing record:
  • Name
  • Circuit type
  • Circuit category
  • Circuit ID
  • Terminating device
  • Support group
• Ability for members of IT Network Engineering or Telecom support groups to create new records
• Members of the set support group will have write access to the CI
  
  • Users who are not members of these groups will have read-only access and will not be able to create records
• Circuit ID field is read only unless Lifecycle status is "In build"

Technical Requirements

• There are a few required fields that are custom to Circuits that were added from the base table. Those fields are:
  • Circuit Type – Choice List with following values
    • MPLS
    • Internet
    • P2P
    • SIP
    • PRI
  • Circuit Category – Choice List with following values
    • Corporate
    • Partner
  • Circuit ID – String field (text)
  • LEC ID – String field (text)
  • Port speed – Choice List with following values
    • 10 MBPS
    • 100 MBPS
    • 1 GBPS
    • 10 GBPS
  • Circuit CIR – Choice List with following values
    • 20 Mbps
    • 30 Mbps
    • 40 Mbps
    • 50 Mbps
    • 60 Mbps
    • 70 Mbps
    • 80 Mbps
    • 90 Mbps
    • 100 Mbps
    • 200 Mbps
    • 250 Mbps
    • 300 Mbps
    • 400 Mbps
    • 500 Mbps
    • 600 Mbps
    • 700 Mbps
    • 800 Mbps
    • 900 Mbps
    • 1000 Mbps
    • 2000 Mbps
    • 5000 Mbps
    • 10000 Mbps
  • Terminating Device – Reference field to allow a Network Gear CI to be referenced on a Circuit CI record
    • Reference field is a lookup to Network Gear where the class is Router, Switch, Media Gateway, or WAN Accelerator
  • Device Interface – Reference field to allow a Network Gear CI Network Adapter CI to be referenced on a Circuit CI record
    • Reference field is a lookup to Network Adapter table. Is filtered to ONLY records related to the selected Terminating Device if one is selected
  • Circuit Provider - re-labelled company field on this table

[Rick25]

Hi Robert,

I think I installed "CMDB CI Class Models" and "Extended CMDB" to get it.

Regards,

Rick