sms

In telemetry we trust?

/ sanmansp / Leave a comment

More than patches

Telemetry is one of those things that tends to divide a room. On one hand it’s productive and accurate feedback for your product of choice and on the other hand it’s big brother spying on what you’re doing in that product. I wanted to share a recent experience with you based on my recent upgrade of Microsoft System Center Configuration Manager (SCCM) to the recent 1710 release as it may make you change your mind.

The long awaited 1710 release was made available last week a little before midnight in the UK on 20/11/17 (or 11/20 in the US Smile). The next morning I fired up my lab which runs the current branch version of SCCM, ran the early update ring PowerShell script and proceeded to whizz through the wizard in a speedy not hastily fashion. This was lab after all so on with the day job and I’ll check…

View original post 689 more words

ConfigMgr : OSD : Build failure Troubleshooting and Logs gathering

/ sanmansp / Leave a comment

During the Build process if you encounter any issues you can perform further investigation with the below mandatory information Machine model Error code with snapshot Error stage with snapshot (may be hiding behind the Task Sequence error window) Single system failure OR multiple systems failures Build Failure Logs (as described below) Mention if any HW component … Continue reading ConfigMgr : OSD : Build failure Troubleshooting and Logs gathering

ConfigMgr : Discovery Methods in System Center Configuration Manager 1706 CB

/ nitturemahadev / Leave a comment

In Today’s tutorial, we learn about the discovery methods in System center configuration manager. We have below discovery methods in System Center Configuration Manager. - Active Directory Forest Discovery - Active Directory Group Discovery - Active Directory System Discovery - Active Directory User Discovery - Heartbeat Discovery - Network Discovery Active Directory Forest Discovery By … Continue reading ConfigMgr : Discovery Methods in System Center Configuration Manager 1706 CB

ConfigMgr Guide : Holistic Standardization and Fine Tuning

/ sanmansp / 3 Comments

This is one guide that will take your SCCM skills and environment to a whole new level ! This would give you good insight into your infra and also let you understand how the enterprise class Microsoft Suite is behaving under the hood. The guide has also been implemented in several real world production environments … Continue reading ConfigMgr Guide : Holistic Standardization and Fine Tuning

SCCM Troubleshooting : Ironing out Patching for ConfigMgr 2007 (upto 95% compliance)

/ sanmansp / Leave a comment

This guide will take you through troubleshooting guides, tips, tricks and tools to achieve 95%+ compliance in your environment and maximum coverage. The guide assumes the following environmental conditions:   Microsoft System Center Configuration Manager 2007 R3 WSUS 3.0 SP2 used as base for Software Updates Windows Client endpoints Three tier SCCM hierarchy   - … Continue reading SCCM Troubleshooting : Ironing out Patching for ConfigMgr 2007 (upto 95% compliance)

SCCM SQL Query : Find SCCM Client Health

/ sanmansp / Leave a comment

select sys.Name0 as 'Computer Name',sys.User_Name0 as 'User Name',summ.ClientStateDescription,case when summ.ClientActiveStatus = 0 then 'Inactive'when summ.ClientActiveStatus = 1 then 'Active'end as 'ClientActiveStatus',summ.LastActiveTime,case when summ.IsActiveDDR = 0 then 'Inactive'when summ.IsActiveDDR = 1 then 'Active'end as 'IsActiveDDR',case when summ.IsActiveHW = 0 then 'Inactive'when summ.IsActiveHW = 1 then 'Active'end as 'IsActiveHW',case when summ.IsActiveSW = 0 then 'Inactive'when summ.IsActiveSW = … Continue reading SCCM SQL Query : Find SCCM Client Health

SCCM SQL Query : Find Lync Versions

/ sanmansp / Leave a comment

select  distinct v_R_System.User_Name0,v_r_system.Name0,v_R_System.Active0,v_Add_Remove_Programs.DisplayName0,v_Add_Remove_Programs.TimeStamp,v_Add_Remove_Programs.InstallDate0,v_Add_Remove_Programs.Version0from v_Add_Remove_Programsinner join v_R_System on v_Add_Remove_Programs.ResourceID = v_R_System.ResourceIDwhere v_Add_Remove_Programs.DisplayName0 like 'Microsoft Lync 2010'

SCCM SQL Query : Computers with Pending Restart or other Update Enforcement States

/ sanmansp / Leave a comment

SELECT SMS_R_SYSTEM.ResourceID, SMS_R_SYSTEM.ResourceType, SMS_R_SYSTEM.Name, SMS_R_SYSTEM.SMSUniqueIdentifier, SMS_R_SYSTEM.ResourceDomainORWorkgroup, SMS_R_SYSTEM.Client FROM sms_r_system inner join SMS_UpdateComplianceStatus ON SMS_UpdateComplianceStatus.machineid=sms_r_system.resourceid WHERE SMS_UpdateComplianceStatus.LastEnforcementMessageID = 9There are several other enforcement states you can use instead by changing the number after ‘LastEnforcementMessage ID =’ at the end of the query.1 – Enforcement started3 – Waiting for another installation to complete6 – General failure8 – … Continue reading SCCM SQL Query : Computers with Pending Restart or other Update Enforcement States