Help with unique identifiers when pulling reports from kace helpdesk
I have a helpdesk setup for cutomer service tickets for all of our locations across the country. each location has a manager that we assign as the owner of the tickets for their location. All the locations use a 3 character airport code (example - SAN for San Diego) We have 4 regional managers that are over certain groups of locations. I have reports that are scheduled to run weekly and monthly off this helpdesk. Each Regional Manager gets a report of all tickets broken down by location for his or her area. My issue is that the reports are starting to grab locations from other areas into the wrong report. The problem is that for each managers report i used the 3 character airport code in the report creator to specify which locations go into each report. Example of my issue: I have one report for the west coast. One of the locations it should pull is SAN - San Diego. That same report is pulling in our Miami location because the manager in miami has SAN in his last name (Santiago). Is there a way in the report creation tool to add spaces before and after the SAN so it wont include everything that has the letters SAN in them? I just want it to pull the one with the matching 3 digit code.
Be the first to answer this question