cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 
akuc
Engaged Sweeper
I am trying to create a report that will show computers that do not contain the user "localadmin". Since there are more than one user on the computer, it shows even those computers on which there is a "localadmin" user. I do not understand how to filter this.


Select Distinct Top 1000000 tsysOS.Image As icon,
tblAssets.AssetID,
tblAssets.AssetName,
tblAssets.Domain,
tblAssets.Username,
tblAssets.Userdomain,
tblAssets.IPAddress
From tblAssets
Inner Join tblAssetCustom On tblAssets.AssetID = tblAssetCustom.AssetID
Inner Join tsysOS On tsysOS.OScode = tblAssets.OScode
Inner Join tblUsers On tblAssets.AssetID = tblUsers.AssetID
Inner Join tblOperatingsystem On
tblAssets.AssetID = tblOperatingsystem.AssetID
Where tblAssetCustom.State = 1 And tblUsers.Name != 'Localadmin' And
tblOperatingsystem.ProductType = '1'
Order By tblAssets.Domain,
tblAssets.AssetName
0 REPLIES 0