manufacturer.csv

Version:If you are using the Technology Intelligence Platform version of IT Visibility’s export, information in this section is not applicable to you. Instead, see IT Visibility Data Export Using Technology Intelligence Platform. To check whether you are using Technology Intelligence Platform or Pre-Technology Intelligence Platform version, go to the Data Export page (IT Visibility > Data Exports). If you see two buttons for exporting—a Create Export button and a Create Export (Beta) button—you are using a Pre-Technology Intelligence Platform version (export version 1 or version 2). If you only see the Create Export button, you are either on the Technology Intelligence Platform version or export version 3. For related information, see Upgrading to the Export Version 3 of IT Visibility.

This file contains information on manufacturers.

Column Position	Column Name
1	technopedia_id
2	owner
3	website
4	tier
5	legal
6	symbol
7	phone
8	country
9	city

Field Calculations

Field calculations are explained in the following tables.

•

Hardware Inventory CSV

•

Hardware_Technopedia CSV

•

Software_Inventory CSV

•

Software_Technopedia CSV

•

Custom Columns

Hardware Inventory CSV

The following table explains the calculations included with the Hardware Inventory CSV.

Result	Calculation
Count HW Manufacturer	CALCULATE(DISTINCTCOUNT(Hardware_Technopedia[Manufacturer ID]))
Count HW Models	CALCULATE(DISTINCTCOUNT(Hardware_Technopedia[Model Name]))
Count HW Products	CALCULATE(DISTINCTCOUNT(Hardware_Technopedia[Product Name]))
Count Systems	CALCULATE(DISTINCTCOUNT(Hardware_Inventory[Hardware ID]))

Hardware_Technopedia CSV

The following table explains the calculations included with the Hardware_Technopedia CSV.

Result	Calculation
Count HW CAT	CALCULATE(DISTINCTCOUNT(Hardware_Technopedia[Category]))
Count HW SUB-CAT	CALCULATE(DISTINCTCOUNT(Hardware_Technopedia[Subcategory]))

Software_Inventory CSV

The following table explains the calculations included with the Software_Technopedia CSV.

Result	Calculation
Count SW Installs	CALCULATE(COUNT(Software_Inventory[Technopedia GUID]))
Count SW Manufacturer	CALCULATE(DISTINCTCOUNT(Software_Technopedia[Manufacturer ID]))
Count SW Products	CALCULATE(DISTINCTCOUNT(Software_Technopedia[Product ID]))
Count SW Releases	CALCULATE(DISTINCTCOUNT(Software_Technopedia[Release ID]))
Count SW Versions	CALCULATE(DISTINCTCOUNT(Software_Technopedia[Version ID]))

Software_Technopedia CSV

The following table explains the calculations included with the Software_Technopedia CSV.

Result	Calculation
Count SW CAT	CALCULATE(DISTINCTCOUNT(Software_Technopedia[Category]))
Count SW SUB-CAT	CALCULATE(DISTINCTCOUNT(Software_Technopedia[Subcategory]))

Custom Columns

If, else, and else if statements are explained in tables for the following custom columns.

•

Hardware Support Custom Column

•

Hardware End of Sale Custom Column

•

Software Support Custom Column

Hardware Support Custom Column

The following table explains the if, else, and else if statements for the Hardware Support custom column.

Condition	Result
if [General Availability Date] = null and [General Availability Exception] = "" and [Last Availability Date] = null and [Last Availability Exception] = "" and [Obsolete Date] = null and [Obsolete Date Exception] = ""	then "No Technopedia Research"
else if [Obsolete Date] = null	then [Obsolete Date Exception]
else if [Obsolete Date] >= Date.From(DateTime.LocalNow())	then "Supported"
else if [Obsolete Date] < Date.From(DateTime.LocalNow())	then "Obsolete"
else	"No Rule"

Hardware End of Sale Custom Column

The following table explains the if, else, and else if statements for the Hardware End of Sale custom column.

Condition	Result
if [General Availability Date] = null and [General Availability Exception] = "" and [Obsolete Date] = null and [Obsolete Date Exception] = ""	then "No Technopedia Research"
else if [Last Availability Date] = null	then [Last Availability Exception]
else if [Last Availability Date] >= Date.From(DateTime.LocalNow())	then "On Sale"
else if [Last Availability Date] < Date.From(DateTime.LocalNow())	then "End of Sale"
else	"No Rule"

The following table explains the if, else, and else if statements for the Hardware End of Sale custom column when using the option “no populated last availability exception”.

Condition	Result
if [General Availability Date] = null and [General Availability Exception] = "" and [Obsolete Date] = null and [Obsolete Date Exception] = ""	then "No research"
else if [Last Availability Date] = null and [Last Availability Exception] = ""	then [Obsolete Date Exception]
else if [Last Availability Date] = null	then [Last Availability Exception]
else if [Last Availability Date] >= Date.From(DateTime.LocalNow())	then "On Sale"
else if [Last Availability Date] < Date.From(DateTime.LocalNow())	then "End of Sale"
else	"No Rule"

Software Support Custom Column

The following table explains the if, else, and else if statements for the Software Support custom column.

Condition	Result
if [General Availability Date] = null and [General Availability Exception] = "" and [End of Life Date] = null and [End of Life Exception] = ""	then "No Research"
else if [General Availability Date] = null	then [General Availability Date Exception]
else if [End of Life Date] = null	then [End of Life Exception]
else if [End of Life Date] >= DateTime.From(DateTime.LocalNow())	then "Standard Support"
else if [End of Life Date] < DateTime.From(DateTime.LocalNow()) and [Obsolete Date] >= DateTime.From(DateTime.LocalNow())	then "Extended Support"
else if [Obsolete Date] < DateTime.From(DateTime.LocalNow())	then "Obsolete"
else	"No Rule"