is computer is 32 bit or 64 bit ?

by

–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

by

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

SQL Query for Pathes required systems with the Size

by

–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

Collection – ADVERTISEMENT FAILED systems

by

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”

All S/w from Add& Remove Programs After some exceptional removing

by

All S/w from Add& remove Programs SELECT DISTINCT arp.DisplayName0 AS [Product Name], arp.Publisher0, arp.Version0, dbo.v_R_System.Netbios_Name0, fcm.CollectionID FROM         dbo.v_GS_ADD_REMOVE_PROGRAMS AS arp INNER JOIN                       dbo.v_R_System ON arp.ResourceID = dbo.v_R_System.ResourceID CROSS JOIN                       … Read more

All S/w from Add& Remove Programs After some exceptional removing

by

All S/w from Add& remove Programs SELECT DISTINCT arp.DisplayName0 AS [Product Name], arp.Publisher0, arp.Version0, dbo.v_R_System.Netbios_Name0, fcm.CollectionIDFROM         dbo.v_GS_ADD_REMOVE_PROGRAMS AS arp INNER JOIN                      dbo.v_R_System ON arp.ResourceID = dbo.v_R_System.ResourceID CROSS JOIN                      dbo.v_Collection INNER JOIN  … Read more

Nomad Service issue

by

If Nomad service is getting stopped automatically as Licensing issue.. then we can re license as below command from the NomadBranch.exe path… NomadBranch.exe -relicense=Productkey-Abcad-123456-1231231-12312312

ITIL Exams

by

ITIL Exams: The Information Technology Infrastructure Library™ (ITIL) offers a systematic approach to the delivery of quality IT services. ITIL was developed in the 1980s and 1990s by CCTA (Central Computer and Telecommunications Agency, now the Office of Government Commerce, OGC), under contract to the UK Government. Since then, ITIL has provided not only a … Read more