Extracting a list of manufacturers

In order to identify a list of software and software manufacturers navigate to the Reports - All Applications 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:

1. Lookup the domain name extension for the website region. 
   • For example for Russia the domain name extension is .ru.
2. 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.