Untitled
unknown
plain_text
13 days ago
1.3 kB
3
Indexable
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
Editor is loading...
Leave a Comment