ELIMINAR DATA
[cvt_apps].[dbo].[TI_permisosU]
[cvt_apps].[dbo].[TIpermisosSoftland]
[cvt_apps].[dbo].[TIusuariosAD]
GUARDAR ARCHIVO DE USUARIOS ACTIVE COMO XLS (IR A SOLUCION Sacar lista de usuarios Active Directory )-->VT14
IMPORTAR DATA USUARIOS DEL ACTIVE A SQL EN LA TABLA [cvt_apps].[dbo].[TIusuariosAD]
CORRER APP NTFS PERMISSIONS-->VT18
EXPORTAR EL ARCHIVO, DARLE FORMATO DE ACUERDO A LA TABLA [cvt_apps].[dbo].[TI_permisosU] Y GUARDARLO EN XLS.
IMPORTAR LA DATA A TABLA [cvt_apps].[dbo].[TI_permisosU]
----opcional-----
update [cvt_apps].[dbo].[TIusuariosAD]
set Estado = 'Activo'
where Estado = 'Active'
update [cvt_apps].[dbo].[TIusuariosAD]
set Estado = 'Inactivo'
where Estado = 'Inactive'
update [cvt_apps].[dbo].[TI_permisosU]
SET [Permiso (Simple)] = 'Control completo'
where [Permisos (Avanzado)] = 'Full Control, Traverse Folder / Execute File, List Folder / Read Data, Read Attributes, Read Extended Attributes, Create Files / Write Data, Create Folders / Append Data, Write Attributes, Write Extended Attributes, Delete Subfolders and Files, Delete, Read Permissions, Change Permissions, Take Ownership'
update [cvt_apps].[dbo].[TI_permisosU]
SET [Permiso (Simple)] = 'Listado'
where [Permisos (Avanzado)] = 'Traverse Folder / Execute File, List Folder / Read Data, Read Attributes, Read Extended Attributes, Read Permissions'
update [cvt_apps].[dbo].[TI_permisosU]
SET [Permiso (Simple)] = 'Modificar'
where [Permisos (Avanzado)] = 'Traverse Folder / Execute File, List Folder / Read Data, Read Attributes, Read Extended Attributes, Create Files / Write Data, Create Folders / Append Data, Write Attributes, Write Extended Attributes, Read Permissions'
update [cvt_apps].[dbo].[TI_permisosU]
SET [Permiso (Simple)] = 'Modificar'
where [Permisos (Avanzado)] = 'Traverse Folder / Execute File, List Folder / Read Data, Read Attributes, Read Extended Attributes, Create Files / Write Data, Create Folders / Append Data, Write Attributes, Write Extended Attributes, Read Permissions'
update [cvt_apps].[dbo].[TI_permisosU]
SET [Permiso (Simple)] = 'Modificar'
where [Permisos (Avanzado)] = 'Traverse Folder / Execute File, List Folder / Read Data, Read Attributes, Read Extended Attributes, Create Files / Write Data, Create Folders / Append Data, Write Attributes, Write Extended Attributes, Delete, Read Permissions'
update [cvt_apps].[dbo].[TI_permisosU]
SET [Permiso (Simple)] = 'Modificar'
where [Permisos (Avanzado)] = 'Traverse Folder / Execute File, List Folder / Read Data, Read Attributes, Read Extended Attributes, Create Files / Write Data, Create Folders / Append Data, Write Attributes, Write Extended Attributes, Delete Subfolders and Files, Delete, Read Permissions, Change Permissions, Take Ownership'
update [cvt_apps].[dbo].[TI_permisosU]
SET [Permiso (Simple)] = 'Modificar'
where [Permisos (Avanzado)] = 'Traverse Folder / Execute File, List Folder / Read Data, Read Attributes, Read Extended Attributes, Create Files / Write Data, Create Folders / Append Data, Write Attributes, Write Extended Attributes, Delete Subfolders and Files, Delete, Read Permissions, Change Permissions, Take Ownership'
update [cvt_apps].[dbo].[TI_permisosU]
SET [Permiso (Simple)] = 'Modificar'
where [Permisos (Avanzado)] = 'Create Files / Write Data, Create Folders / Append Data, Write Attributes, Write Extended Attributes'
update [cvt_apps].[dbo].[TI_permisosU]
SET [Tipo de acceso] = 'Permitir'
where [Tipo de acceso] = 'Allow'
update [cvt_apps].[dbo].[TI_permisosU]
SET [Tipo de acceso] = 'Denegar'
where [Tipo de acceso] = 'Deny'
update [cvt_apps].[dbo].[TI_permisosU]
set [Nivel 0] = case when [Nivel 0] is null then '' else [Nivel 0] end,
[Nivel 1] = case when [Nivel 1] is null then '' else [Nivel 1] end,
[Nivel 2] = case when [Nivel 2] is null then '' else [Nivel 2] end,
[Nivel 3] = case when [Nivel 3] is null then '' else [Nivel 3] end,
[Nivel 4] = case when [Nivel 4] is null then '' else [Nivel 4] end,
[Nivel 5] = case when [Nivel 5] is null then '' else [Nivel 5] end,
[Nivel 6] = case when [Nivel 6] is null then '' else [Nivel 6] end,
[Nivel 7] = case when [Nivel 7] is null then '' else [Nivel 7] end,
[Nivel 8] = case when [Nivel 8] is null then '' else [Nivel 8] end,
[Nivel 9] = case when [Nivel 9] is null then '' else [Nivel 9] end
GENERAR ARCHIVO PERMISOS DE USUARIO EN SOFTLAND
EXPORTAR EL ARCHIVO, DARLE FORMATO DE ACUERDO A LA TABLA [cvt_apps].[dbo].[TIpermisosSoftland]
IMPORTAR DATA PERMISOS USUARIOS SOFTLAND A SQL EN LA TABLA [cvt_apps].[dbo].[TIpermisosSoftland]
DESPUES IR A POWER BI AL SEMANTIC MODEL ACCESOS U, SELEECCIONAR REFRESH.
VERIFICAR DATA EN REPORT ACCESOS U