cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 
Kassim
Engaged Sweeper
Hi,

Can anyone help in creating a report that shows members of the powerusers group on a computer? this is using version 5 of lansweeper.

Thanks
1 ACCEPTED SOLUTION
Hemoco
Lansweeper Alumni
Please try this:

Select Top 1000000 tblAssets.AssetID,
tblAssets.AssetName,
tsysAssetTypes.AssetTypename,
tsysAssetTypes.AssetTypeIcon10 As icon,
tblUsersInGroup.Groupname,
tblUsersInGroup.Domainname,
tblUsersInGroup.Username,
tblUsersInGroup.Admingroup,
tblAssets.Lastseen
From tblAssets
Inner Join tblAssetCustom On tblAssets.AssetID = tblAssetCustom.AssetID
Inner Join tsysAssetTypes On tsysAssetTypes.AssetType = tblAssets.Assettype
Inner Join tblUsersInGroup On tblAssets.AssetID = tblUsersInGroup.AssetID
Where tblUsersInGroup.Groupname = 'Power Users' And tblAssetCustom.State = 1

View solution in original post

2 REPLIES 2
Kassim
Engaged Sweeper
Thanks,

that is perfect.

Hemoco
Lansweeper Alumni
Please try this:

Select Top 1000000 tblAssets.AssetID,
tblAssets.AssetName,
tsysAssetTypes.AssetTypename,
tsysAssetTypes.AssetTypeIcon10 As icon,
tblUsersInGroup.Groupname,
tblUsersInGroup.Domainname,
tblUsersInGroup.Username,
tblUsersInGroup.Admingroup,
tblAssets.Lastseen
From tblAssets
Inner Join tblAssetCustom On tblAssets.AssetID = tblAssetCustom.AssetID
Inner Join tsysAssetTypes On tsysAssetTypes.AssetType = tblAssets.Assettype
Inner Join tblUsersInGroup On tblAssets.AssetID = tblUsersInGroup.AssetID
Where tblUsersInGroup.Groupname = 'Power Users' And tblAssetCustom.State = 1