Overview

You want to determine the number of active customers in ERCOT with a smart meter.

Solution

Please raise a support ticket with us and we will share the information.

We will also provide the SQL script for this report if requested and you can run the query on the replication database in your environment.

<supportagent>

This solution is specific to the client, Spark Energy. The client should have access to the replication database to run the query. Agents do not have access to the replication database. 

Prerequisites:

• Access to the Client database

Solution Steps:

1. Run the select query below to get the requested information.
   

   Select ESIIDid [UAN], IsSmartMeter, SmartMeterType, 
   l.ldcshortname, l.marketcode, status
   From Paes_TDSP..ESIID TE
   Join Paes_Spark..Premise P on P.Premno = TE.ESIID
   join paes_spark..ldc l on p.ldcid = l.ldcid
   Where 1=1
   and TE.IsSmartMeter = 1
   and P.statusid = 10

    

2. Share the query result with the client.
   Also, share the SQL with the client, if requested.

</supportagent>