list power users report

[Kassim]

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

[Kassim]

Thanks,

that is perfect.

[Hemoco · Accepted solution]

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