The raw file manager image from an Agent software scan is stored in this table. When an agent runs the Software Inventory module, it scans the entire disk image. The result is a DIR-like output of the complete directory tree. This disk image is sent to the database where it is used to extract information about installed applications. The disk image itself is also stored in the database where it can be used for offline browsing. The DOMAINID and UNITID fields defines which Unit the disk image comes from. The disk image is stored in the field CONTAIN. Only ASCII text is written to this field. The file manager may be split into more database entries if the image takes up more space than one field can hold. For more information on memo-field splitting, see the General section. The field part number is stored in the FILEPART field. The FDATE contains the date/time the disk image was collected. The format of the CONTAIN field: Directories: DIR: <COMPLETE PATH>\ Files: <FILENAME>|<FILELENGTH IN BYTES>|<FILEDATE IN YYYYMMDD FORMAT>|<FILETIME IN HHMMSS FORMAT>|<FILE ATTRIBUTES> Generally directories are sorted alphabetically and files in the directory are listed below. Files are also sorted alphabetically. On databases other than MS Access, a space character must be appended to the directory entries. Each line is separated with the cr-lf characters (characters #13#10).
| Column Name | Column Datatype | Column Null Option | Column Comment |
| object_uuid | byte(16) | not null | Object Uuid. Foreign key to either ca_discovered_hardware or ca_discovered_user depending on object_type (1=ca_discovered_hardware,2=ca_discovered_user) |
| filepart | integer | not null | The field part number is stored in the FILEPART field. |
| fdate | integer | with null | The FDATE contains the date/time the disk image was collected. |
| contain | nvarchar(15000) | with null | The disk image is stored in the field CONTAIN. Only ASCII
text is written to this field. The file manager may be split
into more database entries if the image takes up more space
than one field can hold.
The format of the CONTAIN field: Directories: DIR: <COMPLETE PATH>\ Files: <FILENAME>|<FILELENGTH IN BYTES>|<FILEDATE IN YYYYMMDD FORMAT>|<FILETIME IN HHMMSS FORMAT>|<FILE ATTRIBUTES> |
| object_type | integer | with null | Object Type. 1=ca_discovered_hardware,2=ca_discovered_user |
| object_domain_uuid | byte(16) | with null | Object domain uuid. Foreign Key to ca_n_tier. Used for replication purposes. |
Product Name: Unicenter Desktop and Server Management
Table Type: Table