Infra-Management Console

The Infra-Management Console is a management system for on-premise Microsoft SQL Server. The front-end is developed in AngularJS and the API is developed in C#.

This repository contains the following files and folders:

MSUIS View : This folder contains the front-end of the project.

MSUISApi : This folder contains the API required for the project.

DBAdmin.bak : This file is a Microsoft SQL Server backup file that contains all of the stored procedures used to fetch data from the SQL Server.

Identity & Access Management

The Infra-Management Console includes features for managing user accounts and logins for MSSQL, table permissions, database permissions, storage permissions, and generating permission reports.

User List Add User

Table Permission Permission Report

Backup Management

The Infra-Management Console allows administrators to schedule backups on a weekly or daily basis, restore backup files, and manage backup retention policies.

Auto Backup Restore Backup

Analytics

The Infra-Management Console also includes analytics features, allowing administrators to review the analytics of the last executed queries with different types of filters. This feature can provide valuable insights into system performance and usage patterns.

Query Analytics

Credential Analytics