Dynatrace USQL is a powerful query language that allows you to analyze your Dynatrace data in depth. It is a SQL-like language that can be used to query data from all of the different Dynatrace tables, including Real User Monitoring (RUM) data, synthetic monitoring data, and infrastructure monitoring data.

Here are some basic tutorials for Dynatrace USQL:

Getting started

To get started with USQL, you will need to create a USQL script. You can do this in the Dynatrace UI or in a text editor.

To create a USQL script in the Dynatrace UI:

1. Go to Settings > Monitoring > USQL > Create new script.
2. Enter a name for your script and click Create.
3. Paste your USQL code into the script editor.
4. Click Run to execute your script.

To create a USQL script in a text editor:

1. Create a new text file and save it with a .usql extension.
2. Paste your USQL code into the text file.
3. Save the text file.

Once you have created your USQL script, you can run it using the Dynatrace UI or the Dynatrace CLI.

Running USQL scripts

To run a USQL script in the Dynatrace UI:

1. Go to Settings > Monitoring > USQL > My scripts.
2. Click the name of the script that you want to run.
3. Click Run.

To run a USQL script using the Dynatrace CLI:

1. Open a terminal window.
2. Navigate to the directory where your USQL script is located.
3. Run the following command:

dt usql <script_name.usql>

	-- This will return all columns and rows from your user session data.
	SELECT * FROM usersession
	SELECT userId, userAction.name, duration FROM usersession
	-- Filtering Data: You can also filter data by using the WHERE clause.
	SELECT * FROM usersession WHERE userAction.name = 'Login'
	-- Sorting Data
	-- You can order your results using the ORDER BY clause. For instance:
	SELECT * FROM usersession ORDER BY startTime DESC
	-- Aggregate Functions
	-- USQL also supports aggregate functions, such as COUNT, AVG, SUM, MIN, and MAX. For instance, to count the number of user sessions:
	SELECT COUNT(*) FROM usersession
	-- Limiting Results
	-- You can also limit the number of rows returned by your query by using the LIMIT clause:
	SELECT * FROM usersession LIMIT 10
	-- Using Parameters
	-- Parameters can be used within USQL queries to create dynamic and interactive dashboards.
	SELECT * FROM usersession WHERE application = '{Application}'
	-- Get the top 10 slowest services by response time
	SELECT service, AVG(useraction.serverTime) AS "Server time"
	FROM usersession
	GROUP BY service
	ORDER BY "Server time" DESC
	LIMIT 10;
	-- Get the average page load time for each country
	SELECT country, AVG(useraction.pageLoadTime) AS "Page load time"
	FROM usersession
	GROUP BY country
	ORDER BY "Page load time" DESC;
	-- Get the number of errors for each service
	SELECT service, COUNT(useraction.error) AS "Errors"
	FROM usersession
	GROUP BY service
	ORDER BY "Errors" DESC;

view raw USQL.mysql hosted with by GitHub

Rajesh Kumar

I’m a DevOps/SRE/DevSecOps/Cloud Expert passionate about sharing knowledge and experiences. I am working at Cotocus. I blog tech insights at DevOps School, travel stories at Holiday Landmark, stock market tips at Stocks Mantra, health and fitness guidance at My Medic Plus, product reviews at I reviewed , and SEO strategies at Wizbrand. 

Please find my social handles as below;

Rajesh Kumar Personal Website
Rajesh Kumar at YOUTUBE
Rajesh Kumar at INSTAGRAM
Rajesh Kumar at X
Rajesh Kumar at FACEBOOK
Rajesh Kumar at LINKEDIN
Rajesh Kumar at PINTEREST
Rajesh Kumar at QUORA
Rajesh Kumar at WIZBRAND