I need a simple CommServ database query to query a server and let me know if it has an iDataAgent or it's backed up via VADP.

Thanks

We looked into coming up with one and it might not be as simple as we think  have you tried reaching out to personalization? They may be able to help - personalization@commvault.com

are you just looking to see if the client is backed up twice?

there is a commcell cleanup report that shows clients with multple schedules that is usefull for that purpose. if it has more than 1 schedule it culd mean two agents are backing it up.

https://documentation.commvault.com/commvault/v11/article?p=38297.htm

The cleanup report will not work. I need this CommServ query for a workflow to make a decision on which decommissioning process to run. If the server is backed up via VADP then the VADP workflow will run. If the server has an iDataAgent installed, then the client decommissioning process will run.

Hi,

How will you be determining which clients qualify for decommissioning?

The server to be decommissioned is selected by the admin or owner of the server. Then a SNOW ticket is generated for the selected server to be decommissioned. I have my workflow completed for the decomissioniung of the servers, however; the SNOW engineer wants to run a query on the CommServ database to determine if the selected server is backed up via VADP or iDataAgent which is needed for his workflow and error checking in SNOW.

The simInstalledPackages and simInstalledPackagesHistory tables give you information on software currently installed and previously installed on the system respectively. Absence of any rows in the simInstalledPackages table means that machine currently does not have any commvault software installed and it could mean that it is a vm. Not sure if this is useful for you. Note that the machine may have been earlier backed up using FS but currently uninstalled and also vms could technically have additional packages installed either currently or in the past. If you want to know whether the machine was ever backed up using vadp regardless of any other commvault software installed on it then I will have to find another mechanism for that.