PHASE II - PROCESSING
View Collected Data
Select the "Objects" option in the "Inventory" Section.
- Place the cursor on the "All" node, in the main tree (top window). The audited PCs appear in the list below.
- Select one of the PCs. Its features are shown on the right side of the window.
- If you have installed the demo database, on the "Summary" tab you may view how administrative information (Custom Fields) are managed in Synexsys Inventory.
Executing Queries Across the Database
Go to the "Queries" Section and select, for instance, the "Hardware" option.
- To include all PC type objects in the query, select the root node (All) in the trees window (above).
- To restrict the query only to certain objects, you may select one or several nodes (CTRL+click) and/or objects from the trees in the upper area.
- To include just one PC in the query, select it from one of the trees in the upper part of the screen or type its name in the "System name" field (bottom area).
- Enter the search criteria in the lower part of the screen. You may enter exact expressions such as "Dell" or use substitution characters to replace parts of the expression. For instance: if you type "*he*pa*" in the "System manufacturer" field, you will obtain a list of all the "Hewlett-Packard" PCs (if there are any).
- To avoid mistakes, you can select valid values from a list for practically any field. To view this list, simply click on the field that interests you and click on […]. You can select one or several values (CTRL+click) from the list.
- You can also combine several expressions in the same field. All you need to do is separate such expressions with an "OR" operator. For instance: the expression "*Acer* OR *Siemens*" will return a list of all the Acer or Fujitsu-Siemens PCs (if there are any).
 |
Customising Query Results
You can sort the results of a query in any field. You only need to click on the selected field's header so the results become sorted. You may sort the fields in the opposite order by clicking again on the same field header.
- You can restrict the results displayed only to the fields that interest you. Use the "Visible columns" button to select /deselect the fields that are viewed.
- You can also search for a specific value within the results of a query by entering the first letters of the value you wish to search for after clicking on the column (not the header) where the value is to be found. You may also use CTRL+F to make a quick search among the results. Use F3 to find the following hit. Pressing CTRL+F accepts partial criteria such as *matrox*.
- You can change the size of columns and invert them based on your needs.
- You can also export query results ("Export" context menu) to HTML, XLS or CSV files. The customisation made to the results grid (visible fields, inverted columns, sorting, etc.) is reproduced in the export files.
Displaying Statistical Views
Go to the "Views" Section and select the "Summary" icon.
If you have installed the demo database, you should see the "End of Warranty" automatic tree in the "Auto" tab, in the top window.
- Select the root node of the "End of Warranty" tree. On the right side, you should see the annual distribution of PCs whose warranty is due to end. If you select a lower level of the tree, that is, a node representing the current year, the right side of the screen should display the global representation of PCs whose warranty is due to expire during the current year.
- If you now select the main node of the "Locations by IP" tree, you will see PCs distribution based on their site.
- Etc.
See also
Quick Start
Phase I - Inventory
Phase III - Organizing Data
Last Update: 03.02.2005