Blog DevSecOps GitLab Heroes Unmasked: How I am elevating my company using GitLab
Published on: May 12, 2022
6 min read

GitLab Heroes Unmasked: How I am elevating my company using GitLab

Tickett Enterprises Limited Director Lee Tickett shares the details of his ongoing journey to use the DevOps platform to its fullest.

heroestickett.jpg

A key to GitLab’s success is our vast community of advocates. Here at GitLab, we call these active contributors "GitLab Heroes". Each hero contributes to GitLab in numerous ways, including elevating releases, sharing best practices, speaking at events, and more. The "GitLab Heroes Unmasked" series is dedicated to sharing their stories.

Lee Tickett, director at IT development and support consultancy Tickett Enterprises Limited, is a GitLab hero and Core team member who continuously contributes to GitLab and provides exceptional feedback. In late 2020, he wrote a blog about how he came upon GitLab and began to use it as his company's platform.

At that point, his company was using GitLab in the following ways:

  • for version control
  • with a custom merge request approval process
  • as a custom UI for streamlined/standardized project creation
  • as an integration with our bespoke helpdesk platform
  • as a Windows runner with fairly basic CI

This blog picks up where that blog left off and gives insight into how Tickett Enterprises is making the most of GitLab's One DevOps Platform for its helpdesk, CRM integration, CI/CD, and more.

Migrating the helpdesk

Quite some time ago, I decided to migrate from the bespoke helpdesk platform and use GitLab for issue tracking. Here's an epic I created just over two years ago to start discussing my plans.

I built a bespoke migration tool using C#, which connects directly to the existing helpdesk database and pushes the data into GitLab using the API. This includes:

  • groups (each company in our helpdesk will become a group in GitLab with a single Helpdesk project)
  • issues (every ticket in our helpdesk will become an issue in GitLab, estimates will be included and quotes converted to weights)
  • notes
  • attachments
  • time logs
  • labels (type, class, department, and "status" will be migrated to labels)

Helpdesk workflow

After discussing different approaches with the GitLab team and the community, we came up with the first iteration of our workflow process. The status of tickets in our helpdesk system becomes scoped labels in GitLab. It looks similar to the following:

Workflow Issue Board

We have two relatively small teams so we can also leverage boards to distribute and manage work within the team:

Department Issue Board

We will be leveraging the GitLab Triage RubyGem and Triage Ops project to handle reactive and scheduled automation, such as:

  • opening pending issues once they reach their due date (this field has been slightly repurposed)
  • nudging users when issues have been pended, but no due date has been assigned
  • nudging the team when issues have not been triaged (labeled, estimates/quotes attached, etc.)

GitLab triage will run as a scheduled pipeline from inside of GitLab, and Triage Ops (formerly known as Triage Serverless) will run as webhooks in AWS Lambda (triggered by webhooks). We may potentially transition some of our existing customizations from C# to GitLab Triage/Triage Ops, too.

Building out CRM

One of the biggest challenges moving our helpdesk over to GitLab was the inability to tie issues to Customers. So, roughly a year ago, I decided to start building out a Customer Relations Management (CRM) feature.

You can see some of the work that has gone into the CRM so far: CRM Merged MRs.

It’s surprising how much work is needed for what seems like a mostly simple feature. Despite careful planning, there were many surprises that caused significant headaches. I was hoping to formally release this in December 2021, but it looks like June 2022 is more feasible now.

Reporting

Compared to our previous bespoke SQL Server Reporting Services (SSRS) report suite pulling directly from our helpdesk, reporting is very limited. We tried using SSRS with a SQL Server linked to our GitLab Postgres server, but kept hitting walls. We are now moving forward using Google Data Studio (with a direct database connection).

Although we still have a way to go, we've managed to achieve some really great results.

Scheduled Pipelines Report

Here's an example of a report we've started to build to increase the visibility of our scheduled interfaces now that we're leveraging CI/CD more.

Challenges

One obstacle we were faced with was the inability to achieve a lot of our goals at the instance level. Some GitLab functionality is at the project level, some at the group, and some at an instance. As a result, we had to create a temporary single root group and create all groups beneath it.

Moving to Linux/Docker for CI/CD pipelines

We have almost moved completely to Linux/Docker for our CI/CD pipelines, using several custom images:

  • our custom .NET image simply adds chromedriver to the default mcr.microsoft.com/dotnet/core/sdk:latest image to add Selenium support for UI testing
  • our custom Android/Gradle image provides a stable build environment for our Clover apps (which require v1 APK signing no longer supported in Android Studio).

You can see sample .gitlab-ci.yml templates in the relevant projects.

We now have our test summary and coverage visualization displayed in merge requests, which is a total game changer!

GitLab for intranet

We've been using SharePoint for as long as I can remember, and I'm not a fan.

As great as a WYSIWYG interface is, I believe it brings with it:

  • a lack of consistency
  • a pretty awful audit trail
  • no review/approval process

So let's try and learn from the best. Can we use GitLab pages? Absolutely!

We picked Hugo purely as it seems the most popular (most forked GitLab pages project template). Similarly, the Relearn theme seems to be the most popular for docs.

It's still a work in progress, but we’re exploring a structure similar to:

Clients
-Client A
--System A
--System B
-Client B
--System C
--System D
Internal
-Process A
-Process B

Not too dissimilar to GitLab, but hugely amplified, we want to pull multiple projects, not just our Hugo repo.

The following is our .gitlab-ci.yml:

image: registry.gitlab.com/pages/hugo:latest
variables:
 GIT_SUBMODULE_STRATEGY: recursive
grab-docs:
 tags:
   - docker
 image:
   name: ruby:2.7.5-slim
 script:
   - cd ${CI_PROJECT_DIR}
   - gem install gitlab
   - ruby grab_docs.rb
 artifacts:
   untracked: true

test:lint:
 tags:
   - docker
 image:
   entrypoint: [""]
   name: davidanson/markdownlint-cli2
 script:
   - cp $MARKDOWN_LINT_CONFIG ./.markdownlint-cli2.jsonc
   - markdownlint-cli2 "content/**/*.md"
 needs:
   - grab-docs

test:
 tags:
   - docker
 script:
   - apk add --update --no-cache git
   - hugo
 except:
   - master
 needs:
   - test:lint

pages:
 tags:
   - docker
 script:
   - apk add --update --no-cache git
   - hugo
 artifacts:
   paths:
     - public
 only:
   - master
 needs:
   - grab-docs
   - test:lint

The first grab-docs step runs a custom Ruby script to:

  • interrogate our GitLab instance, looping through all groups and projects
  • grab the README.md and /doc folder
  • add frontmatter for last update date and link to the repo
  • update and fix all markdown paths
#!/usr/bin/env ruby

require 'fileutils'
require 'gitlab'

$api = Gitlab.client(endpoint: ENV['PRODUCTION_API_ENDPOINT'], private_token: ENV['GITLAB_API_TOKEN'].to_s)
$projects = $api.projects(per_page: 50)

def grab_files(project)
 file = $api.file_contents(project.id, 'README.md')
 return unless file&.start_with?('

We want to hear from you

Enjoyed reading this blog post or have questions or feedback? Share your thoughts by creating a new topic in the GitLab community forum. Share your feedback

Ready to get started?

See what your team could do with a unified DevSecOps Platform.

Get free trial

Find out which plan works best for your team

Learn about pricing

Learn about what GitLab can do for your team

Talk to an expert