Storage Policy Summary Table

Last post 01-08-2016, 7:20 PM by Gabriel Rosenkoetter. 1 replies.
Sort Posts: Previous Next
  • Storage Policy Summary Table
    Posted: 01-08-2016, 9:11 AM

    Hello All,


    I'm trying to find out which table the information in the attached screenshot is stored in?


    We are faced with a lot of storage policies for customers that have churned and would like to create a work flow that shows all storage policies that do not have any assocaited subclient to them.  Once the list is generated, I willl have a pop-out window to select the SP, and pipe this information into the for each funtion that will utilize the qdelete sp qcommand. 


    Thanks in advance!!!

    Attachment: SP_Summary.png
  • Re: Storage Policy Summary Table
    Posted: 01-08-2016, 7:20 PM

    This isn't quite as simple an answer as you want, because the unit that's assigned to a storage policy isn't a client, but rather a subclient, but there is a View in the SQL DB that you can use to get the answer you want. You'll want a CommServDBQuery activity with something like:

    use CommServ
    FROM [CommCellStoragePolicy]
    where storagepolicy = '***Test'

    If there are no subclients associated with a given Storage Policy, you'll get a count of 0 there.

    Obviously, it's a Good Idea to play around with that query a bit in SQL Server Management Studio before letting that loose in a workflow that kicks off Storage Policy deletion. (For example, you should probably do a regular old select * to see what all's in the table.)

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