What are Standard Reports & My Reports

What are Standard Reports & My Reports

SQL Guru's Reports Catalog module consists of two types of reports: Standard Reports and My Reports. This article explains the differences between these two report types and their uses.


Standard Reports

Standard Reports are pre-defined reports that come with the SQL Guru solution. These default reports have been created by our expert team, who have identified the reports that most businesses generate for compliance and monitoring purposes. There are hundreds of Standard Reports in SQL Guru, organized by categories to facilitate easy access.

Examples of Standard Reports

Here are some examples of the types of Standard Reports available in SQL Guru, particularly under the Master Data Management category:

  • Item Master
  • Employee Master
  • Reports on Active and Inactive Users and Roles
  • Report on Users and Roles Login Details
  • Login History
  • Supplier Master Data
  • User and Roles Analysis Report

These reports can be accessed and viewed with just a few clicks, providing comprehensive insights into various aspects of your business operations.


My Reports

My Reports, on the other hand, are custom reports that you can create by writing and saving your own queries. As every organization's needs are ever-evolving, the My Reports feature allows you to tailor reports to your specific requirements.

Creating and Using My Reports

Once you write and save a query in My Reports, you can generate the report with a single click whenever needed. This feature saves time and effort, as you do not have to rewrite the query each time you need the report.

For detailed instructions on how to create a My Report, refer to the How to Create My Reports article in the knowledge base.

Benefits of Standard Reports and My Reports

Standard Reports

  • Ready-to-Use: Immediate access to a wide range of reports without the need for customization.
  • Expertly Crafted: Developed by experts to meet common business compliance and monitoring needs.
  • Organized by Categories: Easily find the report you need based on categories.

My Reports

  • Customizable: Tailor reports to fit your specific business requirements.
  • Time-Saving: Write the query once, save it, and generate the report with a single click in the future.
  • Flexible: Adapt to changing business needs by creating new custom reports as required.

By understanding and utilizing both Standard Reports and My Reports in SQL Guru, you can ensure that your business has access to the necessary insights and data to make informed decisions and maintain compliance.  For further assistance, contact support@1trooper.co


    • Related Articles

    • How to Generate Role License Usage Report and Privilege License Usage Report

      License reports are essential for various business purposes such as compliance management, cost management, and resource allocation. SQL Guru's License Management module allows you to generate different types of license reports, including User - Role ...
    • How to Create My Reports

      Generating reports by writing long queries each time can be cumbersome and time-consuming. SQL Guru's My Reports module streamlines this process by allowing you to save report queries, enabling you to generate reports with a single click in the ...
    • How to Upload the Catalog File in the Oracle Cloud Instance

      Prior to or subsequent to the installation of the SQL Guru tool, it is imperative to upload the catalog file to facilitate further querying and data access within the Oracle system. The ensuing steps delineate the process. You can find the catalog ...
    • Why Monitoring License Usage in Oracle Cloud is Essential for Your Business

      In the evolving landscape of cloud computing, effective license management has become a cornerstone of successful business operations. Oracle Cloud, with its extensive range of services and applications, is a powerful tool for businesses. However, to ...