SCCM Office 365 Inventory Report

Benoit LecoursHardware Inventory, OFFICE, REPORT, SCCM98 Comments

This post describes how to inventory Office 365 using SCCM 1606. We will also provide a free report at the end of the post that you could use on your Reporting Point to easily display Office 365 inventory data. SCCM 1606 introduces new hardware inventory classes for Office 365 configurations. You no longer need to edit your MOF files to gather Office 365 inventory. If you are using SCCM 1602 or below, follow Jason Sandys post which describes Office 365 inventory process using a MOF customization. If your goal is to deploy Office 365 updates, refer to our post on how to manage Office 365 updates using SCCM. SCCM Office 365 inventory report post summary : SCCM Office 365 Inventory Report – Direct Download link If you don’t want to read the whole post, you can download the RDL file directly using this link : Office 365 Inventory Data Office 365 is using new update channels and update mechanisms. Tracking versions and update … Read More

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

Nicolas PilonConsole, Hardware Inventory, REPORT, SCCM, SQL, SSRS7 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

How to resolve Dataldr.log SQL Error in SCCM 2012

Nicolas PilonHardware Inventory, SCCM4 Comments

Are you having inventory issue in SCCM where machines information from the hardware inventory were not updated on the site server? This problem can affect your various systems that use data, such as license management or reports. You can read more about the basics of client inventory and hardware inventory process. This post explains how to resolve the message dataldr.log SQL Error in SCCM 2012. Log file dataldr.log on the site server manages inventory received from clients. If the log file inventoryagent.log on the client shows no evidence of failure and you have this error, your hardware inventory won’t be updated in the SQL database. The string or binary data would be truncated. : dINSTALLED_SOFTWARE_DATA ERROR – SQL Error in ERROR – is NOT retyrable There’s no real explanation of this purpose, but it is a SQL issue for sure. Even with a full hardware inventory scan on the client, the data is not reset. We … 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. RAID Controller Drivers Information You can find RAID controller drivers information in System Information. Launch System Information from msinfo32.exe directly from Run in Start Menu Expand Components / Storage / SCSI In the WMI, the information of RAID controller is in WIN32_SCSIController but it doesn’t include driver version. In this case, you … Read More

Multilingual User Interface Pack inventory with SCCM 2012

Nicolas PilonHardware Inventory, SCCM3 Comments

We all use a minimum of one operating system language on our computers.  It may be likely that a company that has many employees may end up with several nationalities. This means, more multilingual user interface (MUI) pack is required in your operating system deployment. When a MUI Pack is installed, the user interface language can be change to one of 33 supported languages. In this post, we will extend hardware inventory in SCCM 2012 to inventory multilingual user interface pack information. Here’s the steps in order to achieve this goal : Custom WMI Class Package Creation Package Deployment Hardware Inventory Verification Pre-requisites Download Multilingual User Interface Pack kit for hardware inventory in SCCM 2012 from TechNet Gallery. Unzip the file Copy ps1 in your package source directory Copy Operating System Multilingual User Interface Pack.zip where you can reach using UNC path Let’s get started! Custom WMI Class MUI languages … Read More