Advice on identifying a list of software manufacturers and location using Snow License Manager
Extracting a list of manufacturers
In order to identify a list of software and software manufacturers navigate to the Reports - All Applications report. Learn how to find a report.When viewing the All Applications report you can export the list via submenu shown below:
To see a list of all manufacturers navigate to Applications – Application Manufacturers. When viewing Application Manufacturers, you can select to export the list by right-clicking on the table and selecting your preferred export option:
Locating manufacturers from a country
If you are looking to locate a list of manufacturers located in a particular country one way that you may able to locate them is by using a select statement against your Snow database based on the manufacturer website. To do this:
- Lookup the domain name extension for the website region.
- For example for Russia the domain name extension is .ru.
- Run the select statement for the required domain name extension:
select * from tblManufacturer where Website like '%.<insert extension>/%' or website like '%.< insert extension>"
-
- For example:
select * from tblManufacturer where Website like '%.ru/%' or website like '%.ru'"
Example shown below when using a Snow Management and Configuration Center (SMACC) Filter: (not exportable)
The tblManufacturer table shows all manufacturers but you can cross-reference this with the installations table to see which installations you may have from the manufacturers. An example SQL Query:
with manufacturers as ( select * from tblManufacturer where Website like '%.ru/%' or website like '%.ru') select ch.cid, a.name, m.name, m.website, ch.i as installations, ch.m as lastcompliance from manufacturers m inner join tblapplication a on a.ManufacturerID = m.ManufacturerID inner join (select cid, applicationid, max(year * 100 + Month) as m , max(Installations) as i from tblApplicationSummary group by cid, applicationid) ch on a.ApplicationID = ch.ApplicationID
Please note: This advice may help you to identify some manufacturers based in a country but of course some manufacturers may not use a local domain name extension (using for example a .com, .org, .net, .gov extension).
In addition, you may also be able to extract a list of software manufacturers from a trusted source on the internet and cross reference this against your All Applications report export.
Was this helpful?
