Free subquery software for windows

A computer inventory application with a web based interface. zCI is freeware for computer inventory. It is free but contains a lot of corporate feature. zCI has 100% web-based user interface, including its automatic data gathering mecahnism.
Also, zCI contains a peripheral inventory capability and facilities to manage device ownerships. Even some expensive computer inventory software doesnt have these capabilitites.
zCI provides client programs for Windows and Linux/Unix operating system. The client programs automatically collect hardware and software information, such as hardware list, software list, computer serial number, monitor serial number, MAC address and etc. The free zCI gives you more and better features compared to many non-free inventory softwares.
Through zCI management websites, IT staffs can do almost everything related to computer inventory. They can search for computers using multiple filter, such as memory size, processor speed, OS type and etc. They can list how many and which computers that have a processor type, or RAM size, or etc.
Also, users can list computers, monitors and peripherals based on their usage and ownership status. Device inventory data history is also available to check whether a computer has changes in their hardware and operating system configurations.
Main features:
- The core of computer inventory is data gathering. The most ancient type of inventory data gathering is IT staffs visit every computer and record the computer model, serial number, operating system, hard disk capacity, etc. In zCI, data gathering is so easy because users only need to execute less than 10 KB program, wait for about 10 seconds to have the data sent to database and get a display of the computer information in a web page from zCI server. The only manual inputs users must do are when updating device ownership information and serial number of peripheral and monitor, since those data cannot be collected automatically.
- Because of that simplicity, computer users does not have to order IT staff to visit, just place the zCI client software on an intranet website and e-mail users to download and execute the program. The better way, set zCI client software in login script. The IT staffs just can sit in their room waiting computer data, then attaching additional device ownership and serial number data
The following informations are retrieved automatically by zCI client programs:
- Computer vendor, model and serial number. If it is not branded computer, data will be taken from motherboard information which the serial number may be similar between computers.
- Network domain name and user name.
- Operating system name and installation date.
- Processor type and maximum speed, not current speed.
- Memory/RAM size in megabyte.
- Installed softwares.
- Hard drive model and size in gigabyte.
- SCSI Controller model.
- CD/DVD Drive model.
- Floppy drive existence.
- Display Adapter chipset name.
- Monitor model (depends on installed driver) name and serial number.
- Sound adapter model.
- Network adapter model and its IP address.
- Peripheral model names
System requirements:
- Windows Scripting Host (WSH) min. version 5.6
- WMI Core min. ver 1.5
- Any web server can be used as long as it supports PHP.
- PHP min. version 4.1.
- Harddisk space 5 MB.
- MySQL at least version 4.1.
Other database that support subquery:
- Frontbase
- Microsoft SQL Server
- Oracle
- Postgre SQL
- Sybase-CT
- SQLite