Category Archives: SCCM Reports

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 »

SCCM Report For Lacking Boundaries And Troubleshooting

By | January 17, 2018

Introduction: Boundaries for SCCM outline community places in your intranet that may include gadgets that you just wish to handle. Boundary teams are logical teams of boundaries that you just configure. For extra data click on right here Few days in the past ,Jason Sandys has blogged about boundary group caching and lacking boundaries ,extra… Read More »

Configmgr Report Checklist Empty Collections with No Question Guidelines Outlined (collection Clean-up)

By | January 13, 2018

I was trying on the console different day and located that, there have been many collections created within the root folder (device collection) with 0 rely. So i regarded on the assortment properties ,i discovered empty there (No direct or question primarily based rule). So i made a decision to put in writing SQL question… Read More »