I had to upgrade to 7.1.40.6 a while ago due to the SQL connection pool issues. I have increased the pool size to 200, but was still getting a lot of complaints...Unfortunately I did not notice that this is a beta version and are now faced with a lot...
This report shows you all assets that aren't assigned to the right scanning server based on IP range scanning configuration.select *From tblAssets Inner Join (Select tsysIPScanRanges.Servername As servername, Convert(numeric(18),ParseName(tsy...
This report shows you overlapping IP scan ranges and the assigned site server. Select Top 1000000 t1.IprangeID As [1 Range ID], t1.Servername As [1 Scanning server], t1.Ipstart As [1 Start], t1.Ipend As [1 End], '<----->' As [=], t2.IprangeID As...
Microsoft exposes the TCP socket table per process through WMI. The Powershell command is:gwmi -Class MSFT_NetTcpConnection -Namespace Root\StandardCimv2 If we could scan that as well and link it to other assets by their IP address, we could generate...
Select Distinct Top 1000000 tblAssets.AssetID, tblAssets.AssetName, tsysAssetTypes.AssetTypename, tblVmwareGuest.Ipv4Address, case when tblAssets1.AssetName is not null then tblAssets1.AssetName else hvasset.assetname end As Host, case when tblA...
Hi blasto,We were having similar issues. First off the Lansweeper scanning service was dying frequently as there is an issue with warranty scanning. We are still waiting for a fix for this.To mitigate the unscanned servers mostly, I have setup someth...
Thanks Esben. I have updated to 7.1.50.1 in the meantime, but we still have the issue with Lansweeper not scanning IP ranges. Is it possible that the update unticked the box for "Save pinged IPs"? We have a lot of items where we don't have any useful...
Esben.D wrote:klaus wrote:We have the same problem with 7.1.40, but we don't have AWS scanning enabled. Is moving to 7.1.50 going to help us?Yes. The problem was that the AWS merging code was not targeted correctly. Which caused it to sometimes also ...
arobinson@mlgw.org wrote:How do you only include servers that have been active during the last 30 days?and tblassets.lastseen > dateadd(dd, -30, getdate())