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.
Options
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
SOLUTION 0
EtienneB
#2EtienneB Member Original PosterPosts: 3  
posted: 5/27/2022 8:13:50 AM(UTC)
Thank you so very much.
Really appreciate the assistance.
0

Active Discussions

Lansweeper mail reports
by  Andy.S   Go to last post Go to first unread
Last post: 7/1/2022 2:38:18 PM(UTC)
Lansweeper Adding an "Employee ID" column to an asset report
by  ABaker   Go to last post Go to first unread
Last post: 6/30/2022 3:06:54 PM(UTC)
Lansweeper Firefox 102 & ESR 91.11
by  Esben.D   Go to last post Go to first unread
Last post: 6/30/2022 8:12:07 AM(UTC)
Lansweeper Performance report not shows result
by  NoraD   Go to last post Go to first unread
Last post: 6/28/2022 7:52:27 AM(UTC)
Lansweeper Duplicate AD Users
by  Randy Costa   Go to last post Go to first unread
Last post: 6/27/2022 5:25:04 PM(UTC)
Lansweeper Exporting Security event log from Windows results in an error
by  frankm0304   Go to last post Go to first unread
Last post: 6/24/2022 10:41:27 PM(UTC)
Lansweeper htblhistory = default table? unidentified in report generator
by  J_Hol   Go to last post Go to first unread
Last post: 6/23/2022 5:27:18 PM(UTC)
Lansweeper Multiple Devices Owned by Users (asset relations)
by  Adrian Scott   Go to last post Go to first unread
Last post: 6/22/2022 5:34:51 PM(UTC)