Hi there,
I need to create a very simple report to show all of my users for 2 mails domain, and without "prestataire, interimaire and stagiaire".
Easy, yes my report works, but I don't know why I've some users duplication.
I have only 3 columns with unique entry, so what ?
Here is my query, if you have an idea
🙂Select Top 1000000 tblAssets.AssetID,
tblAssets.Username,
tblADusers.Firstname,
tblADusers.Lastname,
tblADusers.email
From tblAssets
Left Join tblADusers On tblADusers.Username = tblAssets.Username And
tblADusers.Userdomain = tblAssets.Userdomain
Where tblAssets.Username Is Not Null And tblADusers.Firstname Is Not Null And
tblADusers.Lastname Is Not Null And tblADusers.Lastname Not Like
'%PRESTATAIRE%' And tblADusers.Lastname Not Like '%STAGIAIRE%' And
tblADusers.Lastname Not Like '%INTERIMAIRE%' And
((tblADusers.email Is Not Null And tblADusers.email Like '%MyDomain1%') Or
tblADusers.email Like '%MyDomain2%')
Many thanks,
Kreg