Tag Archives: SCCM Reports

How to find custom hardware inventory classes imported (MOF) into ConfigMgr database

By | July 23, 2019

Configuration Manager site database contains a large collection of information about the network, computers, users, user groups, and many other components of the computing environment. Being SCCM Admin, you need to understand the different categories of the SQL views, what information is stored in each view, and how the SQL views can be joined to… Read More »

SCCM Configmgr collection SQL identify duplicate computer records with different GUID

By | May 31, 2019

I was working on SCCM report for client health dashboard. During this report creation ,found that ,device appear twice with different GUID ID and resource ID but with same hostname. So i started looking at this issue to see how identify the records with duplicate hostnames. SCCM clients are uniquely identified by a GUID. A… Read More »

SCCM Report Get list of devices with pending reboot in a collection with different states

By | April 13, 2019

Beginning with the release of SCCM ConfigMgr Build 1710 or later , you can use the SCCM Console to identify client devices that require a restart, and then use a client notification action to restart them. If you want get this feature enabled on the client side ,you must also upgrade clients to version 1710… Read More »

SCCM ConfigMgr Compliance status of client for multiple software update groups

By | April 10, 2019

After long-time ,i am back with quick SCCM Configmgr software update compliance report .A friend of mine asked me today morning that ,he wants to check the compliance report for specific computer (could be VIP ) against one or multiple software update groups that they have created/deployed. How do you check the compliance status of… Read More »

How to install Data warehouse service point in SCCM Configmgr and get the historical data

By | March 28, 2019

  Introduction: Customer is running on SCCM Configmgr current branch 1806 and configured with site maintenance tasks to delete the aged data for X number days . when you configure the site maintenance task ,the data which is older than X number days get deleted from site database which is expected. So customer has asked… Read More »

Configmgr SSRS Didn’t Add RDL with Error Code :definition Of This Report Is Simply Not Legitimate Or Supported By This Model Of Reporting Services

By | June 16, 2018

when you attempt to add RDL (report definition file) into reporting service,you will hit with the next error The definition of this report just isn’t legitimate or supported by this model of Reporting Companies. The report definition could have been created with a later model of Reporting Companies, or include content material that isn’t well-formed… Read More »

SCCM Configmgr CB 1802 SQL Views Documentation

By | March 23, 2018

With the discharge of SCCM Configmgr present department 1802 ,there are some thrilling options added from its earlier model 1710. When there are new options launched ,definitely there shall be adjustments to the database therefore sql views/tables created which can assist us to create some good SSRS studies for reporting. So with this present department… Read More »

SQL Question to Get Shopper Rely with Standing Energetic Out Of Date Lacking For Collections in Tabular Column

By | March 19, 2018

Quick weblog publish on find out how to get consumer depend with lively out of date and lacking standing for collections in a pleasant tabular column. I used three SQL views on this question V_r_system ,v_FullCollectionMembership and v_Collection with sum and case statements. You can use this SQL code in report creation with assortment immediate… Read More »

Using SCCM Methods to Test If the Person Mailbox Is Migrated to Trade On-line (cloud) From On-prem Exchange

By | March 16, 2018

Introduction: we are in means of migrating customers (mailbox) from on-prem to workplace 365 (Cloud).As a half of this venture ,one of many requirement is to deploy workplace 365 proplus (C2R) utility to all customers changing outdated model of Microsoft Workplace. We use Powershell Utility deployment kit which simplifies the complicated scripting challenges of deploying… Read More »

SCCM Configmgr Technical Preview 1802 Available

By | February 14, 2018

On this Valentine day (Feb 14,2018 ), Microsoft launched Feb 2018 Technical preview model 1802 for Configuration Supervisor with giant variety of options (21) that ever launched earlier than. These month-to-month Tech previews usually might be launched on Friday’s however this time ,shipped few days earlier. You can set up this model to replace and… Read More »