Use > Inventory Tools > Analysis Workbench Overview > Exporting Stored File Data

Exporting Stored File Data

Stored files are embedded in the scan file during scanning. Typically these are system configuration files, for example, Autoexec.bat, Config.sys.

This type of export allows one or more named files to be extracted from all scan files and stored in a number of different ways.

The naming conventions for the extracted files allow for multiple instances of the files.

If only one stored file is required from one scan file, then it is more efficient to save the stored file from Viewer.

How to export stored file data

To do so, perform the following:

Step 1: Configure the Stored File Export

  1. Select the Stored Files command from the Exports menu.
  2. Click the Export Stored Files tab in the Export to file dialog box.

    This page is used to set up various options for the stored files export.

Step 2: Select Data Filters

  1. Select the data source filters that you want to apply to the data. In the Data Source Filter group, select one of the following:

    • Machines - Applies a Machines filter to the data source.
    • Directories - Applies a Directories filter to the data source.
    • Local - Applies a Local tag filter to the data source.
    • Application - Applies a Application filter to the data source.
    • Files - Applies a Files filter to the data source.
    • See Filtering for more information about using filters.

Step 3: Specify the Stored Files to Export

Specify whether you want to export all stored files or specific stored files.

  1. To export all stored files select the Export All Stored Files check box (located on the left side of the dialog box above the list box).

    When this check box is selected, the Add and Remove buttons are disabled in the Export Files group.

  2. To specify stored files for export, use the grid in the Export Files group to configure which files are to be exported. This grid contains two columns: File Name (the name of the file to be exported) and Found Where (the location of the file).
  3. Click the Add button to add a stored file to the list. The Specify Stored File dialog box is displayed.
  4. Specify the file name in the File Name box. Select the file name from the drop-down list (this list maintains a history of previously entered file names) or type the file name directly in to the box.
  5. Specify where this file can be located. The options are:

    • In Any Root Dir - The file is located in a root directory, for example in the E:\DOS directory.
    • In Root Dir of Boot Drive - The file is located in a root directory on the boot drive, for example in the C:\Windows directory.
    • Anywhere - The file can be located anywhere in the directory structure.
    • As specified - This option is only enabled if the path to the file is entered in the File Name field. The path must start with a backslash (\).
  6. Click OK.

Step 4: Specify the Name of the Extract Export

To specify the format the extract export file name, select an option from the Extract drop-down list:

  • All files to <AssetNumber>.txt - The export is made to a text file that has the name of the AssetNumber. For example, if the AssetNumber is 23567 then the export file will be called 23567.txt. The files are saved to the location specified in the Default Settings tab.
  • To directory named as file - The export is made to a directory that has the name of the stored file and has subdirectories for the drive that the file was located in.

    For example:

    • A stored file System.ini was extracted from a scan file called XSF014.xsf.
    • The location of the file was b:\Win95.
    • The location for the results has been specified in the Default Setting tab as H:\Stored Files
    • The export result will therefore be located in the following directory structure:

      H:\Stored Files\ Autoexec.bat\b\Win95\XSF014.txt

  • To directory <AssetNumber> - The export is made to a directory that has the name of the scan file and has subdirectories for the drive that the file was located in. This location will contain the stored files.

    For example:

    • A stored file Boot.ini was extracted from a scan file called XSF02.xsf.
    • The location of the file was c:\I386.
    • The location for the results has been specified in the Default Setting tab as H:\Stored Files
    • The export result will be located in the following directory structure:

      H:\stored Files\ XSF02\C\I386\Boot.ini

  • There is a separate option to create a CSV file of name mapping. This creates a CSV file (ExportFilenames.csv) with path information for extracted files.

    The ExportFilenames.csv file produces a CSV list with the following fields:

    Field Purpose
    Exported to File Path of the export file created
    Asset number

    Asset number of the source scan file

    Original File Name Name and path of stored file

Step 5: Specify the Types of Files to Extract

To specify the type of files to export, select the following options as required:

  • Export text files only - This extracts ASCII text files only. This option is available for all extract formats.
  • Hex dump binary files - This extracts any binary files in hexadecimal. This option is available for the To directory named as file or To directory <AssetNumber> extract formats.

Step 6: Specify the Options for the Extract Format Directories

You can specify the options for the directories that are to be used in the location of the results.

Select the options in the Directories group.

This group is only enabled if the To directory named as file or To directory <AssetNumber> have been selected as the extract format:

  • Ignore directory names - The drive letter and subdirectories will not be included. The following two additional options are made available.
  • Ignore duplicate files - If duplicate files are encountered, then the latest file will be extracted.
  • Add number to filenames - When directories of the asset names are created, multiple instances of the file are numbered starting at 000. For example:

    • FP0214.000.txt
    • FP0214.001.txt
    • FP0214.002.txt
  • Use directory names - The directory name will be used in the extract file name. The following additional option is made available.

    Substitute ‘\’ with ‘.’

    The directory path is indicated in the file name by ‘.’ For example, the result:

    H:\stored Files\ XSF02\E\I386\Boot.ini

    Will be represented as a file called

    E.I386.Boot.ini

    Located in the XSF02 directory. That is, the results can be found in:

    H:\stored Files\E.I386.Boot.ini

Loading and Saving Exports

You can save your export layout to a .awrcl file in the Analysis Workbench/Column Layout directory by clicking the Save button in the export wizard.

You can load a previously saved export configuration by clicking the Load button in the export wizard and selecting an export file (with an .awrcl extension) from the load dialog box. Exports are saved to the Analysis Workbench/Column Layout directory.

Older .rcl files will not work in this version of Universal Discovery.