‎05-14-2022 10:41 AM
Solved! Go to Solution.
‎05-26-2022 12:58 PM
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
‎05-26-2022 12:58 PM
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
‎05-27-2022 09:13 AM
Experience Lansweeper with your own data. Sign up now for a 14-day free trial.
Try Now