Update Account in REACDR Table Based on Originating Device

Let’s say the originating device for IP address “1.1.1.1” was not provisioned in the GUI, OSPrey linked the device to Customer Account (aka SourceGroup) “none”, and Rating engine skipped the CDR. Now you want to set the SourceGroup to “SomeAccountName” and change Updatable from ’S’ (skipped) to ‘Y’ (ready for rating)

update reaCDR
set
SourceGroup = 'SomeAccountName',
Updatable = 'Y'
where
Updatable = 'S'
and
SourceGroup = 'none'
and
SourceDeviceName = '1.1.1.1'