XIA Configuration Server

SQL Server Reporting Tool

XIA Configuration includes a comprehensive SQL reporting on the configuration of SQL Server and Azure SQL, giving DBAs, sysadmins, and auditors clear, audit‑ready visibility across the entire SQL estate.

The Microsoft SQL Server logo.

SQL Server and Azure SQL Database Reports

XIA Configuration Server's powerful reporting engine includes the following built-in reports for SQL Server and Azure SQL:

Built-In SQL Instance Reports

XIA Configuration Server includes SQL Server support which includes the following built-in instance related reports :

  • SQL Availability Groups Summary
  • SQL Instance Ad Hoc Distributed Queries Summary
  • SQL Instance CLR Integration Summary
  • SQL Instance Cross-Database Ownership Chaining Summary
  • SQL Instance Login Auditing Summary
  • SQL Instance Logins Summary
  • SQL Instance Memory Settings Summary
  • SQL Instance Processor Settings Summary
  • SQL Instance Recently Created Logins
  • SQL Instance Security Summary
  • SQL Instance Server Permissions Summary
  • SQL Instance Server Roles Summary
  • SQL Instance Version and Edition Breakdown
  • SQL Instance xp_cmdshell Summary
  • SQL Instances Detailed Summary
  • SQL Instance Host Information Summary
  • SQL Instance Host Installation Path Summary
  • SQL Instance Named Pipes Protocol Configuration Summary
  • SQL Instance TCP Protocol Configuration Summary
  • SQL Instances Recently Created
  • SQL Instances Summary
  • SQL Server Agent Jobs Summary

Built-In SQL Database Reports

XIA Configuration Server includes SQL Databases support which includes the following built-in reports :

  • SQL Database Assemblies Summary
  • SQL Database Backup Status Summary
  • SQL Database File Growth Summary
  • SQL Database File Location Summary
  • SQL Database Recovery Model Summary
  • SQL Database Snapshots Summary
  • SQL Database Tables Summary
  • SQL Database Unlimited Autogrowth Audit
  • SQL Databases Detailed Summary
  • SQL Databases Summary
  • SQL Recently Created Databases

Built-In Azure SQL Reports

XIA Configuration Server also includes Azure tenant support which includes the following built-in reports relating to Azure SQL hosting:

  • Azure SQL Databases Detailed Summary
  • Azure SQL Databases Summary
  • Azure SQL Server Firewall Rules
  • Azure SQL Servers Summary