---
title: "How to check JSU DC usage"
canonical: "https://support.appfire.com/space/SUPPORT/912294344/How%20to%20check%20JSU%20DC%20usage"
format: markdown
---
This guide provides detailed instructions on how to check JSU (Jira Suite Utilities) usage in active workflows by querying a database. This method is necessary as the JSU app does not support this functionality through its user interface.

## \uD83D\uDCD8 Instructions

Below are the steps to identify and analyze JSU usage through direct database queries.

1. **Identify Workflows with JSU Conditions, Validators, or Post-Functions**  
Access your database management tool that connects to your Jira database.  
Execute the following SQL query to list all workflows that contain JSU components. This query checks the `descriptor` field in the `jiraworkflows` table for JSU references:
2. **Determine the Projects Associated with These Workflows**  
To understand which projects use these workflows, run the following SQL query. This query provides details about the project and its associated workflow scheme:
3. **Extract Information on JSU Usage in Workflow Transitions (Optional)**  
If you need to dive deeper and find out in which transitions within a workflow where JSU is used, this requires parsing the XML stored in the `descriptor` field of each relevant workflow. This process involves:
  - Manually extracting the XML content from the `descriptor` field.
  - XQuery or XPath can be used to parse the XML and identify elements related to JSU usage.   
**Note: **Depending on your database capabilities, this might require additional XML processing tools or scripts.

> ℹ️ **TIPS:**
> ℹ️ 
> ℹ️ - **Backup Before Querying**: Always ensure that you have a recent database backup before running these queries, especially in a production environment.
> ℹ️ - **Optimize Performance**: These queries can be resource-intensive. Consider running them during off-peak hours to minimize the impact on your system.
> ℹ️ - **Regular Updates**: Keep your database queries updated with any changes in your Jira instance or JSU app updates that might alter the data structure.
> ℹ️ - **Security Considerations**: Limit access to these queries and their results, as they can reveal sensitive information about your workflows and projects.

## \uD83D\uDCCB Related articles



> Macro (contentbylabel)