CommServe database views

Hi @Onno van den Berg 

Thanks for raising this, I can bring the question around documentation for SQL Views up internally and see if we can expand on the documentation you mention to include any new additions.

As for a VOI client that also uses an agent, since you’re checking this from a licensing perspective, it may be that the agent installed removes the VM from VOI consumption.

When an agent is installed on a client manually (not using AppAware workflow), this causes the client to be considered as a physical client and would no longer be considered for VOI.

This may be the reason why some expected clients aren’t showing the VOI consumption view - a cross reference with License Summary Report to compare license consumption for specific clients might help confirm/eliminate this theory.

As this is quite a specific and detailed question, in order to get into the details for specific clients, I think a support case here may be more beneficial as we can stage your Commserve database and have these discussions that aren’t appropriate for public forums.

We can then discuss the views and put some requests to Development to really get the details you are looking for - if you would PM me the case number, I can track this internally for you.

Thanks,

Stuart

I will open a ticket and will explain my requirements. I think I'm hitting a strange issue here. As far as I know a VOI might only change into an OI in case of a specific circumstance, but normally VM's with an agent installed are reported as VOI. It is also documented here:
https://documentation.commvault.com/11.26/essential/114664_virtual_operating_instances_in_license_summary_report_02.html

But I'm seeing inconsistencies in where a VM that is protected as VM and through an agent not being reported as VOI. I however just found this:

Multiple protection methods/agents within a single VM
When a single virtual machine is protected in more than one way (i.e., multiple agents are used), a single virtual machine name will not be counted more than once against license consumption when Virtual Operating Instance metering is in use. There are no limits considered (from a license perspective) around how many applications within a single VM can be supported. However, if a virtual machine is further parsed or partitioned into multiple logically named operating entities, those individual names may be counted as their own VM, depending on how (or if) those entities are addressed for protection

Source: https://documentation.commvault.com/11.26/assets/pdf/commvault-complete-license-guide.pdf

I have interpreted this as in case you do both way than you will not see the client listed as VOI anymore.

So to keep it short I just need confirmation that a client will indeed not appear in the output of Lic_CUR_VOIs_vw once you protect it through VSA but that it will be reported as part of Lic_CUR_VOIJobs_NotInCapacity_vw.

Hi @Onno van den Berg 

Yes, we need to get to the bottom of this and the best way will be staging your Commserve database and checking this through in detail with specific examples via a support case.

SQL Views are a very low level way to view data in the Commserve database, where the user interface and license consumption may take other values into consideration.

Let’s check all these factors together and figure out the best way for you to obtain the data you need.

Thanks,

Stuart

I openend TR 220524-348

Thanks @Onno van den Berg 

I’m tracking this support case internally, Development have been engaged and we’re getting some feedback for you.

I’ll allow the case to run it’s course and then provide a summary here with the outcomes.

Thanks,

Stuart

Update: so version 2022e aka FR28 contains an updated version of the "License summary - worldwide" giving access to almost all required information, but it is lacking the hypervisor type which will be added as part of FR29 → release 2023.

I honestly do not like this route as it requires the scheduling of a report that dumps the info to CSV which we'll process and make available via a datacube. Would have been nice if this can be done directly from the database or which I'm still investigating via the restAPI.

Yes, with a small note that it does not allow you to create a new report. It is a standard Metrics report which can be exported and then be imported into another source. Not sure if you can copy the report and make changes to it without loosing the logic.

In in the meantime working on an alternative which you might noticed giving the fact that I'm chasing development to fix the v2 Powershell SDK → https://www.powershellgallery.com/packages/CommvaultPowerShell
 

Awesome, thanks!