Export software manufacturer lists from Snow License Manager to review the information in a spreadsheet, compare it with manufacturer lists from trusted sources, or share it with procurement and security teams.

You can also search manufacturer website values for country-specific domain extensions when investigating manufacturers associated with a particular country. A matching domain provides a starting point for research; it does not confirm where a manufacturer is based.

Export software and manufacturer lists

1. Open Reports > All Applications to view software and manufacturer information.
2. In the All applications report, open the menu with three vertical dots in the upper-right corner, next to Column selector, and select Export.

To view a list of all manufacturers, open Applications > Application Manufacturers. Right-click the table and select your preferred export option.

Search manufacturer websites by domain extension

To help identify manufacturers associated with a particular country, you can search manufacturer website values in the Snow License Manager database for a country-specific domain extension.

1. Look up the domain extension for the country. For example, Russia uses .ru.
2. Replace <insert extension> with the extension without its leading period, then run the following query.

select * from tblManufacturer
where Website like '%.<insert extension>/%'
   or website like '%.<insert extension>'

For example, to search for .ru website values:

select * from tblManufacturer
where Website like '%.ru/%' or website like '%.ru'

The following example uses a filter in Snow Management and Configuration Center (SMACC). The filter results cannot be exported.

Review installation information for matching manufacturers

The tblManufacturer table shows all manufacturers. You can cross-reference these records with application summary data to review installation information associated with the matching manufacturers. For example:

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

This approach may help identify some manufacturers based in a particular country. However, some manufacturers may use other domain extensions, such as .com, .org, .net, or .gov, so this search will not identify every manufacturer in that country.

You can also obtain a list of software manufacturers from a trusted internet source and cross-reference it with your All Applications report export.