Custom Asset Group

[SEC_ALERTS]

Hi Team,

I have below requirement.

1.I have to create one Custom computers/Asset Group.
2.Under this I have to create some widgets like low disk space, their roles, Critical event categorization of this group machines.
3.More or less I have to copy our lansweeper server tab in this group.

How to achieve this?
Thanks in Advance!!
Your help would be appreciated.

Regards,
SEC_ALERTS.

[SEC_ALERTS]

Many Thanks !!
It Works perfect!!!

[Hemoco]

Sample reports can be seen below.

List of events that occurred in the last 7 days

Select Top 1000000 tsysOS.Image As icon,
tblAssets.AssetID,
tblAssets.AssetName,
tblAssets.Domain,
tblAssets.IPAddress,
tsysOS.OSname,
tblAssets.SP,
tblNtlog.Eventcode,
Case tblNtlog.Eventtype When 1 Then 'Error' When 2 Then 'Warning'
When 3 Then 'Information' When 4 Then 'Success Audit'
When 5 Then 'Failure Audit' End As Eventtype,
tblNtlogFile.Logfile,
tblNtlogMessage.Message,
tblNtlogSource.Sourcename,
tblNtlogUser.Loguser,
tblNtlog.TimeGenerated
From tblAssets
Inner Join tsysOS On tsysOS.OScode = tblAssets.OScode
Inner Join tblNtlog On tblAssets.AssetID = tblNtlog.AssetID
Inner Join tblNtlogFile On tblNtlogFile.LogfileID = tblNtlog.LogfileID
Inner Join tblNtlogMessage On tblNtlogMessage.MessageID = tblNtlog.MessageID
Inner Join tblNtlogSource On tblNtlogSource.SourcenameID =
tblNtlog.SourcenameID
Inner Join tblNtlogUser On tblNtlogUser.LoguserID = tblNtlog.LoguserID
Inner Join tblAssetGroupLink On tblAssets.AssetID = tblAssetGroupLink.AssetID
Inner Join tblAssetGroups On tblAssetGroups.AssetGroupID =
tblAssetGroupLink.AssetGroupID
Where tblNtlog.TimeGenerated > GetDate() - 7 And tblAssetGroups.AssetGroup =
'YourGroup'
Order By tblNtlog.TimeGenerated Desc

Event count per source for events that occurred in the last 7 days

Select Top 1000000 tblNtlogSource.Sourcename,
Count(tblNtlog.EventlogID) As Count
From tblAssets
Inner Join tblNtlog On tblAssets.AssetID = tblNtlog.AssetID
Inner Join tblNtlogSource On tblNtlog.SourcenameID =
tblNtlogSource.SourcenameID
Inner Join tblAssetCustom On tblAssets.AssetID = tblAssetCustom.AssetID
Inner Join tblAssetGroupLink On tblAssets.AssetID = tblAssetGroupLink.AssetID
Inner Join tblAssetGroups On tblAssetGroups.AssetGroupID =
tblAssetGroupLink.AssetGroupID
Where tblNtlog.TimeGenerated > GetDate() - 7 And tblAssetCustom.State = 1 And
tblAssetGroups.AssetGroup = 'YourGroup'
Group By tblNtlogSource.Sourcename
Order By Count Desc

[SEC_ALERTS]

Ok thanks for your reply.
Please let me know how to create event filter and event summary reports for this particular group.

[Hemoco]

Asset groups can be configured under Configuration/Website Management/Asset Groups. To set up a dashboard tab for a specific group, you will have to manually create reports that only include this group and add those reports to your tab. A very basic report can be seen below. Replace YourGroup with the group name.

Select Top 1000000 tblAssets.AssetID,
tblAssets.AssetName,
tsysAssetTypes.AssetTypename,
tsysAssetTypes.AssetTypeIcon10 As icon,
tblAssets.IPAddress,
tblAssets.Lastseen,
tblAssets.Lasttried,
tblAssetGroups.AssetGroup
From tblAssets
Inner Join tblAssetCustom On tblAssets.AssetID = tblAssetCustom.AssetID
Inner Join tsysAssetTypes On tsysAssetTypes.AssetType = tblAssets.Assettype
Inner Join tblAssetGroupLink On tblAssets.AssetID = tblAssetGroupLink.AssetID
Inner Join tblAssetGroups On tblAssetGroups.AssetGroupID =
tblAssetGroupLink.AssetGroupID
Where tblAssetGroups.AssetGroup = 'YourGroup' And tblAssetCustom.State = 1