manufacturer.csv
Version:If you are using the latest version of IT Visibility’s export, information in this section is not applicable to you. Instead, see “IT Visibility Data Export (Latest Version)”. To check whether you are using the latest version of export versus a previous 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 on a previous version. If you only see the Create Export button, you are on the latest version. For related information, see Upgrading to the Latest Version 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 |
Version:If you are using the latest version of IT Visibility’s export, information in this section is not applicable to you. Instead, see “IT Visibility Data Export (Latest Version)”. To check whether you are using the latest version of export versus a previous 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 on a previous version. If you only see the Create Export button, you are on the latest version. For related information, see Upgrading to the Latest Version of IT Visibility .
Field calculations are explained in the following tables.
• | Hardware Inventory CSV |
• | Hardware_Technopedia CSV |
• | Software_Inventory CSV |
• | Software_Technopedia CSV |
• | Custom Columns |
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])) |
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])) |
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])) |
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])) |
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" |