Nalin Perera

Personal web site

Maintenance System and Asset Register

About MSAR

The main purpose of the Maintenance System and Asset Register (MSAR) is to record the important details of the Assets which are supplied, installed or constructed for the project. Assets include:

  • Buildings
  • Plant and equipment &
  • Other facilities

Maintenance schedule component is to track and notify the users about the maintenance tasks which need to be performed on a daily, weekly, monthly and yearly basis. Maintenance based on machine running hours is also handled.

MSAR Software is developed to maintain the above assets. In addition to the above, spare part details also can be maintained.

Technical Details

The software is developed using the Microsoft Visual Studio (.Net Framework 4.5) and the database on Microsoft SQL Server 2012 (Express Edition). The database will be designed to accommodate the unique attributes of certain assets such as Water Pumps and Valves. The assets will be linked according to a hierarchical structure. Thereby at each level the value of the assets can be evaluated.

Separate application services are developed to produce routine reports. The service will continue to run in the background until the server is switched off. The services can be configured to save reports in the local disk, upload to cloud services (Google Drive) or Email to specific users.

Design Architecture

The system composes two different components:

  • Client End
  • Database

The application is designed based on the 3-tier architecture where the business logic is performed at the database on Stored Procedures. This simplifies the client operations and makes the system more scalable. This design helps to connect many users simultaneously to the system, while maintaining security.

For multi user access, client is required to purchase license for Microsoft SQL Server 2012 database along with Hardware Key for each user.

Security

Three security groups are available to protect the data:

  1. Engineer
  2. Technician
  3. Accountant

Each security level restricts the system tasks which can be performed by the end users.

System Requirements

MSAR is developed in a Windows Platform. Minimum hardware and software requirements:

Hardware

  • Intel Core i3 Processor
  • 4GB RAM
  • 1 TB Hard Disk
  • 18.5 inch Monitor

Software

  • Microsoft Windows 7 (64 bit)
  • Microsoft .Net Framework 4.5
  • SQL Server 2012 (Express Edition)
  • Adobe Reader X

Screenshots of the MSAR Application

Asset Details

View O&M Manual

Due Maintenance Tasks

Spare Part Details

Spare Part for Asset Link

Maintenance Schedule

Reports Menu

Plant Cost Report

Maintenance Tasks Due - Report

Spare Parts in Stock - Report

Option to import monthly machine running hours from SCADA generated file