Purpose : Active Directory Sites and System Center Configuration Manager Boundaries are hard to keep in sync – especially in an environment where there are regular changes and several team managing each technology separately. This Power BI dashboard solution will help analyze and reduce down the gaps in SCCM. The dashboard will help SCCM administrators […]

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 […]

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 […]

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

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 […]