→ 🚀What's New? Join Us for the Fall Product Launch! Register Now !

cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 
TRC_System_Admi
Engaged Sweeper II
I need to generate a report for 2 reg keys.

I know how to do it for 1 key.

How can I display 2 keys in one report?

Here is the example for one.

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


I need a kaspersky report that shows me the agent & product versions..

thanks
1 ACCEPTED SOLUTION
Hemoco
Lansweeper Alumni
Question received and replied to via email as well:
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

View solution in original post

2 REPLIES 2
TRC_System_Admi
Engaged Sweeper II
Thank you...

it worked like a charm...
Hemoco
Lansweeper Alumni
Question received and replied to via email as well:
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