5 Ways to view Hardware Inventory Information of a Device with SCCM

Nicolas PilonConsole, Hardware Inventory, REPORT, SCCM, SQL, SSRS5 Comments

One of the SCCM features is to inventory hardware information from devices that are managed by the SCCM client. It’s not very difficult to enable and configure the hardware inventory client settings in SCCM. Once the devices received next machine policy and hardware inventory scan, data will start to populate in your SCCM database. The information gathered from the devices can be very useful from a system health, inventory or operation perspective. You can use this information to create collections, queries as well as reports. However, one thing not too obvious with the hardware inventory information is to see all the data of a device in a one pager. There’s several ways to do it, some more difficult than others, but we will show you how. SCCM Hardware Inventory – Resource Explorer The first one is the Resource Explorer tool. It’s a tool accessible directly within the console and which don’t require any … Read More

Complete SCCM 2012 SQL Install Guide

Benoit LecoursSCCM47 Comments

In the first part of this SCCM 2012 and SCCM 1511 blog series, we planned our hierarchy, prepared our Server and Active Directory. In part 2, we will install and configure SQL before installing SCCM 2012 R2 or SCCM 1511. Click the following link to see all supported SQL versions. For our post, we will install SQL 2012 SP2 locally on the same server where the Primary Site will be installed. SCCM 2012 SQL Install Guide Execute Setup.exe from the SQL installation media, select New Installation Review and Click Next Select Enter Product Key and skip the proposed updates. We will install CU4, later Select SQL Server Feature Installation Select the Database Engine, Reporting Services and Management Tools features and specify the SQL installation directory. This is the directory for the program files and shared features Select Default instance and ensure that your instance is created on the SQL Volume Review and click Next Set all … Read More

Install SCCM 2012 Reporting Services Point

Benoit LecoursSCCM, SQL, SSRS22 Comments

In this part of SCCM 2012 and SCCM 1511 blog series, we will describe how to install a SCCM 2012 or SCCM 1511 reporting services point. This role can be installed on a remote machine, the process is the same but the logs location is different. Requirements Before you can install the reporting services point role you must configure SQL correctly. We’ll be using SQL 2012 on this post. We are assuming that SQL is already installed and that your SCCM site is up and healthy. During the initial SQL installation, you must select Reporting Services. If you have installed SQL Server, but have not installed Reporting Services follow the following steps. If Reporting Services is already installed, skip to the “Configure Reporting Services” section. Launch the SQL Server 2012 installation from the media. Click the Installation link on the left to view the Installation options. Click the top link, New SQL Server stand-alone … Read More

SCCM 2012 Reports not Running from the Console

Benoit LecoursSCCM2 Comments

SCCM reports are great way of getting information from SCCM 2012. Any users who has access to run reports can see them locally  from SCCM Console on their computer. They can also use the reporting web portal to see them (Usually : http://SccmServerName/reports) Problem Your SCCM Reporting Point is running fine, you can see all reports in the console but SCCM 2012 Reports not running when you : Browse to the Monitoring / Reporting / Reports Right-click any SCCM 2012 report and select Run                                Running the same report from the web portal is working fine Cause Navigate to the console log file C:\Program Files(X86)\Microsoft Configuration Manager\AdminConsole\AdminUILog\smsadminui.log The following error will be displayed : Microsoft ReportViewer Winforms version or one of its dependencies. The system cannot find the file specified This error means that Report Viewer is not locally installed on the computer. Resolution Close … Read More