Get a list of all databases in a support dump and their ids

databases-and-ids.xqy

xquery version "1.0-ml";

declare namespace db = "http://marklogic.com/xdmp/database";

import module namespace admin = "http://marklogic.com/xdmp/admin" at "/MarkLogic/admin.xqy";

declare variable $SUPPORT-DUMP-FILEPATH as xs:string := 'E:\support-request-go\support-request-go.txt';

declare variable $support as document-node()* := xdmp:document-get(
 $SUPPORT-DUMP-FILEPATH,
 <options xmlns="xdmp:document-get">
    <format>xml</format>
    <repair>full</repair>
 </options>
);

element db-listing {
  for $x in $support//db:databases/db:database
  return element database { attribute id { $x/db:database-id}, $x/db:database-name/text() }
}