Commvault PowerShell Module Dead Slow

Perhaps worth having a check how your CommServe has been provisioned and if MSSQL is running hot.

Other than that, perhaps one way you could improve the code efficiency by chunking up the workload into powerhsell jobs (look into Start-Job, Wait-Job, Release-Job, Remove-Job) or there are some third party modules that can help like https://github.com/nightroman/SplitPipeline.

@Yash   Same thing happens with “cvjob -clientname”   It will throw an “info” that the parameter doesnt exist, but then continues to return everything.  If you provide a specific parameter and its not found, it should bail, or at least throw error so it can be trapped. 

@Yash  I did download the new module and installed. But this module also seems to use the same amount of time. 

Get-Date
$clients = Get-CVClient
$subClientObjs = @()
foreach ($client in $clients){
    $subClients = Get-CVSubclient -ClientName $client.clientName -AllProperties
    foreach ($subClient in $subClients){
        $subClientObj = [PSCustomObject]@{
            'clientName' = $subClient.subClientProperties.subClientEntity.clientName
            'subClientName'= $subClient.subClientProperties.subClientEntity.subclientName
            'description' = $subClient.subClientProperties.commonProperties.description
            'storagePolicy' = $subClient.subClientProperties.commonProperties.storageDevice.dataBackupStoragePolicy.storagePolicyName
            'isSnapBackupEnabled' = $subClient.subClientProperties.commonProperties.snapCopyInfo.isSnapBackupEnabled
            'backupSetName' = $subClient.subClientProperties.subClientEntity.backupsetName
            'clientType' = $subClient.subClientProperties.subClientEntity.appName
            'clientInstanceName' = $subClient.subClientProperties.subClientEntity.instanceName
            'vmContents' = $subClient.subClientProperties.vmContent.children.displayName -join "`n"
            'vmFilters' =  $subClient.subClientProperties.vmFilter.children.displayName -join "`n"
            'vmDiskFilters' = $subClient.subClientProperties.vmDiskFilter.filters.filter -join "`n"
            'proxyClient' = $subClient.subClientProperties.proxyClient.clientName
            'backupPlan' = $subClient.subClientProperties.planEntity.planName
            'vmTotalCount' = $subClient.subClientProperties.vmBackupinfo.vmTotalCount
            'vmProtectedCount' = $subClient.subClientProperties.vmBackupinfo.vmProtectedCount
            'vmPendingCount' = $subClient.subClientProperties.vmBackupinfo.vmPendingCount
            'vmNeverBackedUpCount' = $subClient.subClientProperties.vmBackupinfo.vmNeverBackedUpCount
            'vmBackedUpWithErrorCount' = $subClient.subClientProperties.vmBackupinfo.vmBackedUpWithErrorCount
            'vmExcludedFromSLA' = $subClient.subClientProperties.vmSLAInfo.vmExcludedCount
            'vmMetSLACount' = $subClient.subClientProperties.vmSLAInfo.vmMetSLACount
            'vmMissedSLACount' = $subClient.subClientProperties.vmSLAInfo.vmMissedSLACount
            'lastBackupJonbId' = $subClient.subClientProperties.commonproperties.lastBackupJobInfo.JobId
            'lastBackupEndTime' = (Get-Date 01.01.1970)+([System.TimeSpan]::FromSeconds($subClient.subClientProperties.commonproperties.lastBackupJobInfo.endtime.time))
            'fsContent' = $subClient.subClientProperties.content.path -join "`n"
            }
        $subClientObjs += $subClientObj
        }
}
Get-Date

Tuesday, March 2, 2021 3:31:01 PM
DEBUG: Get-CVClient: begin
DEBUG: Get-CVSessionDetail: begin
DEBUG: Get-CVSessionDetail: process
DEBUG: Get-CVSessionDetail: end
DEBUG: Get-CVClient: process
DEBUG: Get-CVRESTHeader: begin
DEBUG: Get-CVRESTHeader: process
DEBUG: Get-CVRESTHeader: end
DEBUG: Submit-CVRESTRequest: begin
DEBUG: Submit-CVRESTRequest: process
DEBUG: Submit-CVRESTRequest: header: Accept: application/json
DEBUG: Submit-CVRESTRequest: header: Authtoken: QSDK...
DEBUG: Submit-CVRESTRequest: body: 
DEBUG: Submit-CVRESTRequest: baseUrl: http://xxxxxx:81/SearchSvc/CVWebService.svc/
DEBUG: Submit-CVRESTRequest: endpoint: Client
DEBUG: Submit-CVRESTRequest: method: Get
DEBUG: Submit-CVRESTRequest: end
DEBUG: Get-CVClient: end
DEBUG: Get-CVSubclient: begin
DEBUG: Get-CVSessionDetail: begin
DEBUG: Get-CVSessionDetail: process
DEBUG: Get-CVSessionDetail: end
DEBUG: Get-CVSubclient: process
DEBUG: Get-CVId: begin
DEBUG: Get-CVSessionDetail: begin
DEBUG: Get-CVSessionDetail: process
DEBUG: Get-CVSessionDetail: end
DEBUG: Get-CVId: process
DEBUG: GetId?clientName=TEST_IndexServer

I was trying stuff around. I am new to Commvault and I have been using PowerShell for a while. I was trying to export the list of Subclients as an html using PSWriteHTML. This makes the search very fast as compared to looking for objects using Webconsole or Java Console. Answer to your question would be I am trying to get stuff done using PowerShell, it also helps me have better understanding what goes on behind the scene. Have been using PowerShell with other products and never seen that much of a lag so initiated this discussion.