This browser is no longer supported.
Upgrade to Microsoft Edge to take advantage of the latest features, security updates, and technical support.
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(188.79999999999998, 70%, 28%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EYL%3C/text%3E%3C/svg%3E)
Hi there,
I'm using the rest api mentioned here https://video2.skills-academy.com/en-us/azure-stack/operator/azure-stack-tenant-resource-usage-api?view=azs-2008 to get instances usage information, I have a SQL Server (sqlVM) running on a Virtual Machine sqlVM, I created this via SQL Virtual Machine.
However, when I used the rest api to get usage for both database and virtual machine, they return the same resourceId information.
Here is the VM
Here is the SQL VM
I know the SQL Server runs as a software on the VM but I still believe the resource Id for them would be different because I saw there is a different resourceId for SQL VM specifically (/subscriptions/{subscription}/resourceGroups/{group}/providers/Microsoft.SqlVirtualMachine/sqlVirtualMachines/sqlVM)
Should the rest api return a different resource id for the SQL VM than the VM?
I will verify that this is intended, but what is important for billing purposes is the 'Meter Category' and 'Meter Subcategory'.
The different resource IDs are how the portal / Azure handles resource providers, which is not necessarily the way it is handled in billing.
OK, thank you for your reply.
As per you replied, I'm wondering if the second screen shot I provided (SQL VM billing one) is for the SQL VM. The resourceId of the SQL VM instance in our system is /subscriptions/{subscription}/resourceGroups/{group}/providers/Microsoft.SqlVirtualMachine/sqlVirtualMachines/sqlVM.
But from the body of the REST API response, it shows "/subscriptions/{subscription}/resourceGroups/{group}/providers/Microsoft.Compute/virtualMachines/sqlVM", this is intended and not a mistake because the 'Meter Subcategory' is SQL Server Standard.
Actually our SQL VM is using the SQL Server Standard License.
In our system, we are connecting the instance with their billing record by resourceId, so in our case, if I find the 'Meter Subcategory' is a SQL Server License and the 'Meter Category' is 'Virtual machines License', then I can tell that this billing record is for the SQL VM (e.g. /subscriptions/{subscription}/resourceGroups/{group}/providers/Microsoft.SqlVirtualMachine/sqlVirtualMachines/sqlVM) running on the VM using resourceId (e.g. /subscriptions/{subscription}/resourceGroups/{group}/providers/Microsoft.Compute/virtualMachines/sqlVM) from the response body.