XADM: Unexpected Results When You Use the "DAV:id" Property to Locate Exchange 2000 Items (320749)

MORE INFORMATION

• http://schemas.microsoft.com/exchange/permanenturl: This property is unique across all servers.
• PR_INSTANCE_KEY: This property is the MAPI binary property that underlies the DAV:id property. DAV:id is not a true binary property. It is a string property whose value is computed by converting the binary property, PR_INSTANCE_KEY, to base64. The following text is the syntax for this property:

  ...WHERE "http://schemas.microsoft.com/exchange/mapi/proptag/x0ff60102" = CAST("AQEAAAAAAnm6AQAAAAACgK0AAAAA" AS 'bin.base64')

• This field is the field for a permanent URL that can always be used to access an item even if the URL to the item is either renamed or moved.
  
  For more information about the permanenturl field, visit the following Microsoft Web site:

  http://msdn.microsoft.com/library/default.asp?url=/library/en-us/wss/wss/_cdo_schema_exchange_permanenturl.asp

• The size of the permanenturl fields is computed according to the following conditions:
  
  
  • The flat URL name uses the following format, where the folder ID (FID) and the message ID (MID) are in long format (GUID + ID). These IDs are unique on a server.
    • For folders:

      http://server/virtual_root/-FlatUrlSpace-/text-format-fid-of-folder

    • For messages:

      http://server/virtual_root/-FlatUrlSpace-/text-format-fid-of-folder/text-format-mid-of-message

  • There must be hyphen (-) between the GUID and the ID.
  • When you change the ID to a text format, you must leave out the leading zeros.
  The following text is an example of a flat URL to a folder whose FID is 1-287. This example assumes that replid 1 maps to GUID 3B6D774A33B6D211AEB500C04FB6B4C6:

  "/-FlatUrlSpace-/3B6D774A33B6D211AEB500C04FB6B4C6-287"

  The following text is an example of a flat URL to a message in folder 1-287 whose MID is 1-30A:

  "/-FlatUrlSpace-/3B6D774A33B6D211AEB500C04FB6B4C6-287/3B6D774A33B6D211AEB500C04FB6B4C6-30A"

  The maximum size is:

  http://long_server_name/long_virtual_root name/3B6D774A33B6D211AEB500C04FB6B4C6-FFFFFFFFFFFE/3B6D774A33B6D211AEB500C04FB6B4C6-FFFFFFFFFFFF

• You cannot have two permanenturl values that differ by case that point to separate items. Computer names, virtual roots, GUIDs, and hexadecimal-format FIDs and MIDs are all defined as case-insensitive.
• To have successful queries, you may have to remove the section before "/-FlatUrlSpace-/b8d01..." in the syntax from the queries. For example, you may have to remove http://servername/folder from the following query:

  "http://servername/folder/-FlatUrlSpace-/b8d01...

• To test with webDAV (HTTP), run either of the following queries:

  <sql> Select "http://schemas.microsoft.com/exchange/permanenturl","DAV:id
  http://schemas.microsoft.com/exchange/permanenturl" FROM Scope('SHALLOW
  TRAVERSAL OF ""') WHERE "http://schemas.microsoft.com/exchange/permanenturl" =
  /-FlatUrlSpace-/b8d014e9f474644ba656cb6adcef9d7b-1c/b8d014e9f474644ba656cb6adcef9d7b-1de6'

  -or-

  <sql> Select "http://schemas.microsoft.com/exchange/permanenturl","DAV:id
  http://schemas.microsoft.com/exchange/permanenturl" FROM Scope('SHALLOW
  TRAVERSAL OF ""') WHERE "http://schemas.microsoft.com/exchange/permanenturl" =
  'http://servername/folder/-FlatUrlSpace-/b8d014e9f474644ba656cb6adcef9d7b-1c/b8d014e9f474644ba656cb6adcef9d7b-1de6'

• To test with Microsoft ActiveX Data Objects (ADO) (the ExOLEDB file), run either of the following queries:

  > SELECT "http://schemas.microsoft.com/exchange/permanenturl" FROM scope('shallow traversal of
  "file://./backofficestorage/mycompany.com/MBX/user/Calendar"'
  file://./backofficestorage/mycompany.com/MBX/user/Calendar)
  WHERE "http://schemas.microsoft.com/exchange/permanenturl" =
  '/-FlatUrlSpace-/b8d014e9f474644ba656cb6adcef9d7b-1c/b8d014e9f474644ba656cb6adcef9d7b-1db5'

  -or-

  > SELECT "http://schemas.microsoft.com/exchange/permanenturl" FROM scope('shallow traversal of
  "file://./backofficestorage/mycompany.com/MBX/user/Calendar"'
  file://./backofficestorage/mycompany.com/MBX/user/Calendar)WHERE "http://schemas.microsoft.com/exchange/permanenturl" =
  'file://./backofficestorage/servername/folder/-FlatUrlSpace-/b8d014e9f474644ba656cb6adcef9d7b-1c/b8d014e9f474644ba656cb6adcef9d7b-1db5'