
DerekMac asked a question.
Is there a SQL query or something to find out why a particular Beacon is selected to run vCenter Introspection? We have many Beacons and sometimes a vCenter will try to execute on multiple Beacons, working on one and failing on another, but I don't see any pertinent Subnets pointing to the failed Beacon, only the good one.
I wrote a SQL query to do this. It was easy after I found FlexNet Function IPAddressFromStr last week. It converts IP address to an Integer, and I found the Integer Range was already in SiteSubnet.
DECLARE @ip nvarchar(15)
SET @ip = '100.116.99.27'
SELECT
CONCAT(ss.IPSubnet, '/', ss.IPSubnetBits) AS 'Subnet',
ss.IPSubnet, ss.IPSubnetBits,
s.Name AS 'Site',
b.BeaconName, b.BeaconLocation
FROM SiteSubnet ss
JOIN Site s ON s.SiteID = ss.SiteID
JOIN BeaconSiteSubnetMapping bsm ON bsm.SubnetID = ss.SubnetID
JOIN Beacon b ON b.BeaconID = bsm.BeaconID
WHERE dbo.IPAddressFromStr(@ip) >= ss.IPAddressRangeFrom
AND dbo.IPAddressFromStr(@ip) <= ss.IPAddressRangeTo
The above showed me we have 4 overlapping subnets that invoke 2 different Beacons, one of which is failing because of firewall rules.
This info is a little late though, as I had already figued out that 100.0.0.0/8 (100.*) and 100.64.0.0/10 subnets where to blame and that FNMS was doing vCenter Introspection on them even though they are Disabled. Flexera Engineering created bug IOK-997120 for that.