Iterate over offline libraries

Last post 08-25-2017, 8:54 AM by Jedi_knight_82. 1 replies.
Sort Posts: Previous Next
  • Iterate over offline libraries
    Posted: 08-24-2017, 6:05 AM


    I want to create a workflow that iterates over all offline libraries and does something. Can someon help me with the SQL to find the offline libraries?

    Is there any DB-Documentation wher i can find such infos?


  • Re: Iterate over offline libraries
    Posted: 08-25-2017, 8:54 AM

    Please try the query below.



    select AliasName


    from CommServ.dbo.MMLibrary


    where LibraryVendor ='Spectra'--Enter Library Vendor between ''


    and LibraryEnabled != 0 --Omits libraries that are disbled


    orderby AliasName




    Few Useful Link:


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.
Copyright © 2020 Commvault | All Rights Reserved. | Legal | Privacy Policy