1. Stop billing agent service.
2. Execute the below SQL script to
check the value of AzureStackUsageRecordProcessor-AzureStackUsage
SELECT TOP (1000)
[StateName]
,[LastUsageId]
,[LastProcessedTime]
,[LastSeenTime]
,[LastUsageIdData]
FROM
[CloudAssert.Billing].[dbo].[UsageProcessingStates]
3. Change the value of
AzureStackUsageRecordProcessor-AzureStackUsage appropriately.
{"ContinuationToken":"","ReportedStartTime":"2019-08-01T00:00:00Z","ReportedEndTime":"2019-08-02T00:00:00Z"}
4. Restart the Billing Agent service.
5. Execute the below SQL script.
BILLING.EXE GetAzureStackUsageData <startTime>
<endTime> [/usageRequestType:<String>]
[/takeBatchSize:<String>] [/AdminSubscriptionId:<String>]
[/TenantDirectoryId:<String>] [/ApplicaionId:<String>] [/CertificateThumbprint:<String>]
[/AdminArmEndpoint:<String>] [/TokenRequestResourceUrl:<String>] [/AuthorityEndpointUrl:<String>]