Monitoring - add Requests Statistics

[tpurschke]

In UI Monitoring - in LSB

• under External Requests add Sub Menu item "Statistics"
• add Internal Requests with Sub Menu items Tickets and Tasks

Functionality

All data needs to be given in absolute and percent values.

Query for Enternal Requests statistics:

query getExternalRequestStatistics($fromDate: timestamp) {
  totalExtRequest: ext_request_aggregate(where: {create_date: {_gte: $fromDate}}) {
    aggregate {
      count
    }
  }
  failedExtRequestAR: ext_request_aggregate(where: {create_date: {_gte: $fromDate}, ext_request_state: {_in: ["ExtReqAckRejected", "ExtReqDiscarded"]}, ext_request_type: {_in: ["(AccessRequest, UPDATE)", "(AccessRequest, CREATE)"]}}) {
    aggregate {
      count
    }
  }
  successfulExtRequestAR: ext_request_aggregate(where: {create_date: {_gte: $fromDate}, ext_request_state: {_in: ["ExtReqAcknowledged"]}, ext_request_type: {_in: ["(AccessRequest, UPDATE)", "(AccessRequest, CREATE)"]}}) {
    aggregate {
      count
    }
  }
  failedExtRequestGroupModify: ext_request_aggregate(where: {create_date: {_gte: $fromDate}, ext_request_state: {_in: ["ExtReqAckRejected", "ExtReqDiscarded"]}, ext_request_type: {_in: ["(NetworkObjectModify, UPDATE)", "(NetworkObjectModify, CREATE)"]}}) {
    aggregate {
      count
    }
  }
  successfulExtRequestGroupModigy: ext_request_aggregate(where: {create_date: {_gte: $fromDate}, ext_request_state: {_in: ["ExtReqAcknowledged"]}, ext_request_type: {_in: ["(NetworkObjectModify, UPDATE)", "(NetworkObjectModify, CREATE)"]}}) {
    aggregate {
      count
    }
  }
  runningExtRequestGroupModify: ext_request_aggregate(where: {create_date: {_gte: $fromDate}, ext_request_state: {_in: ["ExtReqInProgress"]}, ext_request_type: {_in: ["(NetworkObjectModify, UPDATE)", "(NetworkObjectModify, CREATE)"]}}) {
    aggregate {
      count
    }
  }
  runningExtRequestGroupModigy: ext_request_aggregate(where: {create_date: {_gte: $fromDate}, ext_request_state: {_in: ["ExtReqInProgress"]}, ext_request_type: {_in: ["(NetworkObjectModify, UPDATE)", "(NetworkObjectModify, CREATE)"]}}) {
    aggregate {
      count
    }
  }
}

Query for Internal Requests statistics:

query getInternalRequestStats($fromDate: timestamp) {
  totalInternalTickets: request_ticket_aggregate(where: {date_created: {_gte: $fromDate}}) {
    aggregate {
      count
    }
  }
  successfulTufinExternalRequests: request_ticket_aggregate(where: {date_created: {_gte: $fromDate}, 
    ext_requests: {ext_request_state: {_in: ["ExtReqAcknowledged"]}}}) {
    aggregate {
      count
    }
  }
  failedTufinExternalRequests: request_ticket_aggregate(where: {date_created: {_gte: $fromDate}, 
    ext_requests: {ext_request_state: {_in: ["ExtReqAckRejected", "ExtReqDiscarded"]}}}) {
    aggregate {
      count
    }
  }
  successfulTickets: request_ticket_aggregate(where: {date_created: {_gte: $fromDate},
    state: {id: {_in: [249,510, 600]}}}) {
    aggregate {
      count
    }
  }
  failedTickets: request_ticket_aggregate(where: {date_created: {_gte: $fromDate},
    state: {id: {_in: [501,610]}}}) {
    aggregate {
      count
    }
  }
  openTickets: request_ticket_aggregate(where: {date_created: {_gte: $fromDate}, 
    state: {id: {_in: [49, 210]}}}) {
    aggregate {
      count
    }
  }
}