Hi Marklogic Developers, I would like to know XQuery to display only specific information ( Foresetname & status as below ) instead of all other information from the backup status command . Please can you help me provide me the Xquery command to get the desired output with just Forestname and status .
<job:forest-name>DCPP_pe_Forest1</job:forest-name> <job:status>in-progress</job:status> <job:forest-name>DCPP_pe_Forest2</job:forest-name> <job:status>in-progress</job:status> <job:forest-name>DCPP_pe_Forest3</job:forest-name> <job:status>in-progress</job:status> <job:forest-name>DCPP_pe_Forest4</job:forest-name> <job:status>in-progress</job:status> . . . . Output of the Backup status : ======================= xquery version "1.0-ml"; xdmp:database-backup-status((), xdmp:hosts()) <job:job-status xsi:schemaLocation="http://marklogic.com/xdmp/job-status job-status.xsd<http://marklogic.com/xdmp/job-status%20job-status.xsd>" xmlns:job="http://marklogic.com/xdmp/job-status"; xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance";> <job:job-id>12085759075223116322</job:job-id> <job:status>in-progress</job:status> <job:forest> <job:forest-name>DCPP_pe_Forest1</job:forest-name> <job:forest-id>6023395617429453498</job:forest-id> <job:status>in-progress</job:status> <job:host-name>cpubr2-dcp20a.svr.emea.jpmchase.net</job:host-name> <job:backup-path>/backup/MarkLogic/DCPP_pe_test/20170814-0444142694940</job:backup-path> <job:incremental-backup>false</job:incremental-backup> <job:journal-archiving>false</job:journal-archiving> </job:forest> <job:forest> <job:forest-name>DCPP_pe_Forest2</job:forest-name> <job:forest-id>7260982112440503686</job:forest-id> <job:status>in-progress</job:status> <job:host-name>cpubr2-dcp20a.svr.emea.jpmchase.net</job:host-name> <job:backup-path>/backup/MarkLogic/DCPP_pe_test/20170814-0444142694940</job:backup-path> <job:incremental-backup>false</job:incremental-backup> <job:journal-archiving>false</job:journal-archiving> </job:forest> <job:forest> <job:forest-name>DCPP_pe_Forest3</job:forest-name> <job:forest-id>5864190318265099425</job:forest-id> <job:status>in-progress</job:status> <job:host-name>cpubr2-dcp20a.svr.emea.jpmchase.net</job:host-name> <job:backup-path>/backup/MarkLogic/DCPP_pe_test/20170814-0444142694940</job:backup-path> <job:incremental-backup>false</job:incremental-backup> <job:journal-archiving>false</job:journal-archiving> </job:forest> <job:forest> <job:forest-name>DCPP_pe_Forest4</job:forest-name> <job:forest-id>8746367715338283955</job:forest-id> <job:status>in-progress</job:status> <job:host-name>cpubr2-dcp20b.svr.emea.jpmchase.net</job:host-name> <job:backup-path>/backup/MarkLogic/DCPP_pe_test/20170814-0444142694940</job:backup-path> <job:incremental-backup>false</job:incremental-backup> <job:journal-archiving>false</job:journal-archiving> </job:forest> <job:forest> <job:forest-name>DCPP_pe_Forest5</job:forest-name> <job:forest-id>17975862472145539803</job:forest-id> <job:status>in-progress</job:status> <job:host-name>cpubr2-dcp20b.svr.emea.jpmchase.net</job:host-name> <job:backup-path>/backup/MarkLogic/DCPP_pe_test/20170814-0444142694940</job:backup-path> <job:incremental-backup>false</job:incremental-backup> <job:journal-archiving>false</job:journal-archiving> </job:forest> <job:forest> <job:forest-name>DCPP_pe_Forest6</job:forest-name> <job:forest-id>5587825756135861120</job:forest-id> <job:status>in-progress</job:status> <job:host-name>cpubr2-dcp20b.svr.emea.jpmchase.net</job:host-name> <job:backup-path>/backup/MarkLogic/DCPP_pe_test/20170814-0444142694940</job:backup-path> <job:incremental-backup>false</job:incremental-backup> <job:journal-archiving>false</job:journal-archiving> </job:forest> <job:forest> <job:forest-name>DCPP_pe_Forest7</job:forest-name> <job:forest-id>6203847709944443533</job:forest-id> <job:status>in-progress</job:status> <job:host-name>cpubr2-dcp20c.svr.emea.jpmchase.net</job:host-name> <job:backup-path>/backup/MarkLogic/DCPP_pe_test/20170814-0444142694940</job:backup-path> <job:incremental-backup>false</job:incremental-backup> <job:journal-archiving>false</job:journal-archiving> </job:forest> <job:forest> <job:forest-name>DCPP_pe_Forest8</job:forest-name> <job:forest-id>12671226984293178609</job:forest-id> <job:status>in-progress</job:status> <job:host-name>cpubr2-dcp20c.svr.emea.jpmchase.net</job:host-name> <job:backup-path>/backup/MarkLogic/DCPP_pe_test/20170814-0444142694940</job:backup-path> <job:incremental-backup>false</job:incremental-backup> <job:journal-archiving>false</job:journal-archiving> </job:forest> <job:forest> <job:forest-name>DCPP_pe_Forest9</job:forest-name> <job:forest-id>8642973673533931053</job:forest-id> <job:status>in-progress</job:status> <job:host-name>cpubr2-dcp20c.svr.emea.jpmchase.net</job:host-name> <job:backup-path>/backup/MarkLogic/DCPP_pe_test/20170814-0444142694940</job:backup-path> <job:incremental-backup>false</job:incremental-backup> <job:journal-archiving>false</job:journal-archiving> </job:forest> <job:forest> <job:forest-name>Security</job:forest-name> <job:forest-id>7567700030611105941</job:forest-id> <job:status>completed</job:status> <job:host-name>cpubr2-dcp20a.svr.emea.jpmchase.net</job:host-name> <job:backup-path>/backup/MarkLogic/DCPP_pe_test/20170814-0444142694940</job:backup-path> <job:incremental-backup>false</job:incremental-backup> <job:journal-archiving>false</job:journal-archiving> </job:forest> <job:forest> <job:forest-name>Schemas</job:forest-name> <job:forest-id>13196646040422080882</job:forest-id> <job:status>completed</job:status> <job:host-name>cpubr2-dcp20a.svr.emea.jpmchase.net</job:host-name> <job:backup-path>/backup/MarkLogic/DCPP_pe_test/20170814-0444142694940</job:backup-path> <job:incremental-backup>false</job:incremental-backup> <job:journal-archiving>false</job:journal-archiving> </job:forest> <job:forest> <job:forest-name>DCPP_pe_Triggers_Forest1</job:forest-name> <job:forest-id>7286377935687669173</job:forest-id> <job:status>completed</job:status> <job:host-name>cpubr2-dcp20a.svr.emea.jpmchase.net</job:host-name> <job:backup-path>/backup/MarkLogic/DCPP_pe_test/20170814-0444142694940</job:backup-path> <job:incremental-backup>false</job:incremental-backup> <job:journal-archiving>false</job:journal-archiving> </job:forest> </job:job-status> Thanks and Regards, ________________________________ Manoj Prabhakar | Assoc | BAIO Database Services | GTI Service Operations | GSO Database Services CP | J.P. Morgan Chase | One@Changi City | Level - 5 | Changi Business Park Central 1 | Singapore 486036 | T: +1-855-679-7198 ext 4243820 | [email protected]<mailto:[email protected]>| How to reach DBA team:- Database Services Team Contact Details<http://go.jpmchase.net/GSODBAEngagementModel> | Self Service tools:- GSO Database Self Service Reporting and Operations<https://mydatabase.jpmchase.net:8443/mydatabase/dba_firststop/> | Documentation on What's Available<https://confluence.uk.jpmorgan.com/confluence/display/GDEADBTOOL/User+Guides> This message is confidential and subject to terms at: http://www.jpmorgan.com/emaildisclaimer including on confidentiality, legal privilege, viruses and monitoring of electronic messages. If you are not the intended recipient, please delete this message and notify the sender immediately. Any unauthorized use is strictly prohibited.
_______________________________________________ General mailing list [email protected] Manage your subscription at: http://developer.marklogic.com/mailman/listinfo/general
