cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 
kconverse
Engaged Sweeper
I added about 10 clients using the lspush export process from a firewalled domain. When I run the "Software: All SQL server editions" report the imported servers are not included in the results. I have attached the report query below.

Select Top 1000000 tblAssets.AssetID,
tblAssets.AssetUnique,
tblAssets.Domain,
tsysOS.OSname,
tsysOS.Image As icon,
tblSqlServers.displayVersion As Edition,
tblSqlServers.skuName As License,
tblSqlServers.spLevel As SP,
tblSqlServers.serviceName As Service,
tblSqlServers.lastChanged
From tblAssets
Inner Join tblAssetCustom On tblAssets.AssetID = tblAssetCustom.AssetID
Inner Join tsysOS On tblAssets.OScode = tsysOS.OScode
Inner Join tblSqlServers On tblAssets.AssetID = tblSqlServers.AssetID
Where tblAssetCustom.State = 1
Order By tblAssets.AssetName,
tblSqlServers.displayVersion
1 REPLY 1
Hemoco
Lansweeper Alumni
Lspush currently does not support sql server scanning, this will be included soon