We’re currently experiencing a high volume of support requests, which may result in longer response times — Thank you for your patience and understanding.
Community FAQ
cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 
AdmJLovejoy
Champion Sweeper
Select Top (1000000) tblAssets.AssetID,
tblAssets.AssetName, tblAssets.Domain,
tsysOS.OSname As [OS Version],
tblAssets.IPAddress,
tblSqlServers.displayVersion As [MS-SQL Version],
tblSqlServers.skuName As [MS-SQL Edition],
tblSqlServers.spLevel As SP,
tblAssets.Firstseen,
tblAssets.Lastseen,
tblAssets.Lasttried,
tsysOS.Image As icon
From tblAssets
Inner Join tblSqlServers On tblSqlServers.AssetID = tblAssets.AssetID
Left Outer Join tsysOS On tsysOS.OScode = tblAssets.OScode
Inner Join tblAssetCustom On tblAssets.AssetID = tblAssetCustom.AssetID
Where tblSqlServers.skuName Not Like 'Express%' And
tblSqlServers.skuName Not Like '%Internal%' And tblAssetCustom.State = 1
Order By tblAssets.AssetName,
tblAssets.Domain
Thanks, Jim Lovejoy __________________________________________________________________________________________________ James W. Lovejoy | IBM - Cloud Managed Services Delivery | Infrastructure Architect (Windows Server ...
0 REPLIES 0

Archive

This board contains archived posts from the retired Lansweeper Forum and Insiders Community.

New to Lansweeper?

Try Lansweeper For Free

Experience Lansweeper with your own data.
Sign up now for a 14-day free trial.

Try Now