Overview
This page explains the "Report Builder" (custom report feature) in the Josys admin console.
With custom reports, you can freely select only the necessary items from various information stored in Josys—such as users, apps, licenses, IT devices, and access—to create your own unique list reports. Unlike the pre-configured "Reports" menu (such as reports by department or remaining app licenses), this feature allows administrators to combine their own items, filter conditions, and aggregation axes to create reports.
Intended Audience
- IT administrators who use the Josys admin console
- Personnel who regularly create and share reports on IT assets, licenses, and access status for internal use
What You Can Do
With the custom report feature (Report Builder), you can mainly perform the following tasks:
Freely Combine Items
You can create reports by selecting the necessary items from the following six categories:
- Users (Name, Departments, Work Locations, Job Title, Status, Start/End Date, Assigned IT Devices, etc.)
- Apps (App Name, App Type, App Category, Integration Status, Risk Level, etc.)
- Discovered Apps (Category, Risk Level, Status, etc., of apps detected by Josys, such as Shadow IT)
- Licenses (Plan Name, Total Licenses, Assigned/Unassigned Licenses, Unutilized Accounts, etc.)
- App Accounts (App Account ID, Status, Last Used Date, etc.)
- Access (MFA Status, SSO Status, Privileged Accounts, etc.)
Reorder and Delete
You can drag selected items to change their display order or delete unnecessary items later.
Filtering
You can filter data for items added to the report using conditions such as "Equals," "Any of," "None of," "Is Null," or "Is Not Null."
Aggregation (Grouping)
You can switch to a summary view that aggregates counts using any of the selected items as an axis (e.g., aggregating the number of users by department).
Preview Confirmation
You can preview the report you are creating on the right side of the screen in real time, and you can also reorder columns and page through the data.
Save and Reuse
You can save created reports as templates with a name and description, and recall them later for re-editing or re-checking.
Duplicate and Delete
Saved reports can be duplicated or deleted from the list screen.
CSV Export
Created reports can be downloaded in CSV format. The download is executed as an asynchronous background process, and you can check the progress and completion status on the "Scheduled Tasks" screen (CSV Downloads).
Steps
1. Open the Report Builder
Click Report Builder from the left menu of the admin console.
If you have not created any reports yet, "No reports created" will be displayed. Click Create from Scratch.
2. Select the Items You Want to Display
From "Manage Fields" on the left side of the screen, expand the categories (Users / Apps / Discovered Apps / Licenses / App Accounts / Access) and click the + icon for the items you want to include in the report. Selected items will be added to "Selected Fields" in the center and reflected as columns in the "Preview" on the right.
- Reordering items: Drag the left edge (:: icon) of the selected field.
- Deleting items: Click the "-" icon on the right side of the selected field.
3. Set Filters as Needed
Click Filter at the top right of the preview, and select the items, operators, and values you want to filter by from "Add Filter." Be sure to click Apply after setting the values (if you close the panel before applying, the settings will be discarded).
4. Group By (Aggregate) as Needed
Select any of the already selected items from Group By at the top right of the preview to switch to a summary view that aggregates counts based on that item. To return to the detailed list, select "None."
Here is an example when "Status" is selected in the filter:
Since the status of all data was "Active," they are aggregated into a single "Active" row, and the total count of the aggregated records is displayed.
5. Check Data in Preview
Click the "Preview Data" button to display the actual data. You can toggle between ascending and descending order using the sorting icons in the column headers, and you can also page through the data or change the number of items displayed per page at the bottom of the screen.
6. Edit Report Name and Description
Click the pencil icon next to the report name at the top left of the screen to edit the report name and description. We recommend giving it an easily recognizable name and description so you can find it easily later.
7. Save the Report
Click Save Template at the top right of the screen, confirm the report name and description, and click Save. Saved reports can be opened and re-edited at any time from the "Report Builder" list screen.
8. Download as CSV
Click the download icon (↓) at the top right of the screen to start downloading the report as a CSV. The process may take some time, and you can check the progress and completion status as "CSV Downloads" on the Scheduled Tasks screen in the left menu.
9. Manage Saved Reports
Hovering over the target report row on the "Report Builder" list screen displays the "..." menu, where you can select Duplicate Report or Delete.
Examples of Report Utilization
- Extracting Users Without MFA/SSO Settings: Select "MFA Status" and "SSO Status" from the Access category, filter for users who have not set them up, and use this to prioritize security measures.
- Discovered Apps Risk List: Select "Application," "Category," "Risk Level," and "Status" from the Discovered Apps category, and filter/aggregate by risk level to visualize shadow IT apps that require action.
- Checking Assigned Devices for Offboarding Employees: Combine "Name," "Status," "End Date," and "Assigned IT Devices" from the Users category to prevent missing device returns associated with offboarding employees.
- Aggregating App Usage by Department: Select items from the Apps category combined with the user's "Departments," and specify "Departments" as the grouping item to create a summary of app usage counts for each department.
The above are just examples. Please combine the necessary items, filters, and aggregation axes according to your actual business needs.