Virtual LAB Microsoft Page
All Virtual LABs https://technet.microsoft.com/en-us/virtuallabs/bb539977
SCCM
Virtual LABS : System Center 2012 Configuration Manager
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 to night SCOM LAB for FUN
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
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
is computer is 32 bit or 64 bit ?
–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
Nomad Branch Agent Fix and re install
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
All WQL to info from SQL select * from dbo.v_CollectionRuleQuery
SQL Query for Pathes required systems with the Size
–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
All Systems that have been discovered last night:
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)
Collection – ADVERTISEMENT FAILED systems
SELECT sys.ResourceID,sys.ResourceType,sys.Name,sys.SMSUniqueIdentifier,sys.ResourceDomainORWorkgroup,sys.Client FROM sms_r_system as sys inner join SMS_ClientAdvertisementStatus as offer on sys.ResourceID=offer.ResourceIDWHERE AdvertisementID = ‘LAB20089’ and LastStateName = “Failed”
