‎08-01-2014 06:44 PM
Solved! Go to Solution.
‎08-01-2014 08:56 PM
Select Top 1000000 'OS: ' + tblOperatingsystem.Caption + ' / Value: ' +
tblRegistry.Value As [OS + Value],
Count(tblRegistry.AssetID) As Count
From tblRegistry
Inner Join tblOperatingsystem On tblOperatingsystem.AssetID =
tblRegistry.AssetID
Where tblRegistry.Regkey Like '%firewall%' And tblOperatingsystem.Caption Not Like '%server%'
Group By 'OS: ' + tblOperatingsystem.Caption + ' / Value: ' + tblRegistry.Value
Order By [OS + Value]
‎08-01-2014 08:56 PM
Select Top 1000000 'OS: ' + tblOperatingsystem.Caption + ' / Value: ' +
tblRegistry.Value As [OS + Value],
Count(tblRegistry.AssetID) As Count
From tblRegistry
Inner Join tblOperatingsystem On tblOperatingsystem.AssetID =
tblRegistry.AssetID
Where tblRegistry.Regkey Like '%firewall%' And tblOperatingsystem.Caption Not Like '%server%'
Group By 'OS: ' + tblOperatingsystem.Caption + ' / Value: ' + tblRegistry.Value
Order By [OS + Value]
Experience Lansweeper with your own data. Sign up now for a 14-day free trial.
Try Now