1 Year Logs | Main | Dashboard | Grid | Ledger |   |

FrontierDataWarehouse  ACORN Script

IF EXISTS ( SELECT COUNT(*) OVER () AS Total_Rows, dmria.* FROM dbo.Dim_MeterRechargeInvestigateActivity AS dmria WITH (NOLOCK) JOIN dbo.DimMerchantGroups AS dmg WITH (NOLOCK) ON dmg.MerchantKey = dmria.TenantKey WHERE dmg.PrincipalKey = dbo.FN_MerchantKey('99887775') AND (dmria.MeterSerialNumber LIKE '%10232810%' OR dmria.TenantNumber LIKE '%10232810%' OR dmria.TenantName LIKE '%10232810%' OR dmria.HigherPrincipalName LIKE '%10232810%')) SELECT COUNT(*) OVER () AS Total_Rows, dmria.* FROM dbo.Dim_MeterRechargeInvestigateActivity AS dmria WITH (NOLOCK) JOIN dbo.DimMerchantGroups AS dmg WITH (NOLOCK) ON dmg.MerchantKey = dmria.TenantKey WHERE dmg.PrincipalKey = dbo.FN_MerchantKey('99887775') AND (dmria.MeterSerialNumber LIKE '%10232810%' OR dmria.TenantNumber LIKE '%10232810%' OR dmria.TenantName LIKE '%10232810%' OR dmria.HigherPrincipalName LIKE '%10232810%') ORDER BY dmria.PushAlerts DESC, dmria.Priority DESC, dmria.TenantName ASC ELSE SELECT 0 AS Total_Rows

1 Record. View by Lookup

990100017161 10232810 ❖  Mono Rama.. 0

Alive

Total Recharge

Averages

Replacement Tokens

Last Recharge

DLM

Hist

FBU

More

Updated

Risk

Alert

Priority

Flow

Events

Logs

Coms

Commands

Balances

Mths

Days

Units

Qty

Value

Amt

Daily Units

Freq

Monthly

Units

Qty

Value

Date

Days Since

Closing Mths

3

0

??

0

0

0

0

0

0.00

0

0

0.00

0

0

0

1900-01-01

45930

2025-09-30

0

ID 367672 BillingType 1 StockID 4889300 MeterSerialNumber 990100017161 MeterKey 4811057 TenantID 527819 TenantNumber 10232810 TenantName Mono Rama ShowIt True Priority 0 PremisesDescription House Upscale SizeSquareMeters 85 Rooms 6 Occupants 7 AmpsRating 100 DistributionBoard Outside InstallationType Standard ReplacedMeterNumber SiteRank_COT CCC DemographicComment Respected family TenantTel1 999 888 7777 TenantTel2 TenantTel3 TenanteMail monorama@msn.com HigherPrincipalName Mono Test P1 HigherPrincipalNumber 77001774 HigherPrincipalID 540957 Sector IP TenantJoinedDate 1900-01-01 MeterAllocationDate 2020-12-10 UtilityType Electricity ContractorInstalled ContractorCurrent MeterModel Enertrak Three phase ModelClass Three Phase ReportsConsumption 1 DateLastInspected 1900-01-01 DateInspectionDue 1900-01-01 DaysMeterActive 0 MonthsMeterActive 0 MonthsTenantActive 1509 BenchmarkProfile 2 AlertScore 3 PushAlerts False PushAlertsText PushAlertSource 0 LastClosingMonth 2025-09-30 LastClosingMonthHeader 2025-09-30 LastFBUunits 0 LastFBUValue 0.00 LastFBUDate 1900-01-01 ThirtyFBUunits 0 ThirtyFBUValue 0.00 SixtyFBUunits 0 SixtyFBUValue 0.00 NinetyFBUValue 0.00 AveUnitsPerDay 0 AvgHRechargeAmount 0.00 AvgHRechargeFrequency 0 AvgHRechargeMonthly 0.00 StDevHRechargeAmount 0 StDevHRechargeFrequency 0 StDevHRechargeMonthly 0 TwelveMonthHigh 0.00 TwelveMonthLow 0.00 TradingRange 0 DaysActiveLessTradingRange 45930 LastUpdated 10/2/2025 3:22:42 AM CurrentRechargeUnits 0 CurrentRechargeQty 0 CurrentRechargeValue 0 CurrentRechargeAvgHDaily 0 CurrentRechargeAvgHMonthly 0 ThirtyRechargeUnits 0 ThirtyRechargeQty 0 ThirtyRechargeValue 0 ThirtyRechargeAvgHDaily 0 ThirtyRechargeAvgHMonthly 0 SixtyRechargeUnits 0 SixtyRechargeQty 0 SixtyRechargeValue 0 SixtyRechargeAvgHDaily 0 SixtyRechargeAvgHMonthly 0 NinetyRechargeUnits 0 NinetyRechargeQty 0 NinetyRechargeValue 0 NinetyRechargeAvgHDaily 0 NinetyRechargeAvgHMonthly 0 OneTwentyRechargeUnits 0 OneTwentyRechargeQty 0 OneTwentyRechargeValue 0 OneTwentyRechargeAvgHDaily 0 OneTwentyRechargeAvgHMonthly 0 OneFiftyRechargeUnits 0 OneFiftyRechargeQty 0 OneFiftyRechargeValue 0 OneFiftyRechargeAvgHDaily 0 OneFiftyRechargeAvgHMonthly 0 OneEightyRechargeUnits 0 OneEightyRechargeQty 0 OneEightyRechargeValue 0 OneEightyRechargeAvgHDaily 0 OneEightyRechargeAvgHMonthly 0 BMDiffRechargeUpValue 0 BMDiffRechargeDownValue 0 BMDiffMonthlyUpValue 0 BMDiffMonthlyDownValue 0 BMMonthlyHighValue 0 BMMonthlyLowValue 0 BMDiffRechargeUpScore 0 BMDiffRechargeDownScore 0 BMDiffMonthlyUpScore 0 BMDiffMonthlyDownScore 0 BMMonthlyHighScore 0 BMMonthlyLowScore 3 BMStDevHRechargeAmountScore 0 BMStDevHRechargeFrequencyScore 0 BMStDevHRechargeMonthlyScore 0 BMNonRechargeDaysScore 0 BMNonRechargeDaysValue 0 BMCommunicationAbsence False BMAveUnitsPerday 0 LastOpenLog 115663 FrequencyAUpdated Oct 2 2025 3:22AM FrequencyANextUpdate Oct 3 2025 3:22AM FrequencyMUpdated FrequencyMNextUpdate LastContactDate 1900-01-01 CommunicationAbsenceDays 45930 TenantOccupied 1 TenantEntryDate 1900-01-01 TenantExitDate 1900-01-01 TenantKey 534629 MeterBalance MeterBalanceUnits Killowatts MeterBalanceType 1 MeterBalanceDate 10/2/2025 3:14:11 AM AccountBalance 0 AccountBalanceDate 10/2/2025 3:14:11 AM TimezoneUTCOffset 2 Flow 1 MeterCommandSubmissionEntry MeterCommandLastStatus 0 TotalRechargeUnits 0 TotalRechargeQty 0 TotalRechargeValue 0 ReplacementTokenUnits 0 ReplacementTokenQty 0 ReplacementTokenValue 0 DifferenceFromLastMonth 0 MeterFirstRechargeDate 1900-01-01 MeterLastRechargeDate 1900-01-01 TenantFirstRechargeDate 1900-01-01 TenantLastRechargeDate 1900-01-01 DaysSinceLastRecharge 45930 LastRechargeUnits 0 LastRechargeValue 0.00 Notes Lowered historical monthly usage TamperEventSnooze 1900-01-01 TamperEventAwake TamperEventSeverity Negligible TamperEventDate TamperEventCount 0 TamperEventOffset 0 TamperEventOffsetDate TamperEventNet 0 CreditEventSnooze 1900-01-01 CreditEventAwake CreditEventSeverity Negligible CreditEventDate CreditEventCount 0 CreditEventOffset 0 CreditEventOffsetDate CreditEventNet 0 GridEventSnooze 1900-01-01 GridEventAwake GridEventSeverity Negligible GridEventDate GridEventCount 0 GridEventOffset 0 GridEventOffsetDate GridEventNet 0 MeterEventSnooze 1900-01-01 MeterEventAwake MeterEventSeverity Negligible MeterEventDate MeterEventCount 0 MeterEventOffset 0 MeterEventOffsetDate MeterEventNet 0 LoadEventSnooze 1900-01-01 LoadEventAwake LoadEventSeverity Negligible LoadEventDate LoadEventCount 0 LoadEventOffset 0 LoadEventOffsetDate LoadEventNet 0 BreakerEventSnooze 1900-01-01 BreakerEventAwake BreakerEventSeverity Negligible BreakerEventDate BreakerEventCount 0 BreakerEventOffset 0 BreakerEventOffsetDate BreakerEventNet 0

 

IF EXISTS ( SELECT COUNT(*) OVER () AS Total_Rows, dmria.* FROM dbo.Dim_MeterRechargeInvestigateActivity AS dmria WITH (NOLOCK) JOIN dbo.DimMerchantGroups AS dmg WITH (NOLOCK) ON dmg.MerchantKey = dmria.TenantKey WHERE dmg.PrincipalKey = dbo.FN_MerchantKey('99887775') AND (dmria.MeterSerialNumber LIKE '%10232810%' OR dmria.TenantNumber LIKE '%10232810%' OR dmria.TenantName LIKE '%10232810%' OR dmria.HigherPrincipalName LIKE '%10232810%')) SELECT COUNT(*) OVER () AS Total_Rows, dmria.* FROM dbo.Dim_MeterRechargeInvestigateActivity AS dmria WITH (NOLOCK) JOIN dbo.DimMerchantGroups AS dmg WITH (NOLOCK) ON dmg.MerchantKey = dmria.TenantKey WHERE dmg.PrincipalKey = dbo.FN_MerchantKey('99887775') AND (dmria.MeterSerialNumber LIKE '%10232810%' OR dmria.TenantNumber LIKE '%10232810%' OR dmria.TenantName LIKE '%10232810%' OR dmria.HigherPrincipalName LIKE '%10232810%') ORDER BY dmria.PushAlerts DESC, dmria.Priority DESC, dmria.TenantName ASC ELSE SELECT 0 AS Total_Rows