Weekly Report

ScottyPro Tickets

For all currently open tickets run the “Weekly Reports - All Support Tickets”

For all the tickets opened and closed in the last 7 days run the “Weekly Reports - All Support Tickets Opened & Closed (7 Days)”

Internal Tickets (Jira)

Book mark this Jira filter

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

Scotty Pro Tickets

In the ScottyPro Reporting Manager run and export the report called “Weekly Reports - All Support Tickets”

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.

If the “Information” and “ExteNet to Verify” 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 slide and update Inform Anthony that the slides are updated.