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>]