Report on Dell Warranty Statuses for all machines using SCCM & Dell Client Integration Pack
Dell have an excellent tool freely available called Dell Client Integration Pack. Included in this tool is something called Warranty Status. What this part of the tool does is looks at your SCCM SQL database for Dell machines and their asset tags, then checks against its own warranty database for the warranty information. It then inserts all the warranty information into a new table in your SCCM SQL database allowing you to utilise this data to create reports.
We will now show you where to get this tool, how to configure it and how to create some simple reports to use it.
Once you have the downloaded the Dell Client Integration Pack, you should install it on your SCCM server. Then from your Start Menu, go to All Programs then Dell and run the Warranty Status program. Once started it should look like this:
You then need to configure the utility for use with your SCCM and SQL setup.
To start the configuration process, you should run the following command:
Dell.WarrantyInfo.exe setup_config <br />
You will then have to step though all the configuration parameters that are required, if you need to skip any like the proxy settings, just press enter to continue to the next step, these are:
- Proxy User Domain
- Proxy User Name
- Proxy Password
- Proxy Server Address
- Desired output (.csv, .xml or .db) – for this process, you should select .db
- Enter the connection string for your database (see below for example)
- Enter the WMI namespace for your Configuration Manager setup
- FQDN or IP address of your SCCM server
Provider=SQLOLEDB;Server=TGHSQL1;Database=CM_TGH;Integrated Security=SSPI; <br />
Once you have entered all this information, it will be saved into your server registry – this can be amended from this location:
HKEY_LOCAL_MACHINESOFTWAREWow6432NodeDellClientIntegrationPackWarranty <br />
To do this, run the following command:
Dell.WarrantyInfo.exe get_info internal_sccm_db<br />
This will then retrieve all the information required and insert into your SCCM database under a table called:
DellWarrantyInformation <br />
You can then use this information to create a range of reports, but for one to get you going, you can use this SQL query to create a report in SSRS:
SELECT <br /> Service_Tag AS [Service Tag], <br /> LOB + ' ' + System_Model AS [Model], <br /> Ship_Date AS [Ship Date], <br /> Start_Date AS [Warranty Start Date], <br /> End_Date AS [Warranty End Date], <br /> Days_Left AS [Days Left], <br /> Entitlement_Type AS [Status] <br /> FROM <br /> DellWarrantyInformation <br />
HOW DO I CREATE THE SSRS REPORT?
We have now created a guide that will help you to create your SSRS reports based on the data that this guide will pull into the Configuration Manager database.
You can access this guide by clicking the link below:
If you have any problems with any of the above, then please leave your comments and questions below using our Disqus system and we will try to get back to you as soon as we can.
We also like to hear back any success stories too, so if you have used our guide and found it helpful, we would love to hear from you.