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.
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 |
|---|---|
 |
 |
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 |
|---|---|
 |
 |
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 | |
|---|---|
 |
 |
To use the Infra-Management Console, you will need to restore the DBAdmin.bak file to your Microsoft SQL Server. Once the database is restored, Replace your server's connection string in 'MSUISApi/web.config' file's '< ConnectionStrings >'. Then you can then deploy the front-end and API to your server.