‎04-12-2017 01:27 AM
‎11-08-2024 03:07 PM
Thanks! this is great.
‎06-14-2017 12:51 PM
Select Top 1000000 tblAssets.AssetID,
tblAssets.AssetUnique,
tblAssets.Domain,
tsysOS.OSname,
tsysOS.Image As icon,
tblSqlServers.displayVersion As Edition,
tblSqlServers.skuName As License,
tblSqlServers.version,
tblSqlServers.spLevel As SP,
tblSqlServers.fileVersion,
tblSqlServers.serviceName As Service,
tblSqlServers.lastChanged,
tblSqlServers.dataPath,
tblSqlServers.isWow64,
tblSqlServers.language,
tblSqlServers.installPath As installPath1,
tblSqlServers.installPath
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,
Edition
‎04-12-2017 05:22 PM
‎04-12-2017 05:16 PM
Select Top 1000000 tsysOS.Image As icon,
tblAssets.AssetID,
tblAssets.AssetName,
tblSqlServers.displayVersion As Edition,
tblSqlServers.skuName As License,
tblSqlServers.spLevel As [SQL SP],
tblSqlServers.version As Version,
tblSqlServers.serviceName As Service,
tblSqlServers.lastChanged,
tblAssets.Domain,
tblAssets.Username,
tblAssets.Userdomain,
tblAssets.IPAddress,
tblAssets.Description,
tblAssetCustom.Location,
tsysIPLocations.IPLocation,
tsysOS.OSname As OS,
tblAssets.SP As SP,
tblAssets.Firstseen,
tblAssets.Lastseen
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
Left Join tsysIPLocations On tblAssets.LocationID = tsysIPLocations.LocationID
Where tblAssetCustom.State = 1
Order By tblAssets.AssetName,
Edition
‎11-06-2024 07:39 PM
How would I add the ESXi server these SQL servers are running on?
‎11-08-2024 09:50 AM
try this
Select Top 1000000 tblAssets.AssetID,
tblAssets.AssetName,
SubString(tblAssets.Description, 1, 25) As description,
tblVmwareGuest.Name As VMName,
Coalesce(tblOperatingsystem.Caption, tblLinuxSystem.osrelease,
tblVmwareGuest.guestfullname) As OS,
tblAssets.IPAddress,
tblVmwareGuest.MacAddress,
tblVmwareInfo.HostName,
tblVmwareInfo.version As ESXi_Version,
tblVmwareGuest.CpuCount As VMCoreCount,
tblVmwareGuest.Memory As VMVemory,
Cast(tblVmwareGuest.UnsharedStorage As bigint) / 1024 / 1024 As VMUsedSize,
Coalesce((Select Sum(Cast(Cast(tblLinuxHardDisks.Size As BigInt) /
1024 As Numeric)) From tblLinuxHardDisks
Where tblLinuxHardDisks.AssetID = tblAssets.AssetID And
(tblLinuxHardDisks.filesystem Like '/dev/s%' Or
tblLinuxHardDisks.filesystem Like '/dev/mapper/%')), '0') +
Coalesce((Select Sum(Cast(Cast(tblDiskdrives.Size As BigInt) / 1024 /
1024 As Numeric)) From tblDiskdrives
Where tblDiskdrives.AssetID = tblAssets.AssetID), '0') As HDDSize,
tblVmwareGuest.BootTime,
tblVmwareGuest.Version,
tblAssets.Firstseen,
tblVmwareGuest.lastchanged,
tblSqlServers.displayVersion,
tblSqlServers.serviceName,
tblSqlServers.fileVersion,
tblSqlServers.version As version1
From tblVmwareGuest
Inner Join tblVmwareInfo On tblVmwareGuest.HostID = tblVmwareInfo.VmwareID
Inner Join tblSqlServers On tblVmwareGuest.AssetID = tblSqlServers.AssetID
Left Join tblAssets On tblAssets.AssetID = tblVmwareGuest.AssetID
Left Join tblLinuxSystem On tblAssets.AssetID = tblLinuxSystem.AssetID
Left Join tblOperatingsystem On tblAssets.AssetID = tblOperatingsystem.AssetID
Order By tblAssets.AssetName
Experience Lansweeper with your own data. Sign up now for a 14-day free trial.
Try Now