→ Having trouble accessing our new support portal or creating a ticket? Please notify our team here

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

Could you help me generate a custom report for Microsoft software with the keys and user names please?

Im using this report at the moment:
http://www.lansweeper.com/forum/yaf_postst7942_Micrsoft-Office-license-keys.aspx
.
1 ACCEPTED SOLUTION
Hemoco
Lansweeper Alumni
If you want to add the user logged in when the computer was last scanned, then you can try this report:

Select Top 1000000 tblAssets.AssetID,
tblAssets.AssetUnique,
tblAssets.Domain,
tsysOS.OSname,
tblSerialnumber.Product,
tblSerialnumber.ProductID,
tblSerialnumber.ProductKey,
tsysOS.Image As icon,
tblAssets.Username,
tblAssets.Userdomain,
tblADusers.Displayname,
tblAssets.AssetName
From tblAssets
Inner Join tblSerialnumber On tblAssets.AssetID = tblSerialnumber.AssetID
Inner Join tblAssetCustom On tblAssets.AssetID = tblAssetCustom.AssetID
Inner Join tsysOS On tblAssets.OScode = tsysOS.OScode
Left Join tblADusers On tblAssets.Username = tblADusers.Username And
tblAssets.Userdomain = tblADusers.Userdomain
Where (tblSerialnumber.Product Like '%windows%' Or
tblSerialnumber.Product Like '%microsoft%office%') And
tblAssetCustom.State = 1
Order By tblAssets.AssetName,
tblAssets.AssetUnique,
tblSerialnumber.Product

View solution in original post

2 REPLIES 2
cognito
Engaged Sweeper
Perfect, thanks!
Hemoco
Lansweeper Alumni
If you want to add the user logged in when the computer was last scanned, then you can try this report:

Select Top 1000000 tblAssets.AssetID,
tblAssets.AssetUnique,
tblAssets.Domain,
tsysOS.OSname,
tblSerialnumber.Product,
tblSerialnumber.ProductID,
tblSerialnumber.ProductKey,
tsysOS.Image As icon,
tblAssets.Username,
tblAssets.Userdomain,
tblADusers.Displayname,
tblAssets.AssetName
From tblAssets
Inner Join tblSerialnumber On tblAssets.AssetID = tblSerialnumber.AssetID
Inner Join tblAssetCustom On tblAssets.AssetID = tblAssetCustom.AssetID
Inner Join tsysOS On tblAssets.OScode = tsysOS.OScode
Left Join tblADusers On tblAssets.Username = tblADusers.Username And
tblAssets.Userdomain = tblADusers.Userdomain
Where (tblSerialnumber.Product Like '%windows%' Or
tblSerialnumber.Product Like '%microsoft%office%') And
tblAssetCustom.State = 1
Order By tblAssets.AssetName,
tblAssets.AssetUnique,
tblSerialnumber.Product