You want all of the GA accounts with the details Customer Name, Ista Account Number, LDC #, Service Address, and Account Status. You may also request the SQL script for this report.
Please raise a support ticket with us specifying the set of details (as mentioned above) you are looking for. We will share the report and the SQL script for this report.
Access to the Client database
1. Run the query below.
Select Distinct CustName[CustomerName],
Concat(Addr1,'',addr2,' ',city,' ',State,' ',Zip)[Service Address],
From Customer C
Join Premise P on P.CustID=C.CustID
Join LDC L on L.LDCID=P.TDSP
Join Market M on M.MarketID=L.MarketID
Join Address A on A.addrID=P.addrID
Join PremiseStatus PS on Ps.PremiseStatusID=P.StatusID
2. Share the query result with the client.
If the SQL script is requested, share the query from the previous step.