SELECT '360insights',_userID, _group, _expectedHoursMonth FROM `360insights`.client_user_group WHERE _group NOT IN ('Unassigned') UNION (SELECT '3E',_userID, _group, _expectedHoursMonth FROM `3e`.client_user_group WHERE _group NOT IN ('Unassigned')) UNION (SELECT '3X',_userID, _group, _expectedHoursMonth FROM `3x`.client_user_group WHERE _group NOT IN ('Unassigned')) UNION (SELECT '6sense',_userID, _group, _expectedHoursMonth FROM `6sense`.client_user_group WHERE _group NOT IN ('Unassigned')) UNION (SELECT 'Abbyy',_userID, _group, _expectedHoursMonth FROM `abbyy`.client_user_group WHERE _group NOT IN ('Unassigned')) UNION (SELECT 'AbOvo',_userID, _group, _expectedHoursMonth FROM `abovo`.client_user_group WHERE _group NOT IN ('Unassigned')) UNION (SELECT 'Agiloft',_userID, _group, _expectedHoursMonth FROM `agiloft`.client_user_group WHERE _group NOT IN ('Unassigned')) UNION (SELECT 'Assent',_userID, _group, _expectedHoursMonth FROM `assent`.client_user_group WHERE _group NOT IN ('Unassigned')) UNION (SELECT 'AST',_userID, _group, _expectedHoursMonth FROM `ast`.client_user_group WHERE _group NOT IN ('Unassigned')) UNION (SELECT 'AveryDennison',_userID, _group, _expectedHoursMonth FROM `averydennison`.client_user_group WHERE _group NOT IN ('Unassigned')) UNION (SELECT 'Bestpass',_userID, _group, _expectedHoursMonth FROM `bestpass`.client_user_group WHERE _group NOT IN ('Unassigned')) UNION (SELECT 'Blend360',_userID, _group, _expectedHoursMonth FROM `blend360`.client_user_group WHERE _group NOT IN ('Unassigned')) UNION (SELECT 'Brennan',_userID, _group, _expectedHoursMonth FROM `brennan`.client_user_group WHERE _group NOT IN ('Unassigned')) UNION (SELECT 'Brightcove',_userID, _group, _expectedHoursMonth FROM `brightcove`.client_user_group WHERE _group NOT IN ('Unassigned')) UNION (SELECT 'BRP',_userID, _group, _expectedHoursMonth FROM `brp`.client_user_group WHERE _group NOT IN ('Unassigned')) UNION (SELECT 'Carenet',_userID, _group, _expectedHoursMonth FROM `carenet`.client_user_group WHERE _group NOT IN ('Unassigned')) UNION (SELECT 'Cellebrite',_userID, _group, _expectedHoursMonth FROM `cellebrite`.client_user_group WHERE _group NOT IN ('Unassigned')) UNION (SELECT 'Certinia',_userID, _group, _expectedHoursMonth FROM `certinia`.client_user_group WHERE _group NOT IN ('Unassigned')) UNION (SELECT 'Ciklum',_userID, _group, _expectedHoursMonth FROM `ciklum`.client_user_group WHERE _group NOT IN ('Unassigned')) UNION (SELECT 'CloudBees',_userID, _group, _expectedHoursMonth FROM `cloudbees`.client_user_group WHERE _group NOT IN ('Unassigned')) UNION (SELECT 'Code42',_userID, _group, _expectedHoursMonth FROM `code42`.client_user_group WHERE _group NOT IN ('Unassigned')) UNION (SELECT 'ConnectWise',_userID, _group, _expectedHoursMonth FROM `connectwise`.client_user_group WHERE _group NOT IN ('Unassigned')) UNION (SELECT 'Corcentric',_userID, _group, _expectedHoursMonth FROM `corcentric`.client_user_group WHERE _group NOT IN ('Unassigned')) UNION (SELECT 'COREHigherEd',_userID, _group, _expectedHoursMonth FROM `corehighered`.client_user_group WHERE _group NOT IN ('Unassigned')) UNION (SELECT 'DAS42',_userID, _group, _expectedHoursMonth FROM `das42`.client_user_group WHERE _group NOT IN ('Unassigned')) UNION (SELECT 'DataPoint',_userID, _group, _expectedHoursMonth FROM `datapoint`.client_user_group WHERE _group NOT IN ('Unassigned')) UNION (SELECT 'DatosInsights',_userID, _group, _expectedHoursMonth FROM `datosinsights`.client_user_group WHERE _group NOT IN ('Unassigned')) UNION (SELECT 'Deepwatch',_userID, _group, _expectedHoursMonth FROM `deepwatch`.client_user_group WHERE _group NOT IN ('Unassigned')) UNION (SELECT 'DELMIA',_userID, _group, _expectedHoursMonth FROM `delmia`.client_user_group WHERE _group NOT IN ('Unassigned')) UNION (SELECT 'Devo',_userID, _group, _expectedHoursMonth FROM `devo`.client_user_group WHERE _group NOT IN ('Unassigned')) UNION (SELECT 'Diligent',_userID, _group, _expectedHoursMonth FROM `diligent`.client_user_group WHERE _group NOT IN ('Unassigned')) UNION (SELECT 'Docker',_userID, _group, _expectedHoursMonth FROM `docker`.client_user_group WHERE _group NOT IN ('Unassigned')) UNION (SELECT 'DPR',_userID, _group, _expectedHoursMonth FROM `dpr`.client_user_group WHERE _group NOT IN ('Unassigned')) UNION (SELECT 'DuckCreek',_userID, _group, _expectedHoursMonth FROM `duckcreek`.client_user_group WHERE _group NOT IN ('Unassigned')) UNION (SELECT 'EDB',_userID, _group, _expectedHoursMonth FROM `edb`.client_user_group WHERE _group NOT IN ('Unassigned')) UNION (SELECT 'Ellucian',_userID, _group, _expectedHoursMonth FROM `ellucian`.client_user_group WHERE _group NOT IN ('Unassigned')) UNION (SELECT 'Emburse',_userID, _group, _expectedHoursMonth FROM `emburse`.client_user_group WHERE _group NOT IN ('Unassigned')) UNION (SELECT 'Employbridge',_userID, _group, _expectedHoursMonth FROM `employbridge`.client_user_group WHERE _group NOT IN ('Unassigned')) UNION (SELECT 'EMS',_userID, _group, _expectedHoursMonth FROM `ems`.client_user_group WHERE _group NOT IN ('Unassigned')) UNION (SELECT 'eOriginal',_userID, _group, _expectedHoursMonth FROM `eoriginal`.client_user_group WHERE _group NOT IN ('Unassigned')) UNION (SELECT 'EPAM',_userID, _group, _expectedHoursMonth FROM `epam`.client_user_group WHERE _group NOT IN ('Unassigned')) UNION (SELECT 'Episerver',_userID, _group, _expectedHoursMonth FROM `episerver`.client_user_group WHERE _group NOT IN ('Unassigned')) UNION (SELECT 'Equiteq',_userID, _group, _expectedHoursMonth FROM `equiteq`.client_user_group WHERE _group NOT IN ('Unassigned')) UNION (SELECT 'Ergotron',_userID, _group, _expectedHoursMonth FROM `ergotron`.client_user_group WHERE _group NOT IN ('Unassigned')) UNION (SELECT 'EROAD',_userID, _group, _expectedHoursMonth FROM `eroad`.client_user_group WHERE _group NOT IN ('Unassigned')) UNION (SELECT 'EverDriven',_userID, _group, _expectedHoursMonth FROM `everdriven`.client_user_group WHERE _group NOT IN ('Unassigned')) UNION (SELECT 'Exclaimer',_userID, _group, _expectedHoursMonth FROM `exclaimer`.client_user_group WHERE _group NOT IN ('Unassigned')) UNION (SELECT 'Exiger',_userID, _group, _expectedHoursMonth FROM `exiger`.client_user_group WHERE _group NOT IN ('Unassigned')) UNION (SELECT 'FARO',_userID, _group, _expectedHoursMonth FROM `faro`.client_user_group WHERE _group NOT IN ('Unassigned')) UNION (SELECT 'Fastmarkets',_userID, _group, _expectedHoursMonth FROM `fastmarkets`.client_user_group WHERE _group NOT IN ('Unassigned')) UNION (SELECT 'FounderShield',_userID, _group, _expectedHoursMonth FROM `foundershield`.client_user_group WHERE _group NOT IN ('Unassigned')) UNION (SELECT 'FuelCycle',_userID, _group, _expectedHoursMonth FROM `fuelcycle`.client_user_group WHERE _group NOT IN ('Unassigned')) UNION (SELECT 'GetWell',_userID, _group, _expectedHoursMonth FROM `getwell`.client_user_group WHERE _group NOT IN ('Unassigned')) UNION (SELECT 'GibraltarBA',_userID, _group, _expectedHoursMonth FROM `gibraltarba`.client_user_group WHERE _group NOT IN ('Unassigned')) UNION (SELECT 'GibraltarMAPS',_userID, _group, _expectedHoursMonth FROM `gibraltarmaps`.client_user_group WHERE _group NOT IN ('Unassigned')) UNION (SELECT 'GlobalAtlantic',_userID, _group, _expectedHoursMonth FROM `globalatlantic`.client_user_group WHERE _group NOT IN ('Unassigned')) UNION (SELECT 'GoTo',_userID, _group, _expectedHoursMonth FROM `goto`.client_user_group WHERE _group NOT IN ('Unassigned')) UNION (SELECT 'Grax',_userID, _group, _expectedHoursMonth FROM `grax`.client_user_group WHERE _group NOT IN ('Unassigned')) UNION (SELECT 'Housecall Pro',_userID, _group, _expectedHoursMonth FROM `housecall pro`.client_user_group WHERE _group NOT IN ('Unassigned')) UNION (SELECT 'HP',_userID, _group, _expectedHoursMonth FROM `hp`.client_user_group WHERE _group NOT IN ('Unassigned')) UNION (SELECT 'Hyland',_userID, _group, _expectedHoursMonth FROM `hyland`.client_user_group WHERE _group NOT IN ('Unassigned')) UNION (SELECT 'Infor',_userID, _group, _expectedHoursMonth FROM `infor`.client_user_group WHERE _group NOT IN ('Unassigned')) UNION (SELECT 'IQBackOffice',_userID, _group, _expectedHoursMonth FROM `iqbackoffice`.client_user_group WHERE _group NOT IN ('Unassigned')) UNION (SELECT 'iSpot',_userID, _group, _expectedHoursMonth FROM `ispot`.client_user_group WHERE _group NOT IN ('Unassigned')) UNION (SELECT 'IWIK',_userID, _group, _expectedHoursMonth FROM `iwik`.client_user_group WHERE _group NOT IN ('Unassigned')) UNION (SELECT 'Jaggaer',_userID, _group, _expectedHoursMonth FROM `jaggaer`.client_user_group WHERE _group NOT IN ('Unassigned')) UNION (SELECT 'JellyVision',_userID, _group, _expectedHoursMonth FROM `jellyvision`.client_user_group WHERE _group NOT IN ('Unassigned')) UNION (SELECT 'KennedyIntelligence',_userID, _group, _expectedHoursMonth FROM `kennedyintelligence`.client_user_group WHERE _group NOT IN ('Unassigned')) UNION (SELECT 'KomodoHealth',_userID, _group, _expectedHoursMonth FROM `komodohealth`.client_user_group WHERE _group NOT IN ('Unassigned')) UNION (SELECT 'Liongard',_userID, _group, _expectedHoursMonth FROM `liongard`.client_user_group WHERE _group NOT IN ('Unassigned')) UNION (SELECT 'LogicGate',_userID, _group, _expectedHoursMonth FROM `logicgate`.client_user_group WHERE _group NOT IN ('Unassigned')) UNION (SELECT 'LogicSource',_userID, _group, _expectedHoursMonth FROM `logicsource`.client_user_group WHERE _group NOT IN ('Unassigned')) UNION (SELECT 'MadCap',_userID, _group, _expectedHoursMonth FROM `madcap`.client_user_group WHERE _group NOT IN ('Unassigned')) UNION (SELECT 'Mansfield',_userID, _group, _expectedHoursMonth FROM `mansfield`.client_user_group WHERE _group NOT IN ('Unassigned')) UNION (SELECT 'Masttro',_userID, _group, _expectedHoursMonth FROM `masttro`.client_user_group WHERE _group NOT IN ('Unassigned')) UNION (SELECT 'Medallia',_userID, _group, _expectedHoursMonth FROM `medallia`.client_user_group WHERE _group NOT IN ('Unassigned')) UNION (SELECT 'MetLife',_userID, _group, _expectedHoursMonth FROM `metlife`.client_user_group WHERE _group NOT IN ('Unassigned')) UNION (SELECT 'Momentus',_userID, _group, _expectedHoursMonth FROM `momentus`.client_user_group WHERE _group NOT IN ('Unassigned')) UNION (SELECT 'MultiPlan',_userID, _group, _expectedHoursMonth FROM `multiplan`.client_user_group WHERE _group NOT IN ('Unassigned')) UNION (SELECT 'Nextdoor',_userID, _group, _expectedHoursMonth FROM `nextdoor`.client_user_group WHERE _group NOT IN ('Unassigned')) UNION (SELECT 'Northwind',_userID, _group, _expectedHoursMonth FROM `northwind`.client_user_group WHERE _group NOT IN ('Unassigned')) UNION (SELECT 'Novata',_userID, _group, _expectedHoursMonth FROM `novata`.client_user_group WHERE _group NOT IN ('Unassigned')) UNION (SELECT 'OFX',_userID, _group, _expectedHoursMonth FROM `ofx`.client_user_group WHERE _group NOT IN ('Unassigned')) UNION (SELECT 'PCS',_userID, _group, _expectedHoursMonth FROM `pcs`.client_user_group WHERE _group NOT IN ('Unassigned')) UNION (SELECT 'Phoenix',_userID, _group, _expectedHoursMonth FROM `phoenix`.client_user_group WHERE _group NOT IN ('Unassigned')) UNION (SELECT 'PlanITROI',_userID, _group, _expectedHoursMonth FROM `planitroi`.client_user_group WHERE _group NOT IN ('Unassigned')) UNION (SELECT 'Plume',_userID, _group, _expectedHoursMonth FROM `plume`.client_user_group WHERE _group NOT IN ('Unassigned')) UNION (SELECT 'PrescientEdge',_userID, _group, _expectedHoursMonth FROM `prescientedge`.client_user_group WHERE _group NOT IN ('Unassigned')) UNION (SELECT 'ProcessUnity',_userID, _group, _expectedHoursMonth FROM `processunity`.client_user_group WHERE _group NOT IN ('Unassigned')) UNION (SELECT 'PSPDFkit',_userID, _group, _expectedHoursMonth FROM `pspdfkit`.client_user_group WHERE _group NOT IN ('Unassigned')) UNION (SELECT 'Qlik',_userID, _group, _expectedHoursMonth FROM `qlik`.client_user_group WHERE _group NOT IN ('Unassigned')) UNION (SELECT 'QuakerHoughton',_userID, _group, _expectedHoursMonth FROM `quakerhoughton`.client_user_group WHERE _group NOT IN ('Unassigned')) UNION (SELECT 'Quantum',_userID, _group, _expectedHoursMonth FROM `quantum`.client_user_group WHERE _group NOT IN ('Unassigned')) UNION (SELECT 'Rackspace',_userID, _group, _expectedHoursMonth FROM `rackspace`.client_user_group WHERE _group NOT IN ('Unassigned')) UNION (SELECT 'RCG',_userID, _group, _expectedHoursMonth FROM `rcg`.client_user_group WHERE _group NOT IN ('Unassigned')) UNION (SELECT 'Recognize',_userID, _group, _expectedHoursMonth FROM `recognize`.client_user_group WHERE _group NOT IN ('Unassigned')) UNION (SELECT 'Reorg',_userID, _group, _expectedHoursMonth FROM `reorg`.client_user_group WHERE _group NOT IN ('Unassigned')) UNION (SELECT 'RetailStat',_userID, _group, _expectedHoursMonth FROM `retailstat`.client_user_group WHERE _group NOT IN ('Unassigned')) UNION (SELECT 'Ricoh',_userID, _group, _expectedHoursMonth FROM `ricoh`.client_user_group WHERE _group NOT IN ('Unassigned')) UNION (SELECT 'RicohDM',_userID, _group, _expectedHoursMonth FROM `ricohdm`.client_user_group WHERE _group NOT IN ('Unassigned')) UNION (SELECT 'RicohGC',_userID, _group, _expectedHoursMonth FROM `ricohgc`.client_user_group WHERE _group NOT IN ('Unassigned')) UNION (SELECT 'RicohNA',_userID, _group, _expectedHoursMonth FROM `ricohna`.client_user_group WHERE _group NOT IN ('Unassigned')) UNION (SELECT 'Ridecell',_userID, _group, _expectedHoursMonth FROM `ridecell`.client_user_group WHERE _group NOT IN ('Unassigned')) UNION (SELECT 'SaGo',_userID, _group, _expectedHoursMonth FROM `sago`.client_user_group WHERE _group NOT IN ('Unassigned')) UNION (SELECT 'Sandler',_userID, _group, _expectedHoursMonth FROM `sandler`.client_user_group WHERE _group NOT IN ('Unassigned')) UNION (SELECT 'SandlerNetwork',_userID, _group, _expectedHoursMonth FROM `sandlernetwork`.client_user_group WHERE _group NOT IN ('Unassigned')) UNION (SELECT 'SAP',_userID, _group, _expectedHoursMonth FROM `sap`.client_user_group WHERE _group NOT IN ('Unassigned')) UNION (SELECT 'SAS',_userID, _group, _expectedHoursMonth FROM `sas`.client_user_group WHERE _group NOT IN ('Unassigned')) UNION (SELECT 'SBI',_userID, _group, _expectedHoursMonth FROM `sbi`.client_user_group WHERE _group NOT IN ('Unassigned')) UNION (SELECT 'SDI',_userID, _group, _expectedHoursMonth FROM `sdi`.client_user_group WHERE _group NOT IN ('Unassigned')) UNION (SELECT 'Secureworks',_userID, _group, _expectedHoursMonth FROM `secureworks`.client_user_group WHERE _group NOT IN ('Unassigned')) UNION (SELECT 'SEI',_userID, _group, _expectedHoursMonth FROM `sei`.client_user_group WHERE _group NOT IN ('Unassigned')) UNION (SELECT 'Seismic',_userID, _group, _expectedHoursMonth FROM `seismic`.client_user_group WHERE _group NOT IN ('Unassigned')) UNION (SELECT 'SimpleTire',_userID, _group, _expectedHoursMonth FROM `simpletire`.client_user_group WHERE _group NOT IN ('Unassigned')) UNION (SELECT 'SmartCommNAM',_userID, _group, _expectedHoursMonth FROM `smartcommnam`.client_user_group WHERE _group NOT IN ('Unassigned')) UNION (SELECT 'SmartCommunications',_userID, _group, _expectedHoursMonth FROM `smartcommunications`.client_user_group WHERE _group NOT IN ('Unassigned')) UNION (SELECT 'SparkHire',_userID, _group, _expectedHoursMonth FROM `sparkhire`.client_user_group WHERE _group NOT IN ('Unassigned')) UNION (SELECT 'StarLims',_userID, _group, _expectedHoursMonth FROM `starlims`.client_user_group WHERE _group NOT IN ('Unassigned')) UNION (SELECT 'StraightArrow',_userID, _group, _expectedHoursMonth FROM `straightarrow`.client_user_group WHERE _group NOT IN ('Unassigned')) UNION (SELECT 'Suvoda',_userID, _group, _expectedHoursMonth FROM `suvoda`.client_user_group WHERE _group NOT IN ('Unassigned')) UNION (SELECT 'Syllable',_userID, _group, _expectedHoursMonth FROM `syllable`.client_user_group WHERE _group NOT IN ('Unassigned')) UNION (SELECT 'Symplr',_userID, _group, _expectedHoursMonth FROM `symplr`.client_user_group WHERE _group NOT IN ('Unassigned')) UNION (SELECT 'Syniti',_userID, _group, _expectedHoursMonth FROM `syniti`.client_user_group WHERE _group NOT IN ('Unassigned')) UNION (SELECT 'TechData',_userID, _group, _expectedHoursMonth FROM `techdata`.client_user_group WHERE _group NOT IN ('Unassigned')) UNION (SELECT 'Televerde',_userID, _group, _expectedHoursMonth FROM `televerde`.client_user_group WHERE _group NOT IN ('Unassigned')) UNION (SELECT 'Terrasmart',_userID, _group, _expectedHoursMonth FROM `terrasmart`.client_user_group WHERE _group NOT IN ('Unassigned')) UNION (SELECT 'TheLogicFactory',_userID, _group, _expectedHoursMonth FROM `thelogicfactory`.client_user_group WHERE _group NOT IN ('Unassigned')) UNION (SELECT 'Thunder',_userID, _group, _expectedHoursMonth FROM `thunder`.client_user_group WHERE _group NOT IN ('Unassigned')) UNION (SELECT 'ToolWatch',_userID, _group, _expectedHoursMonth FROM `toolwatch`.client_user_group WHERE _group NOT IN ('Unassigned')) UNION (SELECT 'TrueLearn',_userID, _group, _expectedHoursMonth FROM `truelearn`.client_user_group WHERE _group NOT IN ('Unassigned')) UNION (SELECT 'ULSolutions',_userID, _group, _expectedHoursMonth FROM `ulsolutions`.client_user_group WHERE _group NOT IN ('Unassigned')) UNION (SELECT 'Veracode',_userID, _group, _expectedHoursMonth FROM `veracode`.client_user_group WHERE _group NOT IN ('Unassigned')) UNION (SELECT 'Vertex',_userID, _group, _expectedHoursMonth FROM `vertex`.client_user_group WHERE _group NOT IN ('Unassigned')) UNION (SELECT 'VertexCM',_userID, _group, _expectedHoursMonth FROM `vertexcm`.client_user_group WHERE _group NOT IN ('Unassigned')) UNION (SELECT 'Vistair',_userID, _group, _expectedHoursMonth FROM `vistair`.client_user_group WHERE _group NOT IN ('Unassigned')) UNION (SELECT 'Welocalize',_userID, _group, _expectedHoursMonth FROM `welocalize`.client_user_group WHERE _group NOT IN ('Unassigned')) UNION (SELECT 'WKBrandComms',_userID, _group, _expectedHoursMonth FROM `wkbrandcomms`.client_user_group WHERE _group NOT IN ('Unassigned')) UNION (SELECT 'WKHealthLanguage',_userID, _group, _expectedHoursMonth FROM `wkhealthlanguage`.client_user_group WHERE _group NOT IN ('Unassigned')) UNION (SELECT 'WKHLRP',_userID, _group, _expectedHoursMonth FROM `wkhlrp`.client_user_group WHERE _group NOT IN ('Unassigned')) UNION (SELECT 'WoltersKluwer',_userID, _group, _expectedHoursMonth FROM `wolterskluwer`.client_user_group WHERE _group NOT IN ('Unassigned'))<BR>