Weekly Report

ScottyPro Tickets

In the ScottyPro Reporting Manager run the Weekly Reports - All Support Tickets this will return all ScottyPro tickets required for the report.

Internal Tickets (Jira)

Bookmark this Jira filter

Weekly Report All Internal Tickets ( 2 weeks of Resolved/Closed)

Ticket Files Folder

• Update the 2 Ticket google sheets located in the Ticket File folder with the data from their corresponding report.

• Each Sheet will autorun a Macro that will clear the sheet of last week's data, select yes when prompted.

• Paste in data from the report into cell A1 ensuring that all columns with hash symbols are adjusted so data is visible.

• Open the Weekly Report Google Sheet. ( Important to only open report at this point )

• The report will do some initial checks and you will then get options to run.

• Wait for the report to finish.

• The Report will send itself automatically.

On the ExteNet slides go to slides number 11,12,13,14 and select “Update” wherever you see it.

Check the Awaiting Response slide, this will have the labels in the first column updated based on the contents of the latest update field.

If the “ExteNet to verify / Push to production” & “Information requested” labels need to be changed then return to the weekly report and unhide the ExteNet AWR sheet.

• Add a number 1 to the Filter column for any ticket that is awaiting ExteNet to verify something.

• Add a number 2 to the Filter column for any ticket that is awaiting information from ExteNet.

• Select “Sort”.

Go back to the slide and update.

Inform Anthony that the slides are updated.