cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 
Mohd_Al_Hafizh_
Engaged Sweeper
Please help me for SQL script to view data :
1. Asset Group (example : group A)
2. Asset Name
3. Username
4. Operating Systems

1 REPLY 1
Hemoco
Lansweeper Alumni
Please use the report below for the information you are after.
Select Top 1000000 tblAssets.AssetID,
tblAssets.AssetName,
tblAssets.Domain,
tblAssetGroups.AssetGroup,
tblAssets.Username,
tblAssets.Userdomain,
tsysOS.OSname,
tblOperatingsystem.Caption As FullOSname,
tblAssets.SP,
tblAssets.Firstseen,
tblAssets.Lastseen,
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
Inner Join tblOperatingsystem On tblOperatingsystem.AssetID =
tblAssets.AssetID
Where tblAssetCustom.State = 1
Order By tblAssets.Domain,
tblAssets.AssetName,
tblAssetGroups.AssetGroup