authorized administrators(

[rdunne]

Hi all

I know this is prob very quick change, but I want to run the Unauthorized administrators report , but pick up only authorized administrators not just local admin , I want to be able to review who I have added to the authored list so they dont show up on the Unauthorized administrators report , I have had a go with that repot and it always failing

Thanks for any help
RIchard

[Andy_Sismey]

Hi Richard,

Not sure if I understand correctly but are you wanting to filter the report with a list of known Administrators like this ?

Select Top 1000000 tsysOS.Image As icon,
  tblAssets.AssetID,
  tblAssets.AssetName,
  tblUsersInGroup.Domainname,
  tblUsersInGroup.Username,
  tblUsersInGroup.Lastchanged,
  tblAssets.Domain,
  tblAssets.IPAddress,
  tblAssets.Description,
  tblAssetCustom.Manufacturer,
  tblAssetCustom.Model,
  tblAssetCustom.Location,
  tsysIPLocations.IPLocation,
  tsysOS.OSname As OS,
  tblAssets.SP As SP,
  tblAssets.Firstseen,
  tblAssets.Lastseen
From tblUsersInGroup
  Inner Join tblAssets On tblUsersInGroup.AssetID = tblAssets.AssetID
  Inner Join tblAssetCustom On tblAssets.AssetID = tblAssetCustom.AssetID
  Inner Join tsysOS On tblAssets.OScode = tsysOS.OScode
  Left Join tsysIPLocations On tsysIPLocations.StartIP <= tblAssets.IPNumeric
      And tsysIPLocations.EndIP >= tblAssets.IPNumeric
Where (tblUsersInGroup.Username Not Like '%Administrator1%' Or
    tblUsersInGroup.Username Not Like '%Administartor2%') And
  Not Exists(Select tblAssets.AssetName As Domain,
      tblUsers.Name As Username
    From tblAssets Inner Join tblUsers On tblAssets.AssetID = tblUsers.AssetID
    Where tblUsers.BuildInAdmin = 1 And tblUsersInGroup.Domainname =
      tblAssets.AssetName And tblUsersInGroup.Username = tblUsers.Name) And
  Not Exists(Select tsysadmins.Domain,
      tsysadmins.AdminName As username From tsysadmins
    Where tblUsersInGroup.Domainname Like tsysadmins.Domain And
      tblUsersInGroup.Username Like tsysadmins.AdminName) And
  tblUsersInGroup.Admingroup = 1 And tblAssetCustom.State = 1
Order By tblAssets.AssetName