‎05-26-2014 11:00 PM
Solved! Go to Solution.
‎05-26-2014 11:29 PM
Select Top 1000000
tblSerialnumber.Product,
tblAssets.AssetID,
tblAssets.AssetUnique,
tblAssets.Domain,
tblSerialnumber.ProductKey,
tsysOS.Image As icon
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
Where
tblAssetCustom.State = 1
AND ( tblSerialnumber.Product LIKE 'Microsoft Office%'
OR tblSerialnumber.Product LIKE 'Windows Server%'
)
Order By
tblSerialnumber.Product,
tblAssets.AssetUnique,
tblSerialnumber.ProductKey
‎05-26-2014 11:58 PM
‎05-26-2014 11:56 PM
Where
tblAssetCustom.State = 1
AND ( tblSerialnumber.Product LIKE 'Microsoft Office%'
OR tblSerialnumber.Product LIKE 'Windows Server%'
OR tblSerialnumber.Product LIKE 'another product name%'
OR tblSerialnumber.Product LIKE 'something else%'
OR tblSerialnumber.Product LIKE 'yet another product%'
)
OR tblSerialnumber.Product = 'Microsoft Office Home and Business 2010'
OR tblSerialnumber.Product LIKE '%Home and Business%'
‎05-26-2014 11:33 PM
‎05-26-2014 11:29 PM
Select Top 1000000
tblSerialnumber.Product,
tblAssets.AssetID,
tblAssets.AssetUnique,
tblAssets.Domain,
tblSerialnumber.ProductKey,
tsysOS.Image As icon
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
Where
tblAssetCustom.State = 1
AND ( tblSerialnumber.Product LIKE 'Microsoft Office%'
OR tblSerialnumber.Product LIKE 'Windows Server%'
)
Order By
tblSerialnumber.Product,
tblAssets.AssetUnique,
tblSerialnumber.ProductKey
Experience Lansweeper with your own data. Sign up now for a 14-day free trial.
Try Now