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 Platform%') ,LDISK.DeviceID0,LDISK.Size0/1024
   AS [Size (GB)],LDISK.FreeSpace0/1024 AS [Free Space (GB)] FROM v_R_System SYS LEFT JOIN
   v_GS_LOGICAL_DISK LDISK on SYS.ResourceID = LDISK.ResourceID LEFT JOIN
   v_GS_COMPUTER_SYSTEM CS on SYS.ResourceID = CS.ResourceID LEFT JOIN
    v_GS_X86_PC_MEMORY MEM on SYS.ResourceID = MEM.ResourceID LEFT JOIN
     v_GS_Processor CPU on SYS.ResourceID = CPU.ResourceID LEFT JOIN
      v_GS_SYSTEM_DEVICES DEV on SYS.ResourceID = DEV.ResourceID
       WHERE  LDISK.DeviceID0 = 'C:' AND CS.Model0 NOT LIKE '%VMWARE%'

ORDER BY SYS.Netbios_Name0

Nomad Branch Agent Fix and re install

echo sTOP sERVICE
Net Stop NomadBranch

Echo uNINSTALL If Nomad Found

Call MsiExec.exe /NoRestart /X{94ADB1B7-6490-4DCD-800D-5214A8516DC6} /QN
Call MsiExec.exe /NoRestart /X{1DBE047F-2734-4F18-BC8A-8721E1866BAC} /QN
Call MsiExec.exe /NoRestart /x{B9AC4CC0-2AAB-42C7-A876-1C552500CD82} /QN

Echo Install Nomad

Call Msiexec.exe /i NomadBranch.msi AUTHENTICATEDUSERS=1 INSTALLDIR="%programfiles%\1E\SMSNomad" STATUSMSGEVENTS="0x2,0x200000" NOMADINHIBITEDSUBNETS="" PIDKEY=COMPkey1-1234-1234-1234-1234 MULTICASTSUPPORT=0 CachePath="%systemdrive%\NomadBranch" Logpath="%systemdrive%\NomadBranch\LogFiles" /log "%systemRoot%\temp\1e.log" /QN

Echo Install Patch"Q11498.msp"

Call Msiexec /p Q11498.msp /qn REBOOT=ReallySuppress /l*v %systemRoot%\Temp\1EQ11498.Log
Call "%ProgramFiles%\1E\SMSNomad\NomadBranch.exe" -relicense=COMPkey1-1234-1234-1234-1234

Echo if service not in auto state set to auto

SC Config NomadBranch start= auto

Net Start NomadBranch

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 SizeinMB
FROM         dbo.v_UpdateContents INNER JOIN
                      dbo.v_FullCollectionMembership INNER JOIN
                      dbo.v_Collection ON dbo.v_FullCollectionMembership.CollectionID = dbo.v_Collection.CollectionID INNER JOIN
                      dbo.v_R_System AS SYS LEFT OUTER JOIN
                      dbo.v_Update_ComplianceStatusAll AS UCS ON SYS.ResourceID = UCS.ResourceID INNER JOIN
                      dbo.v_UpdateInfo AS UI ON UCS.CI_ID = UI.CI_ID ON dbo.v_FullCollectionMembership.ResourceID = UCS.ResourceID ON
                      dbo.v_UpdateContents.CI_ID = UI.CI_ID INNER JOIN
                      dbo.CI_Contents ON dbo.v_UpdateContents.Content_ID = dbo.CI_Contents.Content_ID
WHERE     (UCS.Status IN ('2')) AND (dbo.v_Collection.CollectionID = 'LAB000FB')
ORDER BY UI.ArticleID

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.Client
FROM SMS_R_System
WHERE (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.ResourceID
WHERE AdvertisementID = 'LAB20089' and LastStateName = "Failed"

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

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
                      dbo.v_Collection INNER JOIN
                      dbo.v_FullCollectionMembership AS fcm ON dbo.v_Collection.CollectionID = fcm.CollectionID
WHERE     (NOT (arp.DisplayName0 LIKE '%update%')) AND (NOT (arp.DisplayName0 LIKE 'para%')) AND (NOT (arp.DisplayName0 LIKE 'Configuration Manager Client')) AND
                      (NOT (arp.DisplayName0 LIKE 'µTorrent')) AND (NOT (arp.DisplayName0 LIKE '%Service Pack%')) AND (NOT (arp.DisplayName0 LIKE '%Segurança%')) AND
                      (NOT (arp.DisplayName0 LIKE '%Windows%')) AND (NOT (arp.DisplayName0 LIKE '%Audio Driver%')) AND
                      (NOT (arp.DisplayName0 LIKE '%C++ 2005 Redistributable%')) AND (NOT (arp.DisplayName0 LIKE '%Viewer%')) AND (NOT (arp.DisplayName0 LIKE '%Hotfix%')) AND
                      (NOT (arp.DisplayName0 LIKE '%.NET Framework%')) AND (NOT (arp.DisplayName0 LIKE '%google%')) AND (NOT (arp.DisplayName0 LIKE '%MSXML%')) AND
                      (NOT (arp.DisplayName0 LIKE '%Microsoft Baseline Security Analyzer%')) AND (NOT (arp.DisplayName0 LIKE '%Fax%')) AND (NOT (arp.DisplayName0 LIKE '%GDR%'))
                      AND (NOT (arp.DisplayName0 LIKE '%HP Array Configuration%')) AND (NOT (arp.DisplayName0 LIKE '%HP Scanjet%')) AND
                      (NOT (arp.DisplayName0 LIKE '%HP Smart%')) AND (NOT (arp.DisplayName0 LIKE '%hppFaxUtility%')) AND (NOT (arp.DisplayName0 LIKE '%hppFonts%')) AND
                      (NOT (arp.DisplayName0 LIKE '%HPPhotoSmartExpress%')) AND (NOT (arp.DisplayName0 LIKE 'HPP%')) AND (NOT (arp.DisplayName0 LIKE '%HPProductAssistant%'))
                      AND (NOT (arp.DisplayName0 LIKE '%WebFldrs XP%')) AND (NOT (arp.DisplayName0 LIKE '%Visual Studio Tools for the Office system 3.0 Runtime%')) AND
                      (NOT (arp.DisplayName0 LIKE 'VBA%')) AND (NOT (arp.DisplayName0 LIKE '%uTorrentBar%%')) AND (NOT (arp.DisplayName0 LIKE '%Ultimate Extras%')) AND
                      (NOT (arp.DisplayName0 LIKE '%Runtime Environment%')) AND (NOT (arp.DisplayName0 LIKE '%Toolbox%')) AND (NOT (arp.DisplayName0 LIKE '%IBM Themes%'))
                      AND (NOT (arp.DisplayName0 LIKE '%hp LaserJet%')) AND (NOT (arp.DisplayName0 LIKE '%GDR%')) AND (NOT (arp.DisplayName0 LIKE '%Fax%')) AND
                      (NOT (arp.DisplayName0 LIKE '%Adobe Shockwave Playe%')) AND (NOT (arp.DisplayName0 LIKE '%Adobe Reader%')) AND
                      (NOT (arp.DisplayName0 LIKE '%Adobe Download Manager%')) AND (NOT (arp.DisplayName0 LIKE '%Actualización%')) AND
                      (NOT (arp.DisplayName0 LIKE '%Active Directory Migration Tool%')) AND (NOT (arp.DisplayName0 LIKE '%Adobe Flash Player%')) AND
                      (NOT (arp.DisplayName0 LIKE '%Audio%')) AND (NOT (arp.DisplayName0 LIKE '%XML%')) AND (NOT (arp.DisplayName0 LIKE '%Web Part%')) AND
                      (NOT (arp.DisplayName0 LIKE '%WIMGAPI%')) AND (NOT (arp.DisplayName0 LIKE '%Microsoft Silverlight%')) AND (NOT (arp.DisplayName0 LIKE '%SoundMAX%')) AND
                      (NOT (arp.DisplayName0 LIKE '%Spelling%')) AND (NOT (arp.DisplayName0 LIKE '%RDC%')) AND (NOT (arp.DisplayName0 LIKE '%Wallpapers%')) AND
                      (NOT (arp.DisplayName0 LIKE '%WebEx%')) AND (NOT (arp.DisplayName0 LIKE '%Microsoft Office Proof%')) AND (NOT (arp.DisplayName0 LIKE '%MSN Toolbar%'))
                      AND (NOT (arp.DisplayName0 LIKE '%MSN Toolbar%')) AND (NOT (arp.DisplayName0 LIKE '%google%')) AND (NOT (arp.DisplayName0 LIKE '%SQL Server Native%'))
                      AND (NOT (arp.DisplayName0 LIKE '%VSS Writer%')) AND (NOT (arp.DisplayName0 LIKE '%XP Themes%')) AND (NOT (arp.Publisher0 LIKE '%Lenovo%')) AND
                      (NOT (arp.Publisher0 LIKE '%UPEK Inc%')) AND (NOT (arp.Publisher0 LIKE '%AutoIt%')) AND (NOT (arp.Publisher0 LIKE '%Broadcom%')) AND
                      (NOT (arp.Publisher0 LIKE '%S3 Graphics%')) AND (NOT (arp.Publisher0 LIKE '%Realtek%')) AND (NOT (arp.Publisher0 LIKE '%Seagate%')) AND
                      (NOT (arp.Publisher0 LIKE '%S3 Graphics%')) AND (NOT (arp.Publisher0 LIKE '%Active Directory Export%')) AND (NOT (arp.Publisher0 LIKE '%TOSHIBA%')) AND
                      (NOT (arp.Publisher0 LIKE '%Logitech%')) AND (NOT (arp.Publisher0 LIKE '%SCCM%')) AND (NOT (arp.Publisher0 LIKE '%Yahoo%')) AND
                      (NOT (arp.Publisher0 LIKE '%Canon%')) AND (NOT (arp.Publisher0 LIKE '%ZTE%')) AND (NOT (arp.Publisher0 LIKE '%Dell%')) AND
                      (NOT (arp.Publisher0 LIKE '%McAfee%')) AND (NOT (arp.Publisher0 LIKE '%Dell%')) AND (NOT (arp.Publisher0 LIKE '%1E%')) AND
                      (NOT (arp.Publisher0 LIKE '%Mozilla%')) AND (NOT (arp.Publisher0 LIKE '%TOSHIBA%')) AND (NOT (arp.Publisher0 LIKE '%Broadcom%')) AND
                      (NOT (arp.Publisher0 LIKE '%DivX%')) AND (NOT (arp.Publisher0 LIKE '%InterVideo%')) AND (NOT (arp.Publisher0 LIKE '%UPEK%')) AND
                      (NOT (arp.Publisher0 LIKE '%Intel%')) AND (NOT (arp.Publisher0 LIKE '%Realtek%')) AND (NOT (arp.Publisher0 LIKE '%REALTEK%')) AND
                      (NOT (arp.Publisher0 LIKE '%Conexant%')) AND (fcm.CollectionID = 'SMS00001')

Nomad Service issue

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

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 best practice based framework for IT management, but also an approach and philosophy shared by the people who work with it in practice. ITIL has now been updated twice, the first time in 2000-2002 (V2), and the second time in 2007 (V3). 

The ITIL Qualification Scheme uses a system that enables an individual to gain credits for each exam they take. Once candidates have accumulated a sufficient number of credits they can be awarded the ITIL Expert in IT Service Management. There are four levels within the scheme:

§  Foundation Level 

§  Intermediate Level (Lifecycle Stream and Capability Stream) 

§  ITIL Expert 

§  ITIL Master