Untitled

Select Reponame,Org, octopus_project_name,last_committer_email,supervisor, manager from Octopus_Git_Mapping

SELECT RIGHT(repo.github_repo_name, LEN(repo.github_repo_name) - CHARINDEX('\', repo.github_repo_name)) as Reponame, repo.github_repo_name as org, octopus_project_name, last_committer_email , b.email as supervisor, d.email as manager
FROM github_octopus_mapping repo
Left outer join [vw_ad_immediate_manager] a on repo.last_committer_email = a.email
right join [dbo].[advanced_directory] B on a.immediate_manager = b.level7
inner join [vw_ad_immediate_manager] C on b.level7 = c.level7
inner join [dbo].[advanced_directory] d on c.immediate_manager = d.level7
where octopus_project_name is not null
Union
SELECT repo.project as Reponame, 'LPL-Development\' + repo.project as org, octopus_project, last_committer_email , b.email as supervisor, d.email as manager
FROM [DevOpsReports].[dbo].[repo_octo_committer_data] repo
inner join [vw_ad_immediate_manager] a on repo.last_committer_email = a.email
inner join [dbo].[advanced_directory] B on a.immediate_manager = b.level7
inner join [vw_ad_immediate_manager] C on b.level7 = c.level7
inner join [dbo].[advanced_directory] d on c.immediate_manager = d.level7
where octopus_project is not null