Site Name Site 1 Comments Discovery What are The OU’s Targeted? In AD Are they missing any in OU’s IN AD ?? From AD In above Ou’s Howmany Computers are there? (From AD) may be a difference in SCCM vs AD in SCCM Now List howmany in SCCM may be a difference in SCCM vs … Read more
All Virtual LABs https://technet.microsoft.com/en-us/virtuallabs/bb539977
System Center 2012 Configuration Manager TechNet Virtual Lab: System Center 2012: System Center 2012 Orchestrator: Policy to Runbook Migration Tips TechNet Radio: Virtual Lab Insider – An Introduction to System Center 2012 Configuration Manager Video! TechNet Virtual Lab: Introduction to System Center 2012 Configuration Manager TechNet Virtual Lab: System Center 2012 Configuration Manager: Role Based … Read more
Lets try small LAB to night Install OPSMGR Monitor AD & DNS Monitor some APP Monitor Some Workstation Create some reports Create Management Pack Alter Management Pack Create Monitoring Rule Grant the ROLE based Access Create a Rult to Monitor Windows any Service Visio Integration Windows Performance Based Rule creation and Report Using Health Explorer … Read more
To download the YouTube Play list all videos at a time… The link to the page where you can download “Free youtube Download”.https://www.dvdvideosoft.com/products/dvd/Free-YouTube-Download.htm is really superb .. Enjoy
–Finding computer is 32 bit or 64 bit is easy from SCCM… here is SQL query………… SELECT Distinct SYS.Netbios_Name0, CS.Model0,CPU.Name0 AS [CPU Name], CASE WHEN CPU.Is64Bit0 = 1 THEN ‘Yes’ ELSE ‘No’ END AS [CPU 64-Bit],ROUND(CONVERT(FLOAT,CPU.MaxClockSpeed0), -2)/1000 AS [CPU (GHz)],ROUND(ROUND(CONVERT(FLOAT,MEM.TotalPhysicalMemory0) / 1048576, 2) , 1)AS [RAM (GB)],[TPM Chip]=(SELECT v_GS_SYSTEM_DEVICES.Name0 FROM v_GS_SYSTEM_DEVICES WHERE v_GS_SYSTEM_DEVICES.ResourceID=SYS.ResourceID AND v_GS_SYSTEM_DEVICES.Name0 LIKE ‘%Trusted … Read more
echo sTOP sERVICENet Stop NomadBranch Echo uNINSTALL If Nomad Found Call MsiExec.exe /NoRestart /X{94ADB1B7-6490-4DCD-800D-5214A8516DC6} /QNCall MsiExec.exe /NoRestart /X{1DBE047F-2734-4F18-BC8A-8721E1866BAC} /QNCall MsiExec.exe /NoRestart /x{B9AC4CC0-2AAB-42C7-A876-1C552500CD82} /QN Echo Install Nomad Call Msiexec.exe /i NomadBranch.msi AUTHENTICATEDUSERS=1 INSTALLDIR=”%programfiles%1ESMSNomad” STATUSMSGEVENTS=”0x2,0x200000″ NOMADINHIBITEDSUBNETS=”” PIDKEY=COMPkey1-1234-1234-1234-1234 MULTICASTSUPPORT=0 CachePath=”%systemdrive%NomadBranch” Logpath=”%systemdrive%NomadBranchLogFiles” /log “%systemRoot%temp1e.log” /QN Echo Install Patch”Q11498.msp” Call Msiexec /p Q11498.msp /qn REBOOT=ReallySuppress /l*v %systemRoot%Temp1EQ11498.LogCall “%ProgramFiles%1ESMSNomadNomadBranch.exe” -relicense=COMPkey1-1234-1234-1234-1234 Echo … Read more
All WQL to info from SQL select * from dbo.v_CollectionRuleQuery
–SQL Query for Pathes required systems with the Size SELECT DISTINCT TOP (100) PERCENT SYS.Name0 AS [Machine Name], UCS.Status AS [Patch Status Code], UI.BulletinID, UI.ArticleID, UI.Title, dbo.v_FullCollectionMembership.ResourceID, dbo.v_Collection.CollectionID, UI.CI_ID, dbo.CI_Contents.SourceSize /(1024.0*1024) AS SizeinMBFROM … Read more
SELECT SMS_R_System.ResourceID,SMS_R_System.ResourceType,SMS_R_System.Name, SMS_R_System.SMSUniqueIdentifier, SMS_R_System.ResourceDomainORWorkgroup,SMS_R_System.ClientFROM SMS_R_SystemWHERE (DateDiff(day, CreationDate, GetDate()) < 1)
