Home > Products > IT Inventory System > Windows Version

 

IT Inventory System for Windows v2.0.0

In view of the lack of Inventory System specifically for the IT industry in the market, Algorithm System Consultant's IT Inventory System is act as an IT warehousing system that stores all information about software and hardware installed in user's PC. For ease of use, the system was designed in an Excel-like user interface. The design is very close to an Excel interface and of course, in a structured and systematic way! More functions will be added to the system in the future. However, most of the basic functions are developed and any comments are all welcome.

IT Inventory System is now release to the public and offer to download for FREE now! It is free of charge for both commercial and personal use and are not time restricted. Free version comes with Microsoft® Access database while Microsoft® SQL Server version is available in Full version, operation efficiency was significantly enhanced. For bugs report, please email to bugs@algorithm.com.hk.

 

Features

  • Company Master
  • Department Master
  • Staff Details
  • Software Master
  • Hardware Master
  • User Login Maintenance
  • Software List
  • Hardware List
  • IP List
  • Software Key
  • Find and Filter Function
  • Export to Excel
  • Integrated with IT Inventory for Android
  • Support Both Microsoft® Access and SQL Server Database
  • Multilingual Support (English, Traditional Chinese and Simplified Chinese)
  • Excel-like Interface
  • Unlimited Software, Hardware and IP Tables
  • Backup Services for disaster recovery

 

 

 

 

Android version now available!

 

Login Window

 

Main Menu

This is the place where you can find most of the major functionalities of the IT Inventory System.

 

Company Master

Function:
This is the place to input information for all companies in an organization.

Description:
All cells in gray color are read-only. For e.g. in this form, Company ID is not allowed to change because it is an important key field in the system. New company can be added in the last row of the window. Press [Save] button to confirm changes or [Delete] button to delete selected row.

 

Department Master

Function:
This form is used to store department information in a company.

Description:
In this screen, select the Company ID that belongs to that department, and then enter Department ID and Name to complete the process. Department ID/Name can be duplicated provided that Company ID is not the same, since different companies can have the same department within an organization. This is allowed in the system.

 

Staff Details

Function:
This is used to enter staff information.

Description:
Before create any hardware/software list in this system, staffs must be created first from this screen. Select the Company and Department ID of this staff and enter other staff information. After Company ID has been selected, only those departments belongs to that company will be listed in the Department ID combo box as shown.
Software Master

Function:
This form is used to store the software information.

Description:
All software names should be entered in this screen in order to create the software list. The legends at the bottom of the screen (Combine with Paper License, OEM Version, Box Set) indicate the purchasing option of the respective softwares. This legend will also appear in the "Software List" as in the next section. Colors can be customized in the "Options" menu. Press the [Software List] button to go to the "Software List" screen directly.

Display Position: This is used to sort the software in [Software List], by default, it will be sorted in ascending order of Software Name if "Display Position" not entered.

License Qty: Quantity purchased from software vendor.

Used Qty: In gray color and auto-calculated by the system for which total used quantity were captured in [Software List].

Remain Qty: Calculated by purchased license quantity deduct used quantity, this help IT Department to control the number of licensed software installed in user's computer. All negative Remain Qty was shown in red color.

 

Software List

Function:
This is used to store the information about the software installed in user's PC.

Description:
This is the core part of the IT Inventory System.  All software installed in user’s PC should be recorded in this screen.  Columns with color in pink indicate software comes with Paper License; color in yellow indicates OEM Version software; color in green indicates this is a Box Set software.  Colors can be customized in the “Options” menu.  The total number of software in this system can be infinitely extended, i.e. you can add any number of software in the IT Inventory System, provided that system memory is enough.  Press the [Add Software] button to add new software or press [Software Master] to go to the “Software Master” screen directly.  You can also add a new user by pressing the [Add User] button from the toolbar.

 

 

Hardware Master

Function:
This form is used to store the hardware information.

Description:
All hardware names should be entered in this screen in order to create the hardware list. Press the [Hardware List] button to go to the "Hardware List" screen directly. Also, all cells in gray color are read-only.

Hardware ID: Auto-generated and no need to enter.

Display Position: This is used to sort the hardware in [Hardware List], by default, it will be sorted in ascending order of Hardware Name if Display Position not entered.



 

Hardware List

Function:
This is used to store the information about the hardware installed in user's PC.

Description:
This is the core part of the IT Inventory System. Hardware installed in user's PC were all recorded in this screen. The total number of hardware in this system can be infinitely extended, i.e. you can add any number of hardware in the IT Inventory System, provided that system memory is enough. Press the [Add Hardware] button to add a new hardware or press [Hardware Master] to go to the "Hardware Master" screen directly. You can also add a new user by pressing the [Add User] button from the toolbar.

 

 

User Login Maintenance

Function:
Add or remove users that use the IT Inventory System.

Description:
Only the users listed here are permitted to log in to the IT Inventory System. Select the User ID in the combo box and edit his/her information. Press the [Save] button to confirm changes. Press [Add User] button to add a new user login. To do this, you should select an existing staff from the staff list. The concept is, all staff/user information shares the same source and only those users that added into this screen has got the rights to log in to this system. Press [Remove User] to remove this rights. User record will not be actually removed by pressing [Remove User] button but only access rights will be removed.

 

Software Key

Function:
This is the place to store software license keys.

Description:
Select the Software Name to store license key, you can also specify which user and which computer that installed this license. User ID and Computer Name is not mandatory.

 

IP List

Function:
Maintain IP tables within an organization.

Description:
IT Department always need to maintain a set of IP tables that store the related computer information, for e.g., User ID, Computer Name, MAC Address etc. Many organizations have got many sets of IP range in their local area network, it makes the maintenance work more difficult. Because of this reason, IT Inventory System allows users to create unlimited set of IP tables to help administrators to easily complete their maintenance work. When creating an IP table, user is only need to input the IP range, all other information (User ID, Computer Name, MAC Address) were collected by the system automatically!
Find Function

Function:
Find and filter ANY information from ALL screens.

Description:
The "Find" function is available in all screens throughout the IT Inventory System. This is the most amazing function in our system.

Field Name: The name of the field that want to find, all field names are shown in the combo box for selection, no need to input by user.

Operator: Either =, < > (not equal), >, >= (greater than or equal to), <, <= (smaller than or equal to), LIKE (any combination with specified Value)

Value: The value to find.

OR / AND: Our system allows users to simultaneously use up to 5 criteria to find / filter information, just choose OR / AND in the last combo box of the [Find] window.

Reset Filter: After filtering of the information, press this button to reset the filter.

 

 

Export to Excel

Function:
Export any data from all screen in an Excel file. Required Microsoft® Office 2003 or higher to be installed in the machine.

Description:
All data can be export to an Excel file format for analyzing. The exported Excel file is exactly the same as shown in the system.
Options Menu

System Language: Either English, Traditional Chinese or Simplified Chinese. Language displayed will be changed immediately after clicking OK, no system restart is required. A multilingual system is particularly important in multilingual district such as Hong Kong.

Software License Type Color: Legend color shown in Software Master, Software List and Software Key windows can be customized in this option screen.

Reset Default: Reset all options to its default value.

 

* Microsoft© Windows™ and Windows™ logo is a registered trademark of Microsoft Corporation.
* Android™ is a trademark of Google Inc.

 

Please call us now at (852) 820 222 79 / (86) 150 1762 6917.
Copyright © 1999-2018 Algorithm Systems Consultant. All rights reserved.