RECOVERING DELETED THE RAW USAGE RECORDS

RECOVERING DELETED THE RAW USAGE RECORDS

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



    • Related Articles

    • How to uninstall VConnect and Usage and Billing?

      If there is a need to retain all existing data (i.e., VMs, subscriptions, etc.) when installing the new version, then refer to UPGRADE INSTALL sections below. If all existing data needs to be cleaned then choose FRESH INSTALL sections below. VCONNECT ...
    • Use of Formula while setting Metered Resource pricing in Cloud Assert Usage and Billing Solution

      Use of Formula Formula are used to modify the units obtained from the raw usage data of resources before computing the price for the resource. There are two types of formula ‘Unit Formula’ and ‘Custom Formula’. i.            Unit Formula It ...
    • Testing the connectivity to a Microsoft SQL server

      To perform a UDL test to check the connectivity from a Windows server to a Microsoft SQL server instance and database. Create a data link (UDL) file Right-click on the Windows desktop and navigate to New > Text Document. A new file is created by ...
    • Adding Usage+Quota

      Usage + Quota is a licensed feature for MAS - Billing Solution. Steps to enable this feature Step 1: Copy the Application ID from Admin Portal --> Billing -->Settings --> Azure Stack Usage Collector Settings Step 2: Goto Admin Portal --> ...
    • Invoices from Usage and Billing Solutionin WAP is not sent to WHMCS portal

      If the invoices are generated in WHMCS portal with zero amount for the previous month, please delete them and ensure the below steps.   Open ‘CloudAssert.WAP.Billing.AgentService.exe.config’ file located at ‘C:\Program Files\ CloudAssertBilling\ ...