sccm 2012

ConfigMgr : Query to find SCCM client versions (ConfigMgr 2012)

/ sanmansp / Leave a comment

download : SQLQuery-find-agentsversions select sys.Client_Version0, "CM Name"= case sys.Client_Version0 when '4.00.6487.2000' then 'CM07 SP2 (4.00.6487.2000)' when '4.00.6487.2188' then 'CM07 R3 (4.00.6487.2188)' when '4.00.6487.2187' then 'CM07 R3 (4.00.6487.2187)' when '4.00.6487.2157' then 'CM07 R3 (4.00.6487.2157)' when '5.00.0000.0000' then 'CM12 RTM (5.00.0000.0000)' when '5.00.7804.1000' then 'CM12 SP1 (5.00.7804.1000)' when '5.00.7804.1202' then 'CM12 SP1 CU1 (5.00.7804.1202)' when '5.00.7804.1300' then 'CM12 … Continue reading ConfigMgr : Query to find SCCM client versions (ConfigMgr 2012)

Advertisements

ConfigMgr : OSD : How To Create a Bootable USB Windows 7 Build Disk

/ sanmansp / Leave a comment

Prerequisites The following are required to build the Windows 7 USB Media: Windows 7 Machine USB Removable Drive   Step by Step: How to prepare the USB The USB device must be prepared prior to generate the stand alone media. On a Windows 7 PC, Insert the USB device and launch the command line in … Continue reading ConfigMgr : OSD : How To Create a Bootable USB Windows 7 Build Disk

ConfigMgr : SQL Query to find Application and version by location

/ sanmansp / Leave a comment

Download :  SQLQuery-Findmachines-withoutlook-locationspecific SELECT distinct b.Netbios_Name0, b.User_Name0, b.ad_site_name0, a.FileName, a.FileVersion, a.FilePath FROM v_GS_SoftwareFile a JOIN v_R_System b ON a.ResourceID = b.ResourceID JOIN v_RA_System_SystemOUName c ON a.ResourceID = c.ResourceID WHERE FileName = 'outlook.exe' and AD_Site_Name0 like '%perth%' ORDER BY b.Netbios_Name0

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

SCCM SQL Query : SQL Query for Locations and Boundaries

/ sanmansp / 2 Comments

Download SQL Query   The Query : select sys1.Name, sys1.DefaultSiteCode, (select SUBSTRING(sys2.ServerNALPath, CHARINDEX('\\', sys2.ServerNALPath) + 2, CHARINDEX('"]', sys2.ServerNALPath) - CHARINDEX('\\', sys2.ServerNALPath) - 3 ) + CASE sys2.Flags WHEN '1' Then ' (Slow)' WHEN '0' THEN '' END + '; ' as 'data()' from vSMS_BoundaryGroupSiteSystems as sys2 where sys1.GroupID=sys2.GroupID for XML path('')) as 'Site System', (select … Continue reading SCCM SQL Query : SQL Query for Locations and Boundaries

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'