Using a Stored Procedure in a Workflow?

Last post 08-31-2017, 11:17 AM by ameykarandikar. 1 replies.
Sort Posts: Previous Next
  • Using a Stored Procedure in a Workflow?
    Posted: 08-31-2017, 10:52 AM

    All,

     

    We'd like to use a Stored Procedure in the Commvault SQL Database, dbo.rptGetSubClientsWithNoSchedule, as part of a workflow but we aren't sure how to get started with this. I don't think we can use the execute QCommand. Does anyone know how to run a Stored Procedure and then extract the information it provdes? What can be used in general to get this from Workflow

    I know of the report in Metric Reports for this, Subclients without Backup Schedules, but we are wanting to turn this into a workflow that kicks off to our ticketing system.

     

    Thanks in advance.

  • Re: Using a Stored Procedure in a Workflow?
    Posted: 08-31-2017, 11:17 AM

    There is a CommserveDBQuery activity that you can use

    http://documentation.commvault.com/commvault/v11/article?p=features/workflow/activities.htm#commservdbquery

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