US

Aggregated Reports for ApexSQL

  • decor icon

    Intelligent data sorting

  • decor icon

    Optimized SQL audit

  • decor icon

    Advanced reporting

Project
overview

Regular SQL Server audit is a necessary procedure to keep your system secure, flawless in operation, and high-performance. For such purposes, we previously developed ApexSQL Audit which, however, still lacked a convenient data aggregation feature to make comprehensive reports. That’s why the decision was made to create an SQL audit-compatible Aggregated Reports feature.

Client
information

ApexSQL is a top-tier provider of “killer tools for SQL Server”. The renowned SQL-focused company is partners with a number of industry giants (Microsoft, Intel, Bank of America, NASA, etc.) and is owned by Quest – an even more renowned software and IT services provider. This particular client knew precisely what it required, making the cooperation experience smooth and efficient.

client logo
Project overview image

Business
challenge

There is a wide scope of businesses and market players that require fail-proof, reliable online database management. And while the Microsoft SQL Server provides the essential database management powers, its default capabilities can be significantly improved with extra features to give businesses and users more security, flexibility, and automation.

Technical
challenges

The main task was to program and deploy a new functional feature for the existing ApexSQL Audit software tool. We set out to create a programmed solution that takes 2D audit data tables generated by ApexSQL Audit and displays it in the form of a comprehensive chat, also allowing for extensive filtering of data.

Solution
delivered

Aggregated Reports is a piece of software that makes sorting and further analysis of data gathered by ApexSQL Audit ultimately convenient and easy to grasp. The data can be filtered by value, automatically grouped in columns by relevance, displayed either in the ApexSQL Audit GUI or in the form of an exported PDF file. The COUNT function allows grouping data by columns in a smart way. The advanced mode also helps query the data generated during the audit and use Boolean expressions.

Solution delivered img

Claim a 30-minute talk with our experts and get a step-by-step strategy for your project for free!

Key features

key features image
  • Chart Forms

    In order to not miss out on all the little things in data reports, clear data visualization is required, which is provided by intuitive chart forms that can be used at will.

  • COUNT Function

    To speed up data grouping and sorting processes, COUNT enables automated, intelligent data grouping at the push of a button.

  • Data Export

    Exporting data to PDF files that are supported by practically all browsers and simply look neat, there won’t be any problems sharing the completed reports with other users.

VALUE TO OUR CLIENT

  • SQL audit optimization

    The whole SQL audit routine becomes much more logical and less cumbersome with data conveniently aggregated into reports that can be exported as common PDF documents.

  • Intelligent data sorting

    The COUNT feature helps to automatically group data by the specified value, setting all columns in order without any necessary manual input.

  • Advanced reporting

    Enabling the advanced mode, an expert can query audited data and process it based on complex Boolean expressions.

Our Tech Stack

  • C# icon C#
  • Visual Studio icon Visual Studio
  • .NET/ASP.NET icon .NET/ASP.NET

Trusted partner who delivers on scope, on time and on budget

contact us

Name

Email

Phone

Become a customer

Message

Thank you! We will contact you soon

To top of page
To top of page