Page Comparison

...

Code Block

lang	sql
title	Detect Imported Users that are a duplicate

select * from Inv_Global_Windows_Users GWU
WHERE EXISTS
	(select 1 from ResourceKey RK where RK.KeyName = 'name.domain' and RK.KeyValue= (upper(GWU.UserId) + '.' + upper(GWU.Domain))
	and RK.ResourceGuid != GWU._ResourceGuid)

Code Block

lang	sql
title	Detects Users populated with domain details that should have a resource key populated

select * from Inv_Global_Windows_Users GWU
WHERE NOT EXISTS
	(select 1 from ResourceKey RK where RK.KeyName = 'name.domain' and RK.KeyValue= (upper(GWU.UserId) + '.' + upper(GWU.Domain)))
	AND UserId IS NOT NULL

Code Block

lang	sql
title	Inserts ResourceKeys for Users that have Domain details populated, but no corresponding resource Key exists

INSERT INTO ResourceKey(ResourceGuid, KeyName, KeyValue)
select GWU._ResourceGuid, 'name.domain', (GWU.UserId + '.' + GWU.Domain) from Inv_Global_Windows_Users GWU
WHERE NOT EXISTS
	(select 1 from ResourceKey RK where RK.KeyName = 'name.domain' and RK.KeyValue= (upper(GWU.UserId) + '.' + upper(GWU.Domain)))
	AND UserId IS NOT NULL

Versions Compared

Old Version 4

New Version 5

Key