Using Asset Groups in Reports ...

[meteotest]

I made a number of Asset Groups which I hoped to use as identifiers in making new reports, however I cannot seem to find the Asset Groups when making a new Report.

For example I made the following Asset Groups: Desktop, Notebook, Server ...

And I would like to be able to make reports like the following information:

Asset Group: Desktop / Username / CPU / Memory

Is this possible?

[meteotest]

Ok, thanks - That report seems to be working great!

[Hemoco · Accepted solution]

Please note that the report we provided only lists Windows computers that have been successfully scanned and whose state is set to active. If these criteria don't suit your needs, try the report below instead.

Select Top 1000000 tblAssets.AssetID,
tblAssets.AssetName,
tblAssets.Domain,
tblAssets.Username,
tblAssets.Userdomain,
tblAssets.IPAddress,
tblAssets.Memory,
tblAssets.NrProcessors,
tblAssets.Processor,
tblAssets.Firstseen,
tblAssets.Lastseen,
tblAssetGroups.AssetGroup,
tsysAssetTypes.AssetTypeIcon10 As icon
From tblAssets
Inner Join tblAssetGroupLink On tblAssets.AssetID = tblAssetGroupLink.AssetID
Inner Join tblAssetGroups On tblAssetGroups.AssetGroupID =
tblAssetGroupLink.AssetGroupID
Inner Join tsysAssetTypes On tsysAssetTypes.AssetType = tblAssets.Assettype
Where tblAssetGroups.AssetGroup = 'YourGroupName'
Order By tblAssets.IPNumeric

[meteotest]

Ok, but this still does not give me a list of the machines I have in my "Desktop" Asset Group. I also tried with "Server" as a criteria and the report only lists one machine when in my "Server" Asset Group I have a total of 16 added assets.

[Hemoco]

Add a criterion to the Criteria column for the tblAssetGroups.AssetGroup expression. E.g.:

= 'YourGroupName'

[meteotest]

I tried using that report and it shows me every machine with every group that it is in. What I need is to be able to define a list of machines based upon the given asset group ... such as Asset Group "Desktop".

[Hemoco]

You need to build a report that includes the tblAssetGroups and tblAssetGroupLink database tables. E.g.:

Select Top 1000000 tblAssets.AssetID,
tblAssets.AssetName,
tblAssets.Domain,
tblAssets.Username,
tblAssets.Userdomain,
tblAssets.IPAddress,
tblAssets.Memory,
tblAssets.NrProcessors,
tblAssets.Processor,
tblAssets.Firstseen,
tblAssets.Lastseen,
tblAssetGroups.AssetGroup,
tsysOS.Image As icon
From tblAssets
Inner Join tblAssetCustom On tblAssets.AssetID = tblAssetCustom.AssetID
Inner Join tblAssetGroupLink On tblAssets.AssetID = tblAssetGroupLink.AssetID
Inner Join tblAssetGroups On tblAssetGroups.AssetGroupID =
tblAssetGroupLink.AssetGroupID
Inner Join tsysOS On tsysOS.OScode = tblAssets.OScode
Where tblAssetCustom.State = 1
Order By tblAssets.Domain,
tblAssets.AssetName,
tblAssetGroups.AssetGroup