Users Guide

Warranty Output Database Schema
The following data dictionary is created when you use the /Ocs switch.
Sample command: DellWarranty-CLI.exe /I=C:\Users\[username]\Documents\FileName.csv /Ocs="Data
Source=(localdb)\MSSQLLocalDB;Database=[dbname];Integrated Security=true;"
NOTE: Supply the variable [dbname] within the /Ocs switch parameters as illustrated by the above.
Table 2. Warranty data dictionary
table_name column_name data_type data_length is_nullable Description
Dell_Asset ServiceTag nvarchar 100 0 PK
Dell_Asset BUID int 4 1
Dell_Asset ProductId nvarchar 100 1
Dell_Asset CountryLookupCode nvarchar 256 1
Dell_Asset LOB nvarchar 512 1
Dell_Asset MachineDescription nvarchar 512 1
Dell_Asset ShipDate datetime 8 1
Dell_Asset LastUpdated datetime 8 1
Dell_Asset LastRetrieval nvarchar 512 1
Dell_AssetEntitlements ServiceTag nvarchar 100 0 FK with [dbo].[Dell_Asset]
[ServiceTag]. Also, on ON
UPDATE CASCADEON
DELETE CASCADE
Dell_AssetEntitlements StartDate datetime 8 1
Dell_AssetEntitlements EndDate datetime 8 1 Field used to determine
Warranty Filters
AnyWarranty,
ActiveWarranty,
ExpiredWarranty, or
WarrantyExpiringIn30Days
Dell_AssetEntitlements ItemNumber nvarchar 100 1
Dell_AssetEntitlements ServiceLevelDescription nvarchar 512 1
Dell_AssetEntitlements ServiceLevelCode nvarchar 256 1
Dell_AssetEntitlements EntitlementType nvarchar 512 1
Dell_AssetEntitlements ServiceProvider nvarchar 256 1
Dell_AssetEntitlements LastUpdated datetime 8 1
Dell_AssetEntitlements LastRetrieval nvarchar 100 1
B
Warranty Output Database Schema 11