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 📈

Below are the details populated in the report.

User	User Activity	Organization
email company login last active contribution	login last active contribution last contributed repository	email login

Prerequisites

• GitHub Account & PAT Token are required for GraphQL to authenticate with GitHub and fetch the response

Required Inputs

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

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.