Overview

If any Historical Usage (HU) request is stuck and you want to know the current status of it, create a support ticket with any additional information that might be helpful.

Information

Mention the HU request IDs, or the ESIIDs and support will report the current status for the mentioned requests.

<supportagent>

These requests come in from Stream and are used by Stream for Commercial Accounts. Stream submits these requests from their CRM system. The system will provide HUD files with historical usage back to the client via Biz talk and web services.  The client will use that data to determine if the commercial customer's usage has enough volume to be beneficial as a customer and allows for more accurate pricing accounting for the fluctuation in usage in a commercial property.

To check the status of a HU request, execute the steps below substituting values as needed and enabling required conditions:

1. Login to the Jump server 10.185.40.141.
2. Open Microsoft SSMS and connect to aes.cons.com.
3. Select New Query in the top bar.
4. Execute the following query

   select s.Description As RequestStatus,hur.* 
   from HistoricalUsageRequest hur
   join HistoricalUsageRequestStatus s on s.RequestStatusID = hur.RequestStatusID
   where 1=1
   --and LdcAccountNumber='<ESIID number provided by client>'
   and ClientUniqueID in (<comma separated list of HU Request IDs>)
   order by 2 desc    

5. The RequestStatus column in the resultset above has the status information.

</supportagent>