Issue with SCCM Reporting Services Point Role Configuration
Question
admin 
Hi All,
I have a scenario. Server1 : SCCM primary site and SQL site database. Introducing Server2 for service reporting point role.
Integrating the SQL Server Machine into Intune
Question
admin
Hi All,
As we transition all devices to Intune, I have a 2x on prem servers 1x AD Server 2022 and 1x member Server 2019.
Obviously with Intune, we no longer need a local AD sever, and happy to switch off when ...
SQL Cluster Issues
Question
admin
Hi All,
Has anyone had any luck moving their ConfigMgr database to an SQL Cluster?
Every time I try, the setup hangs and then fails, saying it cannot create the remote SSL Certificate.
The Site Server computer account and the account ...
Move the SCCM console -primary site- to anocher new
Question
admin
Hi All,
Hi Colleagues :: i need move the SCCM console -primary site- to anocher new from scratch Windows server 2019 new server by the way - it is important to mention that the SQL instance for SCCM is in another ...
SQL Query
Question
Sanjay Mahajan 
Hi All,
Hi All,
I'm trying to create a report that will give me the "Status", and "Error Description", I get from the Device Summary section in the "Assets Message" window under the "Details" tab for each system. I'm looking to get ...
Custom Report of Applications pushed to a specific collection
Question
Leandro Vasconcelos Ferreira 
Hi guys!
I am new in SCCM and I am trying to generate a custom report that will return the status (Success, Error and etc) of all the applications pushed to a specific device collection. I did followed this article ...
SCCM Sql Server Migration from 2021 to 2019
Question
BobbyM 
Hi We currently have SCCM 2012 r2 with SQL 2012.
We plan on upgrading the environment to new servers as we need to decommission the old physical servers. I have setup a new VM 2019 with SQL 2019, whats the best ...
SQL Query for collection creation date, deployment name and enforcement state of endpoints
Question
Deepak Rai 
Hello HTMDians,
Help needed from all SQL Guru's in our forum.
I have been trying to write one SQL Query where i need to fetch the compliance of the collection along with the enforcement state of each servers inside the collection and ...
I need to create a sql query to find out bios details of a single machine, help me as i do not have any sql experience.
Question
santosh krishh 
i came across a script online now i want to know if i edit the machine name with the one i have will give me result of that particular machine or will it bring result of machine in my environment
Select
CMG DNS CNAME question
Question
isotonic_uk 
Hi I am currently doing a CMG deployment on 2010 release of MECM.
The pre-reqs have been completed to the best of my knowledge and the deployment of Azure services/MECM integration and CMG has gone well. Client settings have been updated ...