Home

Get User and Organization Reports 📈 with GraphQL

The tool will help you get the details of User, User activity and Organization details. Using GraphQL queries, the application access the GitHub's GraphQL API Endpoints to create user and organization reports. The only input required is the name of the GitHub Organization. The Organization name is included with GraphQL queries as part of the request to generate the response for the reports.

We have 3 queries to fetch User, User activity and Organization data. Based on the response received, these queries are sent in a single request to generate the report.

For ease of viewing and analyzing, the JSON response is formatted into excel data and attached to separate excel sheets.

Data Populated in the Report 📈

User

• email
• company
• login
• Last Active Contribution. Captured Data is Time and date the last time user has made any contribution

User Activity

• login
• last active contribution
• last contributed repository

Organization Details

• email
• login

Prerequisites

• GitHub Account & PAT Token

Required Inputs

• GitHub Organization Name
• An Existing File-path to save the reports Ex: "D:\reports"
• GitHub Username
• GitHub PAT

GitHub username and PAT are required for GraphQL to authenticate with GitHub and fetch the response.

Download and run the tool

1. Download the tool from here. Extract the binaries from report-builder.rar

2. Run the exe tool and provide the required inputs as shown below.

   

3. Check the report in your output directory