Hi Morgan ,

We have checked database group table for those anomalous batch of groups under the title "derainsg14" but it is not possible to found that who is entered those groups because in our existing table structure there are no any field like when data is entered and who is the user.

We have seen all "derainsg14" entries in group table and found that the data is entered for "Number of Individual Account" and all Individual account number is different so we assume that these entries are created by any user from Group creation page.

We will add following two fields in existing table so in future we will catch up the log who did this kind of entries.

1) Created By - User Name
2) Date  

Also, Please let us know how we will deal with those entries ? Can we delete from table ?

Ok. Thanks Harsh . Will these new columns be visible to admin user on the group page, or is this just something you'll see within the back-end of the database?

Yes, please delete all the groups titled "derainsg14", and we'll monitor things going forward.

Morgan

Hi Morgan  

It is just for back end database. If anything this kind of activity will happen in future then will help us to find how this things occured.

OK. Sounds good Harsh . Let's proceed with deleting the groups, and we'll monitor things going forward.

Morgan 

Hi Morgan ,

We have removed "derainsg14" group entries from  www.islg' s database and currently we are working on to add additional two columns (Created By and Created On). 

Great. Thanks Harsh ​.

Marysia ​, could you please take a look and confirm that everything is in order.

Thanks,

Morgan

Hi Morgan,

Everything looks back to normal. 

Thanks,

Marysia

Ok. Thanks Marysia . Please let us know if see any other anomalous groups going forward.

Harsh , I'll mark this to-do complete when you've completed adding the additional fields in the back-end of the database.
 
Thanks,

Morgan 

Sure, I will let you know. Marysia

Hi Harsh ,

I'm following up to see if the additional fields have been added to the back-end of the database so that we can track who and when groups are added. Please confirm.

Thanks,

Morgan 

Hi Morgan ,

We have added fields to the back-end on dev.islg. Please confirm when will migrate this change on www.islg.

Great. Thanks Harsh . I'll schedule this for migration to www.islg on Tuesday.

Morgan 

Hi Morgan ,

This task has migrated on www.islg.

Thanks Harsh . Is there any way outside of accessing the database for us to confirm?

Ryan

Ryan , I'm fine with having to pull the entries directly from the SQL database to confirm this information. This should only occur in rare circumstances where we get these anomalous entries.

I'll mark the to-do complete.

Morgan