Does anyone happen to know if the built-in adapters has the capability to gather database information on hosts running Microsoft SQL?
Also, is there any value for enabling the "Microsoft SQL Server" Discovery and Inventory Action rule?
‎Sep 27, 2021 02:39 PM
What kind of database information are you looking to gather on hosts running Microsoft SQL Server? If you are looking for the SQL Server Edition information SCCM does not gather that by default. You would either need to install the FlexNet Inventory Agent on your SQL servers or alternatively if your organization has Tanium with the Asset module deployed with the Tanium client deployed to the SQL Servers that adapter will gather the SQL Edition information for ingestion into FNMS.
As for the Microsoft SQL Server rule, I have yet to find it valuable. I posted a question a while back essentially asking the same thing. Here is that thread --
https://community.flexera.com/t5/FlexNet-Manager-Forum/SQL-Server-Discovery/td-p/183291
‎Sep 29, 2021 06:57 AM
I was hoping to gather the number of instances running on specific SQL hosts (I.E. Oracle Instances) and creating a report that provides that type of information to our team.
I'm assuming that functionality would not be there since Microsoft does not license based on the number of instances running on a host.
‎Sep 29, 2021 09:56 AM
I see nobody replied to confirm the assumption above, but you're on the right track there: details such as the number of SQL Server instances running on a device are not imported by FlexNet Manager Suite. That information does not generally have licensing implications.
‎Dec 05, 2021 07:06 PM