→ 🚀What's New? Join Us for the Fall Product Launch! Register Now !
‎07-23-2014 12:49 AM
Select Top 1000000 tsysOS.Image As icon,
tblAssets.AssetID,
tblAssets.AssetUnique,
tblAssets.Domain,
tblRegistry.Regkey,
tblRegistry.Valuename,
tblRegistry.Value,
tblRegistry.Lastchanged
From tblAssets
Inner Join tsysOS On tsysOS.OScode = tblAssets.OScode
Inner Join tblRegistry On tblAssets.AssetID = tblRegistry.AssetID
Inner Join tblAssetCustom On tblAssets.AssetID = tblAssetCustom.AssetID
Where
tblRegistry.Regkey Like
'%SOFTWARE\KasperskyLab\Components\34\1103\1.0.0.0\Statistics\AVState' And
tblRegistry.Valuename = 'Protection_NagentVersion' And tblAssetCustom.State =
1
Order By tblAssets.AssetUnique
Solved! Go to Solution.
‎07-23-2014 06:53 PM
Please use the report below for the information you are after. For future reporting, we would ask that you review some SQL tutorials first, as the Lansweeper report builder uses standard SQL queries. This seems like a good tutorial: http://www.w3schools.com/sql/default.asp
To use the report below, do the following:
•Open the report builder under Reports/Create New Report.
•Paste the SQL query we provided at the bottom of the page.
•Left-click somewhere in the upper section of the page so the query applies.
•Give the report a Title and hit the Save & Run button to save it. Export options are listed on the left.
Select Top 1000000 tsysOS.Image As icon,
tblAssets.AssetID,
tblAssets.AssetName,
tblAssets.Domain,
tblAssets.IPAddress,
tblAssets.Firstseen,
tblAssets.Lastseen,
SubQuery1.Value As KAgent,
SubQuery2.Value As KVersion
From tblAssets
Inner Join tblAssetCustom On tblAssets.AssetID = tblAssetCustom.AssetID
Inner Join tblComputersystem On tblAssets.AssetID = tblComputersystem.AssetID
Inner Join tsysOS On tsysOS.OScode = tblAssets.OScode
Left Join (Select Top 1000000 tblRegistry.AssetID,
tblRegistry.Regkey,
tblRegistry.Valuename,
tblRegistry.Value
From tblRegistry
Where
tblRegistry.Regkey = 'HKEY_LOCAL_MACHINE\SOFTWARE\KasperskyLab\Components\34\1103\1.0.0.0\Statistics\AVState'
And tblRegistry.Valuename = 'Protection_NagentVersion') SubQuery1
On SubQuery1.AssetID = tblAssets.AssetID
Left Join (Select Top 1000000 tblRegistry.AssetID,
tblRegistry.Regkey,
tblRegistry.Valuename,
tblRegistry.Value
From tblRegistry
Where
tblRegistry.Regkey =
'HKEY_LOCAL_MACHINE\SOFTWARE\KasperskyLab\Components\34\Connectors\KES\8.1.0.0' And
tblRegistry.Valuename = 'ProdVersion') SubQuery2 On SubQuery2.AssetID =
tblAssets.AssetID
Where tblAssetCustom.State = 1 And tblComputersystem.Domainrole < 2
Order By tblAssets.Domain,
tblAssets.AssetName
‎07-23-2014 09:00 PM
‎07-23-2014 06:53 PM
Please use the report below for the information you are after. For future reporting, we would ask that you review some SQL tutorials first, as the Lansweeper report builder uses standard SQL queries. This seems like a good tutorial: http://www.w3schools.com/sql/default.asp
To use the report below, do the following:
•Open the report builder under Reports/Create New Report.
•Paste the SQL query we provided at the bottom of the page.
•Left-click somewhere in the upper section of the page so the query applies.
•Give the report a Title and hit the Save & Run button to save it. Export options are listed on the left.
Select Top 1000000 tsysOS.Image As icon,
tblAssets.AssetID,
tblAssets.AssetName,
tblAssets.Domain,
tblAssets.IPAddress,
tblAssets.Firstseen,
tblAssets.Lastseen,
SubQuery1.Value As KAgent,
SubQuery2.Value As KVersion
From tblAssets
Inner Join tblAssetCustom On tblAssets.AssetID = tblAssetCustom.AssetID
Inner Join tblComputersystem On tblAssets.AssetID = tblComputersystem.AssetID
Inner Join tsysOS On tsysOS.OScode = tblAssets.OScode
Left Join (Select Top 1000000 tblRegistry.AssetID,
tblRegistry.Regkey,
tblRegistry.Valuename,
tblRegistry.Value
From tblRegistry
Where
tblRegistry.Regkey = 'HKEY_LOCAL_MACHINE\SOFTWARE\KasperskyLab\Components\34\1103\1.0.0.0\Statistics\AVState'
And tblRegistry.Valuename = 'Protection_NagentVersion') SubQuery1
On SubQuery1.AssetID = tblAssets.AssetID
Left Join (Select Top 1000000 tblRegistry.AssetID,
tblRegistry.Regkey,
tblRegistry.Valuename,
tblRegistry.Value
From tblRegistry
Where
tblRegistry.Regkey =
'HKEY_LOCAL_MACHINE\SOFTWARE\KasperskyLab\Components\34\Connectors\KES\8.1.0.0' And
tblRegistry.Valuename = 'ProdVersion') SubQuery2 On SubQuery2.AssetID =
tblAssets.AssetID
Where tblAssetCustom.State = 1 And tblComputersystem.Domainrole < 2
Order By tblAssets.Domain,
tblAssets.AssetName
Experience Lansweeper with your own data. Sign up now for a 14-day free trial.
Try Now