AI System Administrator (AISA)

An AI-powered assistant for Windows Server, IIS, SQL Server, and ASP.NET administrators.

Comment

AISA – AI System Administrator

Inspiration

Managing Windows Server environments often requires switching between IIS logs, Windows Event Viewer, SQL Server Management Studio, and monitoring tools. Diagnosing issues can be time-consuming, especially when dealing with thousands of log entries.

We wanted to build an AI-powered assistant that helps administrators understand their infrastructure faster by transforming technical logs into clear insights and actionable recommendations.

What it does

AISA is an AI-powered operations assistant for Windows Server environments.

Current features include:

  • Upload and analyze IIS log files
  • Detect HTTP errors such as 404 and 500
  • Identify slow requests
  • Highlight top URLs and client IP addresses
  • Generate AI summaries of server activity
  • Answer natural-language questions about uploaded logs
  • Visualize traffic and errors through charts

The long-term vision includes SQL Server health monitoring, Windows Event Log analysis, SSL certificate monitoring, and proactive recommendations.

How we built it

The application uses:

  • ASP.NET Core 8 Web API
  • Clean Architecture
  • Dapper
  • SQL Server 2019
  • JWT Authentication
  • Serilog
  • Chart.js
  • Bootstrap
  • OpenAI API

The backend parses IIS logs into structured data before sending only relevant statistics to the AI model. This reduces token usage while improving response quality.

Challenges

Some of the biggest challenges included:

  • Efficiently parsing large IIS log files
  • Handling multiple IIS log formats
  • Reducing AI token usage
  • Generating reliable summaries
  • Presenting complex server information in a simple dashboard

What we learned

This project reinforced that AI is most effective when combined with structured system data rather than raw logs.

We also learned how important prompt design is for generating actionable recommendations instead of generic explanations.

What's next

Future versions will support:

  • SQL Server monitoring
  • Windows Event Log analysis
  • Application Pool monitoring
  • SSL certificate health
  • Multi-server dashboards
  • Scheduled AI health reports
  • Predictive issue detection

The goal is to evolve AISA into a complete AI Operations Center for Windows Server environments.

Built With

Share this project:

Updates