added green advisor db and report