Is the SQL server discovery rule looking for an active listener on port 1433 (or whatever port specified)? I have read through the documentation multiple times on the discovery rules but the actual verbiage in the doc says "Allows FlexNet Manager Suite to connect to a SQL Server database using the specified ports". This is not a connection to the actual DB but to the server itself right?
We have a rule running at one of our customers and it is discovering servers that do not have SQL software on them, but at some point in the past they did. Trying to understanding what exactly is happening.
Mar 09, 2021 08:14 AM
To my knowledge, if you open an "Action" in the "Discovery and Inventory Rules" part of FNMS, the following activities are kind of a cheat, and don't belong there:
The reason why I consider these activities to be a "cheat" - "misleading" actually might be a more polite way to describe it - is that if you enable any of these activities, FNMS will not do any IP port scanning, but will try to do a remote inventory on the target computer.
The 'discovery' of these applications relies on the remote inventory results. The Flexera agent executed on the target system(s) remotely will report the Hyper-V or SQL Server on the target system. You can achieve the same result by enabling "Gather hardware and software inventory from all target devices" in the "General hardware and software inventory" section of this document. All prerequisites for doing a remote inventory - like having a valid account for the target system configured in the Beacon password store - apply here.
For proving this, the best way is to monitor the Beacon activity when the rule is executed on the Beacon. On the "Action", you have to:
When looking at the Beacon LOG files after following these steps, you will see that when the rule is executed, the Beacon tries to do a remote inventory (try to execute the Flexera agent remotely) on target devices. Even if you did not enable "Gather hardware and software inventory from all target devices".
This is different from the real discovery of Oracle databases - where the Beacon tries to connect to the Oracle listener on the target devices using the IP ports specified in the "Action" as described by @ChrisG.
Mar 09, 2021 04:05 PM - edited Mar 09, 2021 04:11 PM