Procedure for Firewall Change Request Review
The Firewall Exception Request process operated by NDC&FP and ITSO is to be reviewed periodically 3-4 times per year to ensure that the service is meeting the stated goals. The process for requesting a firewall exception requires information supplied by the requester, review and approval for technical implementation by ITSO and execution by NDC&FP. The stated goal for ITSO is to complete the review and approval process in 10 business days or less. The defined metric is extracted from the ticketing system which collects data from an Online form. If any of the required fields are missing, incorrect or lacking information or the request is awaiting a response from the requester, this can cause the service response to be inaccurate.
This procedure outlines the process for data analysis of the Firewall Exception Request Service that is to be conducted periodically by ITSO.
- Login to https://help.rice.edu
- Click on new search, then in the query editor select Advanced
- Use a modified SQL query to request tickets for your desired review date.
- Example: (Content LIKE 'Destination Impact Score: High' OR Content LIKE 'Source Impact Score: High') AND Created > '2016-05-14' AND Queue = 'IT: Security / Maintenance' AND Subject LIKE '[docs] [firewall]' AND Status = 'resolved' to request all resolved tickets that have a High Impact Score after 5/14/2016 from the ITSO Maintenance Queue with a subject beginning with '[docs][firewall]'
- Export the results in an XLS format for import into Excel or a databse
- Create a column called Business Days to completion
- In the new column subtract the CF-Last_Correspond_Time from the Created column to estimate the days the ticket was open.
- For all tickets > 10 business days (days are in calendar days, you will need to adjust by subtracting 2 days every 7 for weekends) identify the approval date by ITSO and correct the CF-Last_Correspond date by replacing its value with the day the ticket was released by ITSO.
- For all tickets with a value greater than 10 evaluate the reason the ticket languished and record for review
- Calculate the percentage of tickets closed in 10 days or less =1-COUNTIF(<values from Business Days to Completion Column,">11")/<number of tickets>
- If the percentage of tickets is < 95% the SLA was violated.