Viewing Data

The Default Display

The basic analysis of data consists of viewing the hardware, software and asset information in the scan files collected for a computer population, Analysis Workbench provides various windows to display and view data.

• Files
• Machines
• Directories
• Applications

The default display view on starting Analysis Workbench consists of three windows: Files, Applications and Machines. A Directory view can be displayed as well, but is not part of the default screen layout.

Each window can be customized to show different columns and different levels of detail for each line. The window contents can be sorted on any column displayed, by clicking on the column headers.

In addition, each window features a Details window, where more details about the currently selected item can be displayed.

Any number of windows, each displaying a different set of columns and sorted in different ways can be opened at the same time.

The current workspace layout can be saved, either as the new default workspace or as a named layout that can be reloaded at any time. The Layout command in the Window menu is used to save a new or load a previously saved window layout. The default layout is stored in awdef.ini.

The user interface can be customized by using the options in the Configure drop-down toolbar menu available in all the windows. For more information, see the section describing Customizing Window Layouts.

The windows can be resized and positioned in the workspace to reflect your requirements. For more information, see the section describing Information Windows.

Locking and Unlocking Columns

It is possible to ‘lock’ some of the leftmost columns of the main windows.

To do this, right-click on a column header, and select the Lock option. When this is done, the column clicked and all columns to the left of it will be ‘locked’ and will not scroll left or right. To remove a lock, select the Unlock option from the shortcut menu, and to set a different lock, simply select Lock on a different column.

This feature can be used to make sure important columns, remain visible while scrolling through detailed columns.

The Machines Window

Information Available in the Machines Window

The Machines window displays the Machine ID (Asset Number) and various description fields for computers within the inventoried population.

Included in this information is asset data. Asset data is data that was collected using the asset questionnaire which collects customized asset information as each computer is scanned. The asset questionnaire is configured in the Asset Data page of the Scanner Generator.

The information includes details about users, departments, physical assets, equipment, and any other information that is useful to record.

User-defined and Automatic fields now show the actual caption displayed to the user. However, if more than one scan is loaded into Analysis Workbench and they have different captions, only the caption from the last scan loaded is shown.

The Machines window allows further details of the hardware, software and asset data collected for a computer to be viewed, by providing a link to the Machine Details window. See page 99 for more information about the Machines Details window.

Filtering Data in the Machines Window

Filters can be set (using the Filters drop-down toolbar menu or the filter icons) to provide additional information in relation to the other windows in the workspace as follows:

Filter	Shows
Machine	Any tagged machines in the Machines window.
Application	Any machines that contain tagged applications. It shows any machines that have the application installed. Note: It does not show machines that have a partial installation (in other words, machines where a license is not needed).
Directory	Any machines that contain tagged directories.
File	Any machines that contain tagged files.
Local	Any machines with Local tags.

Customizing the Columns Displayed in the Machines Window

To customize the columns displayed in the Machines window:

1. Click on the Columns drop-down toolbar menu. The Select Columns to Display dialog box is displayed.

   • The Available columns list shows all the available categories and fields. Clicking on the + sign expands the category and shows the fields that are contained in it. A check box is displayed next to each category and field. A dotted check box next to the category indicates not all the fields in that category have been selected (that is, only some fields have been selected). Clicking on a partially checked category will select all fields in the category. Clicking again will deselect all fields.

   • The Selected columns list shows the fields that have been selected to be displayed as columns in the Machines window.

   • The Show only items in use option will ensure that only hardware items that actually exist in one of the loaded scan files are shown in this tree.

2. Either drag a category from the left list to the Selected columns list, or select the check box next to the category and click the >Add button. The functions of the other buttons are as follows:

   • To add all the available columns to the Selected columns list click the >>Add button.
   • To remove an entry from the Selected columns list click the Delete button.
   • To delete all entries in the Selected columns list click the Del All button.

   Note You can move the position of entries in the Selected columns list using the Up and Down buttons.

3. Click OK after you have selected the columns. You are returned to the main workspace.

The Machine Details Window

The Machine Details window provides further information for each computer listed in the Machines window.

To display the Machine Details window in the Machines window do one of the following:

• Select the Detail window link option from the Configure drop-down toolbar menu.
• Select the Configuration option from the Window menu and check the Machine Windows box in the Detail Window Link group.

The information to be displayed in the Machine Details window can be selected by doing one of the following:

• Clicking on the Configure button and checking the Machine Windows box in the Detail Window Link group.
• Selecting the Detail window option from the Configure drop-down toolbar menu and checking the Machine Windows box in the Detail Window Link group.

Depending on what information was selected in the Window Layout dialog box, the Machines Details window can show the following information:

• Hardware overview - The information displayed here depends on which option was selected in the Configuration window.
• The default displays basic details of the hardware configuration scanned from the computer as it is inventoried. Provides details of the operating system, processor, type of screen, memory, drives, directories and files as well as the total disk space and free space.
• The Machine window data displays all columns as selected in the Machines window but vertically rather than horizontally making it easier to read.
• Applications - Displays details of the applications identified on the machine, including the publisher, applications and version.
• Recognition statistics - Displays the total number of files on the highlighted machine, including a breakdown of Main files, Associated files, files that need the version checked, unrecognized files and unprocessed files, both as a figure and as a percentage of the total files.
• The Machines Details – Application information links back to the Applications window, showing details for that selected application entry. That is, if you click on an application in the Machines Details window, the corresponding application will be located (and highlighted) in the Application window.

The Applications Window

The Applications window displays a view of the applications within a population that have been recognized.

The Applications window allows further details of the application license information collected for a computer to be viewed, by providing a link to the Applications Details window.

The data displayed in the Applications window cannot be changed or altered in any way. The Applications window provides the following information:

Column	Description
Publisher	The name of the software publisher (for example, Microsoft, IBM).
Application	The name of the software application.
App Type	The type of application (for example, Word processor, Spreadsheet).
Version	The version of the software.
Release	The release of the software.
OpSys	The operating system the application runs on.
LangCode	The ISO 639 Language – 3166 Country code of the application. This is the ISO standard used to define languages. The format is as follows: <639 3166> for example <EN-US> refers to English – USA.
Language	The name of the language of the application.
Description	Any additional relevant information and notes, (for example, that the application is part of the Microsoft Office97 Suite of programs).
Machines	The number of machines on which the application is found. In the Operational View, this includes machines on which a partial install (that is, one or more non main files) is found. In the Business View, this column is the same as the Installs column.
Installs	The number of installations of that particular application that have been found throughout the population (that is, on how many machines the application is installed). An application is defined as installed when at least one Main file has been identified on a machine.
Licenses	The number of licenses required for the application. This is the same as the Installs column unless a license relation exists, in which case, the Licenses column may contain a number smaller than the Installs number.
Files	The number of files that are contained in that application (that is, how many files have been identified as belonging to the application).
Licenses Apps	The number of other applications that the application is responsible for licensing. For example, if Internet Explorer licenses NetMeeting on five machines and RealPlayer on three machines, this column would contain a value of eight.
Licensed By	The number of owning applications (licensees) taking responsibility for licensing this application. In the previous case, RealPlayer would have a count of three in this column. If RealPlayer was licensed by some other application on another machine, the count would be higher.
Version Id	This column contains the ID uniquely identifying a given version.
Utilization	This shows the number of days that the application was used (as a percentage) over a period of time. The period is calculated automatically depending on long the application was used for. As a rough guideline the time periods are as follows: Application used for more than 3 months - utilization is calculated over the year. Application used for less than 3 months - utilization is calculated over a quarterly period. Application used for less than one month - utilization is calculated monthly You can drill down to the detail level to see the individual results in the Details window.
Used on	The machine the application was used on.

Filters can be set (using the Filters drop-down toolbar menu) to provide additional information in relation to the other windows in the workspace as follows:

Filter	Shows
Machine	Any applications that are contained on tagged machines.
Application	Any tagged applications in the Application window.
Directory	Any applications whose main file is contained in tagged directories.
File	Any applications that contain tagged main files.
Local	Any applications with Local tags.

You can use the locking feature to make sure important columns, such as Tag, Publisher and so on remain visible while scrolling through detailed columns. For more information, see the section describing Locking and Unlocking Columns.

Applications Details Window

To display the Applications Details window do one of the following:

• In the Applications window, select the Detail window link option from the Configure drop-down toolbar menu.
• Select the Configuration option from the Window menu and check the Application Windows box in the Detail Window Link group.

The information that is displayed in the Applications Details window can be selected by doing one of the following:

• Clicking the Configure button in the Details window.
• Selecting the Detail window option from the Configure drop-down toolbar menu. This will display a Window Layout dialog box.

Depending on what information was selected in the Window Layout dialog box, the Applications Details window can show the following information:

• Installed on machines - The machine(s) that the application is installed on.
• Licensed by - The details of the Application Suite that licenses the highlighted application (if applicable). For example, Word 97 is licensed by Microsoft Office 97.
• Licenses - The details of any applications that the highlighted application licenses, for example, Word 97 licenses Microsoft Photo Editor.
• The Applications Details – Installed on machines information links back to the Machines window, showing details for that selected machine entry. That is, if you click on a machine in the Applications Details window, the corresponding machine will be located (and highlighted) in the Machines window.
• The Applications Details – Licensed by or Licenses information links back to the Applications window and the Machines window, showing details for that selected application and the machine it is located on.

The Directories Window

The Directories window provides a view of the directory names within a population containing inventoried files. It displays a list of every unique directory of software files within the population, and enables you to assess the conformance to standards for software installed across the computer population. It does not take the drive into account, for example, e:\temp and c:\temp is one line in this window.

The Directory window is particularly helpful for identifying configuration anomalies prior to, or after installing new applications or upgrades. Any directory which resides in a different path will be shown as a separate line item.

The Directories window allows further details of the Directories (including files contained in the directory and machine name) to be viewed, by providing a link to the Directories Details window.

The Directories window provides the following information:

Column	Description
Tag	Global tag column
Ltag	Local tag column
Name	Name of the directory
Count	Number of drives and machines a specific directory occurs on within the population. The details of the Machines and drives the directory occurs on can be seen in the Directory Detail window.
Main	A check mark is shown in this column if the directory contains a Main file of an application.
Tagged Files	This column shows the number of tagged files contained in the highlighted directory. The list of tagged files is displayed in the Directories Details window.
Tagged Applications	This column shows the number of tagged applications whose main link is contained in the highlighted directory.

Filters can be set (using the Filters drop-down toolbar menu) to provide additional information in relation to the other windows in the workspace as follows:

Filter	Shows
Machine	Any directories that occur on tagged machines.
Application	Any directories that contain tagged applications.
Directory	Any tagged directories in the Directories window.
File	Any directories that contain tagged files.
Local	Any directories with Local tags.

You can use the locking feature to make sure important columns, such as Tag, Name, Main remain visible while scrolling through detailed columns. For more information, see the section describing Locking and Unlocking Columns.

The Directories Details Window

The Directories Details window displays further information for each directory listed in the Directories window.

To display the Directories Details window do one of the following:

• In the Directories window, select the Detail window link option from the Configure drop-down toolbar menu.
• Select the Configuration option from the Window menu and check the Directory Windows box in the Detail Window Link group.

The information that is displayed in the Directory Details window can be configured by doing one of the following:

• Clicking the Configure button in the Details window.
• Selecting the Detail window option from the Configure drop-down toolbar menu. This will display a Window Layout dialog box.

Depending on what information was selected in the Window Layout dialog box, the Applications Details window can show the following information:

• Files - Displays a list of file names found within the directory, along with the size of the file.
• Machines - Displays a list of machines where the directory is found within the population, with the drive location for the directory.
• The Directories Details – Files information links back to the Files window, showing details of a particular files that resides in the highlighted directory.
• The Directories Details – Machines information links back to the Machines window, showing details of the machine that the directory is on.

The Files Window

The Files window displays information for all the inventoried files in the population. It allows further details of the file information collected on a PC to be viewed, by providing a link to the File Details window.

The Files window displays the following:

Column	Description
Tag	Global tag column
LTag	Local tag column
Name	A full list of all the files selected for analysis within the population of scan files read into the Analysis Workbench (known as the inventory files). The files displayed in red are the Main executable files for an application. The files displayed in green are the files associated with an application. They belong to it but are not main files. The files displayed in blue are unidentified or partially identified files.The files displayed in purple are partially identified Main or Associated files. Note: The colors referred to are the default and can be customized. For more information, see the section describing Customizing the Font and Color.
Size	Size of the file.
Publisher	Name of the software publisher.
Application	Type of application (for example, Games, Disk creation Utility).
Version	File version number where a file is fully identified.
Release	The release of the software.
OpSys	Operating system under which the application the file belongs to operates.
LangCode	The ISO 639 Language – 3166 Country code of the application. This is the ISO standard used to define languages. The format is as follows: <639 3166> for example <EN-US> refers to English – USA.
Language	Name of the language of the application.
Copies	Shows the number of copies of each file within the population.
# Sizes	Number of sizes of a file with the same name that exist in a population of machines.
# Signatures	Shows the number of signatures found for each file within the population.
# Dates	Number of different dates for copies of the file within the population.
# Attributes	Number of different attributes for the file copies.
# Types	Number of different types found for this file name (for example, a file called Setup.exe can be a DOS executable file or a Windows executable).
Status	Whether the file is a: Main file = 1 Associated file = 2 3rd Party files = 3 CheckVer file = 4 Unknown file = 5 Unprocessed file = 6 Auto-identified = 7 Junk = 8
Description	Version description as entered in the SAI. It is a separate field that can contain any user description or comment.
Signature	The file Signature column (a number produced for each file by checking the first 8192 bytes) is usually sufficient to identify a file. If there is more than one signature, an asterisk ‘*’ is also shown in the column to indicate this.
Modified	The date the files were last modified.
Accessed	The date the files were last accessed.
Utilization	This shows the number of days that the application was used (as a percentage) over a period of time. The period is calculated automatically depending on long the application was used for. As a rough guideline the time periods are as follows: Application used for more than 3 months - utilization is calculated over the year. Application used for less than 3 months - utilization is calculated over a quarterly period. Application used for less than one month - utilization is calculated monthly. You can drill down to the detail level to see the individual results in the Details window.
Attribute	The Attribute column along with normal file attributes includes the following: r - Read-only files. Files marked read-only are protected from modification or deletion. h - Hidden files. Windows Explorer does not show hidden files by default unless you tell it to do so. s - System files. u - Utilized file. This flag shows that this file was executed and the application was used. v - Volume Label. This contains no data and no more than one may exist on a disk volume (and only in the root directory). a - If it has the archive attribute of DOS or windows. The Archive attribute is used to provide an automatic record of what files have been modified since the last backup. c - Compressed files. These are compressed files and folders. For example, if it is a file on a compressed NTFS volume. x - In a UNIX system this represents a file with the executable attribute set. I - Internal file. That is, if it has version data available for it. Version data (as per Windows Explorer) is displayed for all files having this attribute. L - Symbolic link in UNIX. Files (and directories) may be located on several different file systems. To link files that are in different file systems a symbolic link is made. s - This is special case for UNIX for SetUid files. In UNIX scans, certain files have special attributes that mean that they run with root privilege. Such files are potentially a security risk and the Scanner assigns them the system attribute - s A - This file has been identified as an archive. C - This file has been identified inside an archive. X - This file has been identified as an executable file. D - This file has been identified as a device driver. If there are more than one set of attributes, an asterisk ‘*’ is also shown in the column to indicate this.
File Type	Shows the type of file (for example, DOS executable file, Windows executable, OS/2 DLL file). If there is more than one file type, an asterisk ‘*’ is also shown in the column to indicate this.

Filters can be set (using the Filters drop-down toolbar menu) to provide additional information in relation to the other windows in the workspace as follows:

Filter	Shows
Machine	Any directories that occur on tagged machines.
Application	Any directories that contain tagged applications.
Directory	Any tagged directories in the Directories window.
File	Any directories that contain tagged files.
Local	Any directories with Local tags.

You can use the locking feature to make sure important columns, such as Tag, Name, Main remain visible while scrolling through detailed columns. For more information, see the section describing Locking and Unlocking Columns.

Adding Entries to the SAI

The Add to SAI option in the Tags drop-down menu allows you to ‘teach’ Universal Discovery to recognize files which it previously did not recognize. This enables you to optimize the software analysis and consolidation capabilities of the Analysis Workbench to recognize unidentified files and applications. The same data can be used by the Viewer.

For more information, see the section describing Teaching Applications to the User SAI.

The File Details Window

The File Details window provides further information for each file listed in the window.

To display the File Details window do one of the following:

• In the Files window, select the Detail window link option from the Configure drop-down toolbar menu.
• Select the Configuration option from the Window menu and check the File Windows box in the Detail Window Link group.

The information that is displayed in the File Details window can be configured by:

• Clicking the Configure button in the Details window.
• Selecting the Detail window option from the Configure drop-down toolbar menu. This will display a Window Layout dialog box.

Depending on what information was selected in the Window Layout dialog box, the Files Details window can show the following information:

• Asset numbers (Machine) - Shows the Asset number of the Machines that the file resides on.
• Directory names (Directory) - Show the directory that the file resides in.
• File sizes (Size) - Shows the size of each copy of a file within the population.
• File signatures (Signature) - Shows the signatures for each file within the population.
• File modified date- Shows the date the file was last modified files if available.
• File Utilization - This shows the number of days that the application was used (as a percentage) over a period of time.
• File accessed date- Shows the date that the file was last accessed.
• File attributes (Attributes) - Displays system attributes for a file. The Attribute column along with normal file attributes includes the X (executable), I (internal file) and D (device driver) information. For all files having the Information I attribute, version information (as per Windows Explorer) is displayed.
• File type (Type) - Shows the type of file (for example, DOS executable file, Windows executable, OS/2 DLL file).
• Version data - Version information (as per Windows Explorer Properties for a file) is available for all files having the information I attribute.
• File Version data - Shows any version data that was collected for the file.
• The File Details – Machine information window links back to the Machines window by selecting the machine that a selected file exists on. It also links back to the Directory window by selecting the directory that the selected file resides in.