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