Cumulative Event Logs of one Asset Group

[jsrinivasu]

We are trying to create a report to get Cumulative Events Logs for one Asset Group. And also getting software installed details of each machine in a report.

We are new to LanSweeper and try to configure our own with GUI based reporting but not succeeded.

Could you please help me to create both reports by return?

Thank you for your support in advance.

Regards
Srinivas

[jsrinivasu]

Thank you very much for the support.

we are able to get the required reports.

[Hemoco]

Please use the following report:

Select Top 1000000 tblAssets.AssetID,
tblAssets.AssetName,
tblSoftwareUni.softwareName,
tblSoftwareUni.SoftwarePublisher,
tblSoftware.Installdate,
tblSoftware.softwareVersion,
tblSoftware.MSI
From tblAssets
Inner Join tblSoftware On tblAssets.AssetID = tblSoftware.AssetID
Inner Join tblSoftwareUni On tblSoftwareUni.SoftID = tblSoftware.softID
Inner Join tblAssetGroupLink On tblAssets.AssetID = tblAssetGroupLink.AssetID
Inner Join tblAssetGroups On tblAssetGroups.AssetGroupID =
tblAssetGroupLink.AssetGroupID
Where tblAssetGroups.AssetGroup = 'name group'
Order By tblAssets.AssetName

[jsrinivasu]

Thank you very much for providing the sql code.

Could you please let me know how to get software list from assets of a specific asset group?

[Hemoco · Accepted solution]

You can use the following report to get all event-logs from assets of a specific asset group. Please change the red word with the name of the asset group that you want to filter on.

Select Top 1000000 tblAssets.AssetID,
tblAssets.AssetName,
tblAssetGroups.AssetGroup,
tblNtlog.Eventcode,
tblNtlog.Eventtype,
tblNtlogMessage.Message,
tblNtlogSource.Sourcename,
tblNtlogUser.Loguser
From tblAssets
Inner Join tblAssetGroupLink On tblAssets.AssetID = tblAssetGroupLink.AssetID
Inner Join tblAssetGroups On tblAssetGroups.AssetGroupID =
tblAssetGroupLink.AssetGroupID
Inner Join tblNtlog On tblAssets.AssetID = tblNtlog.AssetID
Inner Join tblNtlogMessage On tblNtlogMessage.MessageID = tblNtlog.MessageID
Inner Join tblNtlogSource On tblNtlogSource.SourcenameID =
tblNtlog.SourcenameID
Inner Join tblNtlogUser On tblNtlogUser.LoguserID = tblNtlog.LoguserID
Where tblAssetGroups.AssetGroup = 'name group'
Order By tblAssets.AssetName

The following report will give you all information about the software installed:

Select Top 1000000 tblAssets.AssetID,
tblAssets.AssetName,
tblSoftwareUni.softwareName,
tblSoftwareUni.SoftwarePublisher,
tblSoftware.Installdate,
tblSoftware.softwareVersion,
tblSoftware.MSI
From tblAssets
Inner Join tblSoftware On tblAssets.AssetID = tblSoftware.AssetID
Inner Join tblSoftwareUni On tblSoftwareUni.SoftID = tblSoftware.softID
Order By tblAssets.AssetName