That's one of the basics of Snow License Manager, proper application recognition. So the answer is yes. Best way is to use the Snow agents but you could also use so called connectors to other inventory tooling available in your estate.

For MS SQL the agent uses a dedicate PowerShell script for proper edition recognition. And for Oracle you need the Snow Inventory Oracle Scanner (SIOS) option. See also Snow Inventory Oracle Scanner (snowsoftware.com)