→ Celebrate SysAdmin Day 2024 with Lansweeper Enter our Giveaway here

cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 
meteotest
Engaged Sweeper
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?
1 ACCEPTED SOLUTION
Hemoco
Lansweeper Alumni
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

View solution in original post

6 REPLIES 6
meteotest
Engaged Sweeper
Ok, thanks - That report seems to be working great!
Hemoco
Lansweeper Alumni
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
Engaged Sweeper
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
Lansweeper Alumni
Add a criterion to the Criteria column for the tblAssetGroups.AssetGroup expression. E.g.:
= 'YourGroupName'
meteotest
Engaged Sweeper
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
Lansweeper Alumni
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