Asset Intelligence Report for Lenovo

Modify Asset Intelligence Hardware Inventory Report for Lenovo

Lenovo stores its model information in a different WMI class property then most other manufactures. This post details how to add an additional column to the “Hardware 01A – Summary of computers in a specific collection” report to include this information. While this post details a particular solution, it can also be used as a general introduction to custom reports.

First, you will need the attached report (RDL) file. You can import this report into your environment through the SSRS report manager site on your reporting point. Navigate to the report folder where you want to import the report and click Upload File in the top bar.

Untitled-1 copy

Navigate to the file and upload it. Next, hover over of the report and click the download arrow to the right of the name and select “Edit in Report Builder”. Report Builder will download and open on your computer.

Next, you will need a data source. In report builder, right-click on “Data Sources” and select Add Data Source. Click Browse. It should open your report point. If the box is not in the ConfigMgr_<site code> folder, open that folder. Scroll all the way to the end and select Data Connection.


Now, expand the Datasets node and right-click on DataSet0 and click DataSet Properties. When you open this box, it should change the “Data Source” box to read DataSource1. Repeat this for DataSet1 and DataSetAdminID.


Now you can click “Run” in the ribbon and execute the report to ensure that it works. You should have a new column titled “Model-Lenovo” with your Lenovo model information. After you confirm that it works, click the SQL Server icon in the top-left corner and select “Save”. This will save the report to your report server.

I renamed the report to Hardware 01B to get it some version control. You can either delete Hardware 01A, move it somewhere else, or just leave it in place.


All content provided on this blog is for information purposes only. Windows Management Experts, Inc makes no representation as to accuracy or completeness of any information on this site. Windows Management Experts, Inc will not be liable for any errors or omission in this information nor for the availability of this information. It is highly recommended that you consult one of our technical consultants, should you need any further assistant.

[download id=”5948″]



Contact Us

On Key

More Posts

WME Cybersecurity Briefings No. 004
Cyber Security

WME Security Briefing 11 April 2024

Mispadu Trojan Exploits Windows Vulnerability to Target Financial Data Overview The Mispadu banking trojan has intensified its operations as it’s exploiting an already patched Windows SmartScreen flaw. Since its initial identification in 2019, Mispadu has primarily preyed on

Read More »
WME Cybersecurity Briefings No. 003
Cyber Security

WME Security Briefing 29 March 2024

Russian hackers escalating their cyber warfare, deploying TinyTurla-NG to breach European NGOs. Cisco Talos reveals a targeted attack against organizations advocating democracy and supporting Ukraine. With their sophisticated methods, these cyber attackers are bypassing antivirus defenses

Read More »
Be assured of everything

Get WME Services

Stay ahead of the competition with our Professional IT offerings.