License information

[b.vanhaastrecht]

Hello,

I would like to fetch the license information from the Enterprise Portal thru Powershell or the RestAPI. But I'm unable to find an CMDlet or schema providing this information. Is that correct?

I'm primairly interested in the support expiry date. What are my options to get it thru scripting?

Kind Regards,
Bastiaan

[veremin]

As far as I know, information regarding license is not present in PowerShell, neither is it in RESTful API. The only way I can think of is to query db directly. Thanks.

[PTide]

Hi,

Please try this:

Code: Select all

$regBinary = (Get-Item 'HKLM:\SOFTWARE\VeeaM\Veeam Backup and Replication\license').GetValue('Lic1')
$veeamLicInfo = [string]::Join($null, ($regBinary | % { [char][int]$_; }))

Kudos to this guy

[b.vanhaastrecht]

Getting it thru the registry works, thanks! (had to adjuist the verison checking, but it works)

Would prefer something Veeam supported like RestAPI or PowerShell CMDlet, so I do not have to worry about this custom script to get incompliant with upcoming Veeam version upgrade.

So a feature request to fetch license information thru RestAPI or PowerShell please.

[veremin]

Your voice about availability of license information in our automation services has been heard. Thanks for the feedback; appreciated.

[tom.adams]

Hello,

Under the License Information window in the Veeam Gui, does anyone know how to obtain these two values?

Cloud Connect (Backup)
Cloud Connect (Replica)

I could do with accessing the information via powershell, c# or the rest api as we are importing the information into another application. Just to clarify, i'm not looking for the information stored in the license, i'm looking to obtain the "Used" amount.

Any help is appreciated. Cheers

[veremin]

General information:

Code: Select all

$BackupCount = 0
$ReplicaCount = 0 
foreach ($Tenant in Get-VBRCloudTenant)
{
    $BackupCount = $BackupCount + $Tenant.VMCount
    $ReplicaCount = $ReplicaCount + $Tenant.ReplicaCount
}
$BackupCount, $ReplicaCount

Information per tenant:

Code: Select all

Get-VBRCloudTenant | select -Property @{N="Tenant";E={$_.name}}, @{N="Backup Count";E={$_.VMCount}}, @{N="Replica Count";E={$_.ReplicaCount}} | ft   

Thanks.

[tom.adams]

Thanks Vladimir,

I had to update the script you provided slightly as we have some cloud tenants that are disabled or they have an expiration date which has now expired.
Here is the updated script just in case someone needs the same information

Code: Select all

$BackupCount = 0
$ReplicaCount = 0 

Get-VBRCloudTenant | Where-Object {($_.Enabled -eq $TRUE) -and (($_.LeaseExpirationEnabled -eq $FALSE) -or (($_.LeaseExpirationEnabled -eq $TRUE) -and ($_.LeaseExpirationDate -gt (Get-Date))))} | ForEach-Object {
$BackupCount = $BackupCount + $_.VMCount
$ReplicaCount = $ReplicaCount + $_.ReplicaCount
}

$BackupCount, $ReplicaCount

Before it was slightly off with the values but now it seems to be reporting correctly. Many Thanks!

[veremin]

Glad to hear my input was helpful. The updated script looks good, thanks for sharing!

[onthax]

Hi All,

We are trying to report on our license count, can either do this from powershell or sql to inject it into our monitoring server and get backup license trending.

what we've found recently is that our licensing in veeam is far in excess of what we see from our SQL query and what we expect in the environment. (Over 100 protected VMs higher)

Anyone aware of an SQL query that can be run against the veeam database to return this number

[PTide]

Hi Onthax,

Please review the thread and feel free to ask additional questions if any arise.

Thank you.

[toxicavenger]

Hi,

Is there a way to extract some infomation about the current license in use through powershell. I need informations like number of VMs assigned to our license and how much we got left.

[RubinCompServ]

I've reviewed the thread (and others) and I don't see an answer to this question. I want to generate a list (wither via SQL or PowerShell) of all the VMs that are currently licensed (in other words, the list that appears in the "Licensed VMs" dialog box).

[veremin]

What kind of license are you using? VCSP rental, VCSP Cloud Connect rental, etc.? Depending on the answer, we might propose a way to get the requested information even without scripting. Thanks.

[RubinCompServ]

A combination of Rental and Cloud Connect.

[onthax]

+1 on the feature request for RESTAPI access to licensing information, particularly if you are multi tenant and need to sort them by customer.

[RubinCompServ]

As far as I know, information regarding license is not present in PowerShell, neither is it in RESTful API. The only way I can think of is to query db directly. Thanks.

I had a great script that would query the database and could extract usage information by customer. Unfortunately, the "LicensedVMs" table went away with 9.5 U4 and Cloud Connect VMs now only count as a fraction of an instance, so I have to start from scratch. I also give a +1 for this feature, since it seems like even VeeamONE can't collate everything together into a single report.

[veremin]

We do plan to make this information available in PowerShell in one of the next product releases. Thanks!

[riahc3]

Hello

I want to get the remaining days left in a license on a local system via Powershell.

How can I do this?

[DGrinev]

Hi John,

In the current version of the product you cannot obtain the license information through the Powershell.
Your voice has been counted as a feature request, thank you!

[riahc3]

What way do you recommend getting license information in a text output?


Even a SQL query would be fine.

[riahc3]

Nothing at all?

[DGrinev]

Hi John,

Can you share the scenario for getting license information in text, maybe we can consider another approach in solving the objective? Thanks!

[veremin]

You can license expiration date, using this script:

Code: Select all

$regBinary = (Get-Item 'HKLM:\SOFTWARE\VeeaM\Veeam Backup and Replication\license').GetValue('Lic1')
$veeamLicInfo = [string]::Join($null, ($regBinary | % { [char][int]$_; }))  
$ExpirationDateFormat = "Expiration date\=\d{1,2}\/\d{1,2}\/\d{1,4}"
$ExpirationDate = [regex]::matches($VeeamLicInfo, $ExpirationDateFormat)[0].Value.Split("=")[1]
$ExpirationDate

Then, you will need to convert $ExpirationDate to DateTime and subtract current date from it. The resulting value (output in days) will be number of days left till license expiration.

Thanks!

[riahc3]

Hi John,

Can you share the scenario for getting license information in text, maybe we can consider another approach in solving the objective? Thanks!

Monitoring. Getting licence date/time and depending on that, launch a warning email alert and then a critical alert.

[riahc3]

You can license expiration date, using this script:

Code: Select all

$regBinary = (Get-Item 'HKLM:\SOFTWARE\VeeaM\Veeam Backup and Replication\license').GetValue('Lic1')
$veeamLicInfo = [string]::Join($null, ($regBinary | % { [char][int]$_; }))  
$ExpirationDateFormat = "Expiration date\=\d{1,2}\/\d{1,2}\/\d{1,4}"
$ExpirationDate = [regex]::matches($VeeamLicInfo, $ExpirationDateFormat)[0].Value.Split("=")[1]
$ExpirationDate

Then, you will need to convert $ExpirationDate to DateTime and subtract current date from it. The resulting value (output in days) will be number of days left till license expiration.

Thanks!

I can work with this, thanks.

The output format though

Is it month/day or day/month?

[veremin]

In my lab the output is provided in day/month format. Thanks!