Exibir código-fonte para Usuários de DRE

<syntaxhighlight lang="sql" line="1" >
/*
- Usuários de DRE
*/

USE SGP_GestaoPedagogica
GO



SELECT
	Uad.uad_nome AS DRE
	, Pes.pes_nome as Nome
	, Usu.usu_login AS [login]
	, Gru.gru_nome AS GrupoLogin
FROM RHU_Colaborador Col WITH(NOLOCK)

INNER JOIN Synonym_PES_Pessoa Pes WITH(NOLOCK)
	ON Pes.pes_id = Col.pes_id
INNER JOIN Synonym_SYS_Usuario Usu WITH(NOLOCK)
	ON Usu.pes_id = Pes.pes_id
	AND Usu.usu_situacao <> 3
INNER JOIN Synonym_SYS_UsuarioGrupo UGru WITH(NOLOCK)
	ON Ugru.usu_id = Usu.usu_id
	AND UGru.usg_situacao <> 3
INNER JOIN SGP_CoreSSO..SYS_UsuarioGrupoUA UGruUA WITH(NOLOCK)
	ON UGruUA.gru_id = UGru.gru_id
	AND UGruUA.usu_id = Usu.usu_id
INNER JOIN Synonym_SYS_Grupo Gru WITH(NOLOCK)
	ON Gru.gru_id = UGru.gru_id
	AND Gru.gru_situacao <> 3
	AND Gru.sis_id = 102 -- SGP

INNER JOIN Synonym_SYS_UnidadeAdministrativa Uad WITH(NOLOCK)
	ON Uad.ent_id = UGruUA.ent_id
	AND Uad.uad_id = UGruUA.uad_id
	AND Uad.tua_id = '52022558-8C00-4539-99FB-B647BC994D5E'
WHERE
	Col.col_situacao <> 3
	AND NOT EXISTS (SELECT 1 FROM ACA_Docente Doc WITH(NOLOCK) WHERE Doc.col_id = Col.col_id AND Doc.doc_situacao <> 3)

order by
	Uad.uad_nome
	, Pes.pes_nome

</syntaxhighlight>