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