Inventory Store Command

You can list the file contents of a store by using the Inventory Store command. Additional clauses provide the ability to specify a subset of locations to inventory. Memory usage remains at a low fixed amount regardless of the size of the store.

inventory store NAME [location LOCATION_TARGET{,LOCATION_TARGET}] [store] [fcsdbchecksum]; 
  • NAME is the name of the file store.
  • LOCATION_TARGET is one or more location names that are associated with the specified store. Locations are separated by a comma but no space.

It is highly recommended that inventories of all stores and locations are performed nightly as part of the backup procedure.

If files names are hashed, a list is presented containing a mapping of the hashed names to the original names.

If MQL is running in verbose mode, the output includes:

  • The full path of file origination
  • The date and time of creation (if the file name is hashed)
  • The format of the file and the owning business object.

You can also include the keyword store after the storename to list files stored at the store itself. For example, the command:

inventory store Assemblies store location Dallas,London;

might result in the following output:

store Assemblies file original 
C:\Designs\widget\SHEET1.PRT captured /matrix/prod/stores/Assemblies/31b49a45.784 on 
Tue Apr 4, 1994 4:19:17 PM format Cadra of business object Assembly 12345 A 

The creation date and time for hashed file names correlates to when the database received control of the file and hashed the name. Keep in mind that there are a number of ways a file can get into 3DSpace: through checkin, import, cloning, or revisioning.

You can also include the keyword fcsdbchecksum to list the current checksums for the files in the store.

If the output indicates that files have been orphaned, contact Dassault Systemes Customer Service for help in diagnosing the error.