WORKFLOW: using TMMsg_CreateTaskResp is a SQL query

Last post 02-19-2019, 10:05 PM by Larryb61. 0 replies.
Sort Posts: Previous Next
  • WORKFLOW: using TMMsg_CreateTaskResp is a SQL query
    Posted: 02-19-2019, 10:05 PM

     

     

     

     

     

     

    Hi Team,

     

     

    I have formulated a query to return messages for failed jobs

     

    select distinct lm.Message from JMFailureReasonMsg rm

     

    join EvLocaleMsgs lm on lm.MessageID=rm.messageId

     

    where rm.jobid = 379003780 <<<Actual Job id

     

    and lm.LocaleID=0

     

     

     

    However, I am running an XML script to upgrade a client using the return structure from the XML, that is, TMMsg_CreateTaskResp/jobIds[1]}. What format do I have to put in the SQL query to convert it into a job id? See below

     

     

     

     

     

    select distinct lm.Message from JMFailureReasonMsg rm

     

    join EvLocaleMsgs lm on lm.MessageID=rm.messageId

     

    where rm.jobid = TMMsg_CreateTaskResp/jobIds[1]} <<<  jobid stored in here

     

    and lm.LocaleID=0

     

The content of the forums, threads and posts reflects the thoughts and opinions of each author, and does not represent the thoughts, opinions, plans or strategies of Commvault Systems, Inc. ("Commvault") and Commvault undertakes no obligation to update, correct or modify any statements made in this forum. Any and all third party links, statements, comments, or feedback posted to, or otherwise provided by this forum, thread or post are not affiliated with, nor endorsed by, Commvault.
Commvault, Commvault and logo, the “CV” logo, Commvault Systems, Solving Forward, SIM, Singular Information Management, Simpana, Commvault Galaxy, Unified Data Management, QiNetix, Quick Recovery, QR, CommNet, GridStor, Vault Tracker, InnerVault, QuickSnap, QSnap, Recovery Director, CommServe, CommCell, SnapProtect, ROMS, and CommValue, are trademarks or registered trademarks of Commvault Systems, Inc. All other third party brands, products, service names, trademarks, or registered service marks are the property of and used to identify the products or services of their respective owners. All specifications are subject to change without notice.
Close
Copyright © 2019 Commvault | All Rights Reserved. | Legal | Privacy Policy