XIA Configuration
SQL Server Audit & Reporting Tool
Software to help you audit the configuration of your SQL servers
Use our SQL server reporting tool XIA Configuration to provide visibility into the configuration of your SQL servers. Execute reports to retrieve settings from your SQL servers and perform audits such as checking databases, security, or host information.
-
In-Depth Reporting. Run reports to get the data you need to audit your SQL servers
-
Security. Harden your SQL servers by checking logins and host information
-
Change Tracking. Track changes to your SQL server configuration
XIA Configuration has a non-intrusive architecture with agentless data collection.
SQL Server Reporting
Use XIA Configuration to run reports and retrieve data from all your SQL servers and databases at once.
View some example reports below.
Example - SQL Availability Groups Report
Use the SQL Availability Groups summary report included with XIA Configuration to audit the availability groups on your SQL servers.
Screenshot of the SQL Availability Groups Summary report cover
Example - SQL Databases Detailed Summary
Use this report to view a detailed summary of your SQL databases. Modify the report to add any additional data you require.
Screenshot of the SQL Databases Detailed Summary report in the XIA Configuration web interface
Example - SQL Instance Database Tables Summary
Use this report to determine which database tables you have on SQL instances in your environments.
Screenshot of the SQL Instance Database Tables Summary report in the XIA Configuration web interface
Export Reports to CSV
Export reports to CSV and open them in other tools such as Microsoft Excel for further analysis.
Screenshot of the SQL Instance Database Tables Summary report exported to CSV
SQL Reports included with XIA Configuration
Below are the built-in SQL reports included with XIA Configuration.
SQL Reports
- SQL Availability Groups Summary
- SQL Database Snapshots Summary
- SQL Databases Detailed Summary
- SQL Databases Summary
- SQL Instance Database Assemblies Summary
- SQL Instance Database Tables Summary
- SQL Instance Logins Summary
- SQL Instance Recently Created Databases
- SQL Instance Recently Created Logins
- SQL Instance Server Roles Summary
- SQL Instance Version and Edition Breakdown
- SQL Instances Detailed Summary
- SQL Instances Host Information Summary
- SQL Instances Recently Created
- SQL Instances Summary
- SQL Server Agent Jobs Summary
Create and modify reports to get the data you need for your specific requirements.
Find out more about the reporting feature.
For more information about SQL, please view the SQL page.
Try our SQL server audit & reporting tool for free