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

Nicolas PilonConsole, Hardware Inventory, REPORT, SCCM, SQL, SSRSLeave a Comment

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 … Read More

Configure SCCM 2012 to Inventory RAID Controller Drivers

Nicolas PilonHardware Inventory, SCCM, SQL1 Comment

A RAID controller is a device used to manage hard disk drives (HDDs) or solid-state drives (SSDs) in a computer or storage array. It has the ability to access multiple copies of data on multiple physical devices and improve performance with data protection in case of a system failure. We suggest to keep your RAID controller drivers updated to have the latest fixes from the manufacturer. In this post, we will show you how to configure SCCM 2012 to inventory RAID controller drivers to prepare a deployment targeting the affected systems. We will show how to modify SCCM 2012 hardware inventory classes to get this information. … Read More

Install SCCM 2012 Reporting Services Point

Benoit LecoursSCCM, SQL, SSRS21 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 … Read More

Report Subscription in SSRS does not list Email in Drop Down Menu

Benoit LecoursSCCM, SQL, SSRS5 Comments

What can you do when your report subscription in SSRS does not list email in drop down menu? Symptoms When you first try to create an email subscription in SCCM 2012, you only have the Windows Share choice in the drop down menu. Email is missing from the list. Cause The principal cause of this issue is that your SSRS is not configured properly to send emails. Resolution Log to your SSRS server Open Reporting Service Configuration Manager Click on the Email Settings tab Enter the settings of your sender address and SMTP server Click Apply Verification Once completed, go back in SCCM … Read More

Understanding the Reassign Distribution Point Process

Benoit LecoursSCCM, SQL4 Comments

Here’s a detailed post on the process of upgrad (RTM,SP1) / reassign distribution point from 2007 during your migration project. What really happens when you click on “Reassign Distribution Point” on ConfigMgr 2012 R2: ? How to track the progress ? The process is quite simple : 1. Removal of DP role in the 2007 site 2. Delete site system record in the 2007 site 3. Delete shared DP role in the 2012 site 4. Delete shared DP site system record in the 2012 site 5. Install a new site system in the 2012 site 6. Install a new DP role in … Read More

Is_Virtual_Machine in v_R_System is not showing Properly with a Virtual Machine under VMWare ESXI 5.1

Nicolas PilonSCCM, SQL1 Comment

There’s a new field in v_R_system view on SCCM 2012 SQL database named Is_Virtual_Machine. It is really easier when it’s time to target virtual machines with this field instead using manufacturer, model or v_GS_Virtual_Machine under SCCM 2007. Today, we were making a spot check in our data integrity when we found two manufacturers and models VMWare flagged as non-virtual machine. In the SCCM SQL database, the source for v_R_system view is System_DISC. The associate WMI class is SMS_R_System Server. From the MSDN website, the description of Is_Virtual_Machine in the WMI class is. 1 is a virtual machine and 0 is a physical machine. How … Read More

SCCM Query to identify who imported OSD Computers

Benoit LecoursSCCM, SQL, SSRSLeave a Comment

This query might be helpful to know who imported a specific computer. You can view this information in the Status Message Queries and search for MessageID #30213. But this query will target only the information you need. You can use this query to create a report or directly in SQL MS. select CASE smsgs.Severity WHEN -1073741824 THEN ‘Error’ WHEN 1073741824 THEN ‘Informational’ WHEN -2147483648 THEN ‘Warning’ ELSE ‘Unknown’ END As ‘SeverityName’, smsgs.MessageID, smsgs.Time, smwis.InsString1 as Username, smwis.InsString4 as ComputerName, smwis.InsString5 as MAC from v_StatusMessage smsgs join v_StatMsgWithInsStrings smwis on smsgs.RecordID = smwis.RecordID join v_StatMsgModuleNames modNames on smsgs.ModuleName = modNames.ModuleName where smsgs.MessageID … Read More

The Microsoft Software License Terms have not been Completely Downloaded

Benoit LecoursSCCM, SQL7 Comments

Problem SMS_WSUS_SYNC_MANAGER state is critical even if it worked in the previous months. Environment SCCM 2012 R2 SQL 2012 Windows 2012 R2 Wsyncmgr.log shows error on 2 updates : The Microsoft Software License Terms have not been completely downloaded and cannot be accepted Event viewer/Application Logs shows Access Denied errors on a different patch. Resolution The Wsuscontent directory was missing an NTFS permission. I added the “Network Service” account full control on the directory and sub-directory and launch a new sync. Everything sync successfully. All the details come from Technet. Benoit LecoursFounder of System Center Dudes. Based in Montreal, Canada, … Read More