Notification

Icon
Error

Report to show Office 2013 installs still using basic auth - Report to show Office 2013 installs and a specific reg key present

Posted: Saturday, May 14, 2022 9:41:49 AM(UTC)
EtienneB

EtienneB

Member Original PosterPosts: 3
0
Like
This issue has been solved! Click here to view the solution
Hi guys.
I need some assistance with a report, please.

We have quite a few machines that have Office 2013 installed, that have not yet been patched to disable basic auth and use modern auth instead.

I found the registry keys via the Microsoft site and have created a deployment to add them to the registry.

Please can someone assist me with a report that will list all the machines with Office 2013 installed and also which of them do not have the registry keys applied so that I can then deploy the keys to them ?

Here are the registry keys that need to be present:

[HKEY_CURRENT_USER\Software\Microsoft\Exchange]
"AlwaysUseMSOAuthForAutoDiscover"=dword:00000001

[HKEY_CURRENT_USER\Software\Microsoft\Office\15.0\Common]

[HKEY_CURRENT_USER\Software\Microsoft\Office\15.0\Common\Identity]
"EnableADAL"=dword:00000001
"Version"=dword:00000001

Thanking you in advance.
Andy.S
#1Andy.S Member Posts: 160  
posted: 5/26/2022 11:58:07 AM(UTC)
Hi , this should get you started , so once you have setup your registry scans like this (https://www.lansweeper.com/knowledgebase/report-based-on-registry-keys/) , this report will give you all assets with Office 2013 and the 3 Registry key values
Code:
Select Top 1000000 tblassets.AssetID,
  tblassets.AssetName,
  tsysassettypes.AssetTypename,
  tsysassettypes.AssetTypeIcon10 As icon,
  tblassets.IPAddress,
  tblassets.Lastseen,
  tblassets.Lasttried,
  [Office 2013].softwareName,
  AlwaysUseReg.Value As [AlwaysUse-Reg],
  EnableADALReg.Value As ADALReg,
  VersionReg.Value As VersionReg
From tblassets
  Inner Join tblassetcustom On tblassets.AssetID = tblassetcustom.AssetID
  Inner Join tsysassettypes On tsysassettypes.AssetType = tblassets.Assettype
  Right Join (Select tblSoftware.AssetID,
      tblSoftwareUni.softwareName
    From lansweeperdb.dbo.tblSoftware
      Inner Join lansweeperdb.dbo.tblSoftwareUni On tblSoftwareUni.SoftID =
          tblSoftware.softID
    Where tblSoftwareUni.softwareName Like 'Microsoft Office %2013')
  [Office 2013] On [Office 2013].AssetID = tblassets.AssetID
  Left Join (Select tblRegistry.Valuename,
      tblRegistry.Value,
      tblRegistry.AssetID
    From lansweeperdb.dbo.tblRegistry
    Where tblRegistry.Valuename = 'AlwaysUseMSOAuthForAutoDiscover')
  AlwaysUseReg On AlwaysUseReg.AssetID = [Office 2013].AssetID
  Left Join (Select tblRegistry.Valuename,
      tblRegistry.AssetID,
      tblRegistry.Value
    From lansweeperdb.dbo.tblRegistry
    Where tblRegistry.Valuename = 'EnableADAL') EnableADALReg On
      EnableADALReg.AssetID = [Office 2013].AssetID
  Left Join (Select tblRegistry.AssetID,
      tblRegistry.Value,
      tblRegistry.Valuename,
      tblRegistry.Regkey
    From lansweeperdb.dbo.tblRegistry
    Where tblRegistry.Valuename = 'Version' And tblRegistry.Regkey Like
      '%Software\Microsoft\Office\15.0\Common\Identity%') VersionReg On
      VersionReg.AssetID = [Office 2013].AssetID
Where tblassetcustom.State = 1
EtienneB
#2EtienneB Member Original PosterPosts: 3  
posted: 5/27/2022 8:13:50 AM(UTC)
Thank you so very much.
Really appreciate the assistance.

Active Discussions

Lansweeper Version 10.2.0.0
by  ThomasK   Go to last post Go to first unread
Last post: Today at 6:11:28 AM(UTC)
Lansweeper Certificates
by  Orion Poplawski  
Go to last post Go to first unread
Last post: 7/1/2022 10:11:12 PM(UTC)
Lansweeper Dell warranty lookup not working
by  LANGuy  
Go to last post Go to first unread
Last post: 7/1/2022 1:30:06 PM(UTC)
Lansweeper RedHat 8.5 & SELinux
by  QuelleAcht   Go to last post Go to first unread
Last post: 7/1/2022 1:16:19 PM(UTC)
Lansweeper Suddenly seeing Access Denied scanning errors?
by  Erik.T  
Go to last post Go to first unread
Last post: 7/1/2022 9:38:17 AM(UTC)
Lansweeper Single Line report with H/D
by  Ioannis   Go to last post Go to first unread
Last post: 7/1/2022 7:53:23 AM(UTC)
Lansweeper Lansweeper Dark Theme
by  mrobbins  
Go to last post Go to first unread
Last post: 6/30/2022 5:38:01 PM(UTC)