Voip Server

view: voip_server {
  sql_table_name: VoIPServer ;;

  dimension: id {
    type: int
    primary_key: yes
    sql: ${TABLE}.serverId ;;
  }

  dimension: internal_ip {
    sql: ${TABLE}.serverInternalIP ;;
  }

  dimension: external_ip {
    sql: ${TABLE}.serverExternalIP ;;
  }

  dimension: name {
    sql: ${TABLE}.serverName ;;
  }

  dimension: outbound {
    type: yesno
    sql: ${TABLE}.serverOutbound = 'Y' ;;
  }

  dimension: external {
    type: yesno
    sql: ${TABLE}.serverExternal = 'Y' ;;
  }

  dimension: created_time {
    type: date_time
    sql: ${TABLE}.serverCreatedOn ;;
  }

  dimension: updated_time {
    type: date_time
    sql: ${TABLE}.serverUpdatedOn ;;
  }

  dimension: suspended {
    type: yesno
    sql: ${TABLE}.serverSuspended = 'Y' ;;
  }

  dimension: active {
    type: yesno
    sql: ${TABLE}.serverActive = 'Y' ;;
  }

  measure: count {
    type: count_distinct
    sql: ${id} ;;
  }
}

- view: voip_server
  sql_table_name: VoIPServer
  fields:
  - dimension: id
    type: int
    primary_key: true
    sql: ${TABLE}.serverId
  - dimension: internal_ip
    sql: ${TABLE}.serverInternalIP
  - dimension: external_ip
    sql: ${TABLE}.serverExternalIP
  - dimension: name
    sql: ${TABLE}.serverName
  - dimension: outbound
    type: yesno
    sql: ${TABLE}.serverOutbound = 'Y'
  - dimension: external
    type: yesno
    sql: ${TABLE}.serverExternal = 'Y'
  - dimension: created_time
    type: date_time
    sql: ${TABLE}.serverCreatedOn
  - dimension: updated_time
    type: date_time
    sql: ${TABLE}.serverUpdatedOn
  - dimension: suspended
    type: yesno
    sql: ${TABLE}.serverSuspended = 'Y'
  - dimension: active
    type: yesno
    sql: ${TABLE}.serverActive = 'Y'
  - measure: count
    type: count_distinct
    sql: ${id}