SCCM Report Builder Error – The Certificate Chain was issued by an Authority that is not Trusted

Benoit LecoursSCCM, SSRS13 Comments

If you’re like us and love to create and build awesome reports, you may get an error when running report builder on a remote computer. When editing an SCCM report in Report Builder you may receive the following error: A connection was successfully established with the server, but then an error occurred during the login process. (provider: SSL Provider, error: 0 – The certificate chain was issued by an authority that is not trusted.) SCCM Report Builder error – Cause This error occurs because you don’t have the required SCCM SQL certificate on the computer running Report Builder. Follow the following steps in order to resolve the issue. Export the certificate from your SQL server On the SQL Server Click the Start menu, click Run, and then type mmc. Click Enter. This starts the Microsoft Management Console (MMC) In the console, click the File menu and then click Add/Remove Snap-in On the … Read More

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

Use IMEI Numbers with SCCM and Intune to identify Corporate Devices

Nicolas PilonIntune, SCCM1 Comment

Last January, Microsoft released an update for Intune standalone environment in which you can import international mobile equipment identity (IMEI) numbers for mobile device platforms that have an IMEI number to help identify corporate-owned mobile devices. Once enrolled in Intune, devices with imported IMEI numbers are tagged as Corporate, which can be used for applying policies that are different than those applied to Personal devices. What happens if you use an Intune hybrid environment? SCCM has no built in tool to add a list of IMEI numbers and switch device owners from Personal to Company when devices are enrolled. In this post, we will configure SCCM to identify devices based on a list of IMEI numbers and change their ownership from Personal to Company. Before starting, you can read the difference between both ownership attributes. Preparing the Collection The first step is to extract all IMEI numbers of your corporate-owned devices. The idea is to create a list of … Read More

Create Custom Reports with Labels of Asset Intelligence

Nicolas PilonAsset Intelligence, SCCM, SSRS8 Comments

Usually, we use information from Add Remove Programs when it’s time to make software reports. For technical reasons, it’s not always easy to have adequate results. The use of custom labels in Asset Intelligence helps standardize and gather software information. In this post, we will explain how to use the data from custom labels in asset intelligence to create custom reports. Before starting the reports, make sure the custom labels are set in your environment from how to maximize the use of custom views in Asset Intelligence. Configuration Manager 2012 came with a couple of Asset Intelligence reports but nothing special based on the custom labels. The only useful report is Software 12A | Software titles with a specific custom label defined. After this post, you will be able to do a report like the one below. Views First, here’s the list of SQL views used by SCCM for custom … Read More