Back

Community Coding

I wanted to share how my recent experience in community coding helped me improve what I was doing internally At Agile IT weve been making big inve...

3 min read
Published on Nov 23, 2018
Community Coding

I wanted to share how my recent experience in community coding helped me improve what I was doing internally.  At Agile IT, we’ve been making big investments in building PowerShell scripts, Azure DevOPS processes, and improving our automation processes to make our service delivery even more awesome.  In doing so, we’ve been leveraging many components that are freely available via GitHub.

Recently, we created a script that allows for quick discovery of all Active Directory, Azure Active Directory groups (in this case we were looking for Office 365 groups), and Microsoft Teams (it’s a cool new project and service, but we’ll talk about that another time (or just call us)). We wanted the export of all this information into a spreadsheet, but the only option we had was to put it into CSV and then merging that together later when we have another script running where Excel is installed.  It’s huge pain and while there are many workarounds, there were none we liked (nor anyone else).

By the power of Google and GitHub, we found a cool module called, “ImportExcel”, which is a project led by Doug Finke (Thanks Doug!).  It does everything we need and way more.  And you DON’T need to have Excel installed locally to use it.  The project is managed within GitHub and provides lots of great examples, but none that fit what we wanted to do.  However, with some playing around, we were able to get it to work.

The results worked great and we “thought” we were done.

To “give back”, I decided to take what we learned and make an example.  Using GitHub, I was able to perform a “Pull request” which allows me to add a piece of my code into a branch with comments and await approval.  I thought I was done, and it was awesome.  However, that wasn’t the case.

Within an hour, Doug provided a comment back and telling me “thank you”, but I had some code in there that wasn’t required.  “Say what?”

After taking his comments and refactoring a few things, the code went down in size and it removed the need or some variables I was using.  Afterwards, I updated the code in GitHub and it was later accepted and merged into the production branch.

First off, I was super pumped that I was able to contribute to something I found very useful.  But then I went back and updated our own PowerShell script that was using it.  Not only was it cleaner now, but also ran faster!

Thus, contributing to the community code that I was leveraging wasn’t just a good feeling, it made my work better.

At Agile IT, we’re looking how we can contribute more to what we’re using internally, but also looking at our upcoming release of a new PowerShell product and how we can combine that with public community coding.

Conrad Agramont is CEO of Agile IT

This post has matured and its content may no longer be relevant beyond historical reference. To see the most current information on a given topic, click on the associated category or tag.

Related Posts

Azure Migration Made Easy Tools Automation and Best Practices

Azure Migration Made Easy: Tools, Automation, and Best Practices for a Smooth Cloud Transition

Simplify your Azure migration with the right tools and automation. Explore Azure Migrate, Site Recovery, DevOps, and third-party solutions for an efficient cloud transition.

May 26, 2025
7 min read
How to Enable Cross-Cloud Collaboration Between GCC High and Office 365

How to Connect GCC High and Office 365 for Cross-Cloud Collaboration

Learn how to securely connect GCC High and Office 365 for cross-cloud collaboration. Explore supported features, limitations, and compliance best practices.

May 22, 2025
6 min read
Key Controls for Achieving CMMC Level 2

Key Controls for Achieving CMMC Level 2 Compliance

Discover the key security controls required for CMMC Level 2 compliance. Learn how to implement NIST 800-171 practices to protect Controlled Unclassified Information (CUI).

May 21, 2025
7 min read
Understanding CMMC Enclaves: A Guide for DoD Contractors

CMMC Enclaves: Your Comprehensive Guide to Protecting CUI

Discover how CMMC enclaves can streamline compliance and bolster security by isolating Controlled Unclassified Information (CUI) within a secure environment.

May 21, 2025
7 min read
How MSPs, RPOs, and C3PAOs Help Organizations Achieve CMMC Compliance

How MSPs Help Organizations Achieve CMMC Compliance

MSPs, RPOs, and C3PAOs play a crucial role in CMMC compliance. Learn how to choose the right consultant, third-party auditor, or provider to meet CMMC certification requirements.

May 20, 2025
8 min read
CMMC Compliance Requirements for Level 1 Level 2 and Level 3

CMMC Compliance Requirements for Level 1 Level 2 and Level 3

CMMC certification requires different cybersecurity controls at each level. Learn the key requirements for Level 1, Level 2, and Level 3 compliance and how they align with NIST 800-171.

May 16, 2025
5 min read

Ready to Secure and Defend Your Data
So Your Business Can Thrive?

Fill out the form to see how we can protect your data and help your business grow.

Loading...
Secure. Defend. Thrive.

Let's start a conversation

Discover more about Agile IT's range of services by reaching out.

Don't want to wait for us to get back to you?

Schedule a Free Consultation

Location

Agile IT Headquarters
4660 La Jolla Village Drive #100
San Diego, CA 92122

Secure. Defend. Thrive.

Don't want to wait for us to get back to you?

Discover more about Agile IT's range of services by reaching out

Schedule a Free Consultation