DELL Command Warranty Version 6.3 User Guide

: June 9, 2024
: Dell

Table of Contents

Notes, cautions, and warnings
Dell Command | Warranty
Installing Dell Command | Warranty
Launching Dell Command | Warranty
Configuring Dell Command | Warranty
Retrieving warranty information
Documents / Resources
- Read User Manual Online (PDF format)
- Download This Manual (PDF format)

Dell Command | Warranty Version 6.3
October 2022
Rev. A04
User’s Guide

Notes, cautions, and warnings

NOTE: A NOTE indicates important information that helps you make better use of your product.
CAUTION: A CAUTION indicates either potential damage to hardware or loss of data and tells you how to avoid the problem.
WARNING: A WARNING indicates a potential for property damage, personal injury, or death.

Dell Command | Warranty

Dell Command | Warranty can be installed as a stand-alone application or as part of Dell Command | Integration Suite for System Center on systems running Microsoft System Center Configuration Manager. Dell Command | Warranty helps you to retrieve the warranty information for a list of client systems stored in the Configuration Manager’s database, or in a file. Client systems are specified by their Service Tags.

Topics:

Supported System Center Configuration Manager versions
Supported client operating systems
Supported server operating systems

Supported System Center Configuration Manager versions
Dell Command | Integration Suite for System Center supports the following versions of Configuration Manager:

Microsoft System Center 2203 Configuration Manager
Microsoft System Center 2012 Configuration Manager
Microsoft System Center 2012 SP1 Configuration Manager
Microsoft System Center 2012 R2 Configuration Manager
Microsoft System Center Current Branch Configuration Manager

Supported client operating systems

Windows 11 64-bit Home
Windows 11 64-bit Professional
Windows 10 32-bit
Windows 10 64-bit
Windows 10 32-bit Professional
Windows 10 64-bit Professional
Windows 10 32-bit Enterprise
Windows 10 64-bit Enterprise
Windows 8.1 32-bit
Windows 8.1 64-bit
Windows 8.1 32-bit Professional
Windows 8.1 64-bit Professional
Windows 8.1 32-bit Enterprise
Windows 8.1 64-bit Enterprise

Supported server operating systems

Windows Server 2022
Windows Server 2019
Windows Server 2016
Windows Server 2012 R2
Windows Server 2012

Installing Dell Command | Warranty

Dell Command | Warranty can be installed either as a stand-alone application, or as part of the Dell Command | Integration Suite for System Center on systems running Microsoft System Center Configuration Manager.
NOTE: You must be logged in as the system administrator to install Dell Command | Warranty.

Topics:

Installing Dell Command | Warranty as part of Dell Command | Integration Suite for System Center
Installing Dell Command | Warranty as a stand-alone application

Installing Dell Command | Warranty as part of Dell Command | Integration Suite for System Center

Download and save the Dell Command | Integration Suite for System Center.exe file to the system you use to manage your clients.
Click the Dell Command | Integration Suite for System Center.exe file, and then click Next at the welcome screen.
Accept the License Agreement, and then click Next.
The Choose Installation Options screen is displayed.
Select the installation option and click Next.
Select the Complete installation option, and then click Next.
Follow the remainder of the installation wizard process.
When the installation process has completed, click Finish.

Installing Dell Command | Warranty as a stand-alone application

Download and save the Dell Command | Integration Suite for System Center *.exe file to the system you use to manage your clients.
Click the *.exe file, and then click Next at the welcome screen.
Accept the License Agreement, and then click Next.
The Choose Installation Options screen is displayed.
Select the installation option and click Next.
Select the Custom installation option, and then click Next.
Click the drop-down box beside Configuration Manager Extensions, and select the This feature will not be available option.
Click Next, and follow the remainder of the installation wizard process.
When the installation process has completed, click Finish.

Launching Dell Command | Warranty

Launch Dell Command | Warranty using a command-line tool.

Open a command prompt.
Go to the folder in which you have placed the Dell Command | Warranty files.
For example, type: C : \ Program Files (x86)\Dell\Command Integration Suite\
Type the name of the executable file.
For example, type: Dell Warranty-CLI.exe

Configuring Dell Command | Warranty

Before you use Dell Command | Warranty, do the following:

Launch Dell Command | Warranty.
For more information, see Launching Dell | Command Warranty.
Enter Dell Warranty-CLI.exe/H to display usage.
NOTE: For Dell Command | Warranty to function you must provide an /InputFile or an /InputCfgMgrConnectionString parameter. See Command-line interface (CLI) options.
Logs for Dell Command | Warranty can be found at the default log location: % Program Data %\Dell\Command Integration Suite\warranty. log.
NOTE: For Verbose logs during Dell Command | Warranty execution, use /V parameter. See Command-line interface (CLI) options.

Retrieving warranty information

If the system on which Dell Command | Warranty is installed has access to Configuration Manager and connects to the Internet (including through proxy):
a. Launch Dell Command | Warranty.
For more information, see Launching Dell Command | Warranty.
b. Configure Dell Command | Warranty.
For more information, see Configuring Dell Command | Warranty.
c. To retrieve the warranty information through the Configuration Manager database:
● Use the command: DellWarranty-CLI.exe /ICS=”Data Source=[host];Database=[ Configuration Manager dbname];Integrated Security=true;”
● Connection string to the Configuration Manager database:
● “Data Source=[host];Database=[ Configuration Manager dbname];Integrated Security=true;”)
● “Data Source=[host];Database=[ Configuration Manager dbname];User id=[username];Password=[userpwd]”
NOTE: If you choose not to pass the password as a plain text command line argument, Dell Command | Warranty prompts for a password separately to mask or hide the plain text password.
See CLI Options for more information.
The warranty information of the Dell client systems is retrieved and saved as a .csv file in the default path: [%ProgramData%\Dell\CommandIntegrationSuite\][WarrantyOutputiyyyyMMddhhmmss].csvfolden
NOTE: The file is saved as Warrantylnformation yyyyMMddhhmmss. csv (where yyyy is the year, MM is the month, dd is the day, hh is the hour, mm is the minute, and ss is the second).
If the system on which Dell Command | Warranty is installed does not have access to Configuration Manager, but connects to the Internet (including through proxy):
a. Launch Dell Command | Warranty.
For more information, see Launching Dell Command | Warranty .
b. Create a .csv file containing the service tags.
c. To retrieve the warranty information for the service tags saved in the .csv file, you created in the previous step:
• Enter the following command: DellWarranty-CLI .exe /I=C: \ FileName.csv. The warranty information of the Dell client systems is retrieved and saved as a .csv file in the default path: [%ProgramData%\Dell\CommandIntegrationSuite\][WarrantyOutputiyyyyMMddhhmmss].csvfolden To override the default path, use the command-line option /E. See Command-line interface (CLI) options.
NOTE: The file is saved as War rantyOutput[yyyMMddhhmmss].csv (where yyyy is the year, MM is the month, dd is the day, hh is the hour, mm is the minute, and ss is the second).
NOTE: The default name can also be overwritten when you use the command- line option /E. Also, if invalid tags are found in the request file, a %ProgramData% \ Dell \CommandIntegrationSuite \ ] [WarrantyerrorOutput[yyyyMMddhhmmss] .csv) file is created.

Command-line interface (CLI) options

Use the following CLI options and syntax when engaging the warranty tool. CLI options are listed in the first column, followed by their abbreviations, descriptions, and syntax in subsequent columns. The command syntax is:
C:\Program Files (x86)\Dell\CommandIntegrationSuite>DellWarranty-CLI.exe /?DellWarranty-CLI.exe (/I= 1 /Ics=) [/E=] [/Ocs=] [/F=] [/ Ps=] [/Pu=] [/Pd=] [/V] [1141] [/H] [/U]

Table 1. CLI options and syntax

CLI Option Name| CLI Option
Abbreviation| Description| Syntax
---|---|---|---
/Help| /H| Display usage (this information). The parameter is optional.| Dell WarrantyCLI.exe/H
/Usage| /U| Display usage (this information). The parameter is optional.| Dell WarrantyCLI.exe /U
/InputFile| /I| NOTE: For the warranty tool to function, you must provide at least one of the two input flags, /I or /Ics.
The full path to an input CSV file of service tags
(C:\FileName.csv)
Required parameter; can be used with configuration manager connection string.| Dell Warranty-CLI. exe/
I=C:\File Name.csv
/InputCfgMgrConnectionString| /Ics| NOTE: For the warranty tool to function, you must provide at least one of the two input flags, /I or /Ics.
Connection string to the Configuration Manager database.
(“Data Source=[host];Database=[Configuration
Manager dbname];Integrated Security=true;”)
(“Data Source=[host];Database=[ Configuration
Manager dbname];User
id=[username];Password=[userpwd]”)
NOTE: If you choose not to pass the password as a plain text command line argument, Dell Command | Warranty prompts for a password separately to mask or hide the plain text password.
Required parameter; can be used with input CSV file.| Dell Warranty-CLI.exe/
Ics=” Data Source=[host];
Data base =[Configuration
Manager db name] ;
Integrated Security=true ; “
/ExportFile| /E| The full path to a CSV export file. File will contain warranty information after CLI execution.(Default:[%ProgramData%
\Dell\CommandIntegrationSuite\ ] [WarrantyOutput_[yyyyMMddhhmmss].csv (C:\WarrantyOutputFileName.csv)
The parameter is optional.| Dell Warranty-CLI. exe/
I= C:\File Name.csv/
E=C:\Warranty Output file name.csv
/OutputConnectionString| /Ocs| Connection string to the output warranty database. Will contain warranty information after CLI execution.
(“Data Source=[host];Database=[Warranty dbname];Integrated Security=true;”)
The parameter is optional. The /Ocs command creates a database with the name given as above. The location of the database is %USERPROFILE% \[Warranty dbname].mdf, while the log file is %USERPROFILE%\[Waranty dbname]_log.ldf.
The %USERPROFILE% variable is typically C: \Users\[username]\ on a Windows 10 system.
Once the database is created, the /Ocs command creates two additional tables:
Dell_Asset and Dell_AssetEntitlement. These tables are used to store warranty data that is cleared first, and then populated from your /InputFile or /InputCfgMgrConnectionString servicetags.
NOTE: Once the database has been created, you can change the location of your [warranty dbname].mdf and
[Warranty dbname]_log.ldf files using either the SQL command, alterdata base, or SQL Server Management Studio.
NOTE: If the database already exists and the Dell_Asset and Dell_AssetEntitlement tables do not exist, then you must createthe tables.| Dell Warranty – CLI.exe/
I=C:\File Name.csv/
Ocs= ” Data
Source= [host];
Database = [Warranty db name];
Integrated Security = true;”
/Filter| /F| Filter for the warranty API and Database
(Default: AnyWarranty)
(ActiveWarranty or ExpiredWarranty or WarrantyExpiringIn30Days) (/F=ActiveWarranty)
The parameter is optional.| Dell Warranty CLI.exe/
I = C : \ File Name.csv/
F = Active Warranty
/ProxyUrl| /Ps| Proxy Server URL (proxy.domain.com[:port])
The parameter is optional.| Dell Warranty – CLI.exe /
I = C : \File Name.csv /
Ps = proxy.domain.com [ : p o r t]
/ProxyUser| /Pu| Proxy User Name ([proxy user name])
The parameter is optional.| Dell Warranty – CLI.exe/
I = C : \ File Name.csv /
Ps = proxy.domain.com [: port] /
Pu = [proxy user name] /
Pd = [proxy user password]
/ProxyPwd| /Pd| Proxy User Password
(/Pd=[proxy user password])
The parameter is optional.
NOTE: If you choose not to pass the password as a plain text command line argument, Dell Command | Warranty prompts for a password separately to mask or hide the plain text password.| Dell Warranty – CLI.exe /
I = C : \ File Name.csv /
Ps = proxy.domain.com [: po t] /
Pu = [ proxy user name ] /
Pd = [ proxy user password]
/Verbose| /V| Display additional information while executing (/V)
The parameter is optional.| Dell Warranty CLI.exe /
I = C :\
File Name.csv / V
/Wait| /W| Wait for user input before terminating – best used when debugging (/W)
The parameter is optional.| Dell Warranty CLI.exe /
I = C :\
File Name.csv/ W

Warranty output database schema
The following data dictionary is created when you use the /Ocs switch.
Sample command: Dell Warranty – CLI.exe/ I = C : \ Users\ [user name] \ Documents \ File Name.csv / Ocs = ” Data Source = ( localdb ) \ MSSQLLocalDB;
Data base = [ dbname ] ; Integrated Security = true; ”
NOTE: Supply the variable [dbname] within the /Ocs switch parameters as illustrated by the above sample command.
NOTE: If you choose not to pass the password as a plain text command line argument, Dell Command | Warranty prompts for a password separately to mask or hide the plain text password.
Table 2. Warranty data dictionary

table_name| column_name| data_type| data_lengt h| is_nullable| Description
---|---|---|---|---|---
Dell_Asset| ServiceTag| nvarchar| 100| 0| PK
Dell_Asset| BUID| int| 4| 1| NA
Dell_Asset| ProductId| nvarchar| 100| 1| NA
Dell_Asset| CountryLookupCode| nvarchar| 256| 1| NA
Dell_Asset| LOB| nvarchar| 512| 1| NA
Dell_Asset| MachineDescription| nvarchar| 512| 1| NA
Dell_Asset| ShipDate| datetime| 8| 1| NA
Dell_Asset| LastUpdated| datetime| 8| 1| NA
Dell_Asset| LastRetrieval| nvarchar| 512| 1| NA
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| NA
Dell_AssetEntitlements| EndDate| datetime| 8| 1| Field used to determine Warranty Filters AnyWarranty, Active Warranty, Expired Warranty, or WarrantyExpiringIn30Day s
Dell_AssetEntitlements| ItemNumber| nvarchar| 100| 1| NA
Dell_AssetEntitlements| ServiceLevelDescription| nvarchar| 512| 1| NA
Dell_AssetEntitlements| ServiceLevelCode| nvarchar| 256| 1| NA
Dell_AssetEntitlements| EntitlementType| nvarchar| 512| 1| NA
Dell_AssetEntitlements| ServiceProvider| nvarchar| 256| 1| NA
Dell_AssetEntitlements| LastUpdated| datetime| 8| 1| NA
Dell_AssetEntitlements| LastRetrieval| nvarchar| 100| 1| NA

© 2019 – 2022 Dell Inc. or its subsidiaries. All rights reserved. Dell Technologies, Dell, and other trademarks are trademarks of Dell Inc. or its subsidiaries. Other trademarks may be trademarks of their respective owners.

October 2022
Rev. A04