 Hi and welcome to this video tutorial on how to use custom sql queries in true set console. Custom sql query section is common in most of the database games. We are using Oracle Enterprise Database Game for creating this video. After specifying the environment configuration details, let me directly move on to the custom sql query section and see how to add custom sql queries in true set console. Click add to enter custom sql query. Enter a user different query name. This query helps you to know the name of the users whose expiry date is less than 7 days. Specify the query collection time. Select this option to display the query result as an orientation on the number of records metric. Similarly, we will add one more query to set a threshold for the value attribute to identify an increase in the number of inactive sessions in the database. This query helps you to set a threshold for the value attribute to identify an increase in the number of inactive sessions. Click OK and save the policy. To verify the configuration, go to the monitoring tab and click Devices. To see the results of the configured policy, you can see the results of both the queries. This attribute displays the execution status of the custom sql query. This attribute displays the overall response time of the query. Here you can see the result of the query 1. You can see that there are 34 users whose expiry date is less than 7 days. Let us look at the annotations. Here in the annotations, it lists all the users whose expiry date is less than 7 days. You can also see the names of the users. Let us look at the output of the query 2. Here, these are the number of inactive sessions in the database. For more details, log on to docs.vmc.com. Thanks for watching this video.