Sasidhar Konduru - SCCM Expert

http://download.windowsupdate.com/microsoftupdate/v6/wsusscan/wsusscn2.cab https://go.microsoft.com/fwlink/?LinkID=74689 if you are using Tanium https://content.tanium.com/files/hosted_dats/MS-CVEs.dat https://content.tanium.com/files/windows-patch/wsusscn2.json 

 How do you transition All SCCM capabilities to some other tool? Will provide my answers soon HI

SELECT  dbo.v_GS_OPERATING_SYSTEM.Caption0, dbo.v_GS_VIRTUAL_MACHINE_64.PhysicalHostName0, dbo.v_R_System.Name0 FROM    dbo.v_R_System INNER JOIN            dbo.v_GS_OPERATING_SYSTEM ON dbo.v_R_System.ResourceID = dbo.v_GS_OPERATING_SYSTEM.ResourceID INNER JOIN            dbo.v_GS_VIRTUAL_MACHINE_64 ON dbo.v_GS_OPERATING_SYSTEM.ResourceID = dbo.v_GS_VIRTUAL_MACHINE_64.ResourceID   where v_r_system.name0 in (

--DP content status: use sms SELECT     v_PackageStatusDistPointsSumm.PackageID,                       v_Package.Name, v_PackageStatusDistPointsSumm.InstallStatus, v_PackageStatusDistPointsSumm.SiteCode, v_PackageStatusDistPointsSumm.ServerNALPath,                       v_PackageStatusDistPointsSumm.SourceVersion, v_PackageStatusDistPointsSumm.State, v_PackageStatusDistPointsSumm.LastCopied,                       v_PackageStatusDistPointsSumm.SourceNALPath, v_PackageStatusDistPointsSumm.SummaryDate FROM         v_PackageStatusDistPointsSumm INNER JOIN                       v_Package ON v_PackageStatusDistPointsSumm.PackageID = v_Package.PackageID WHERE     (v_PackageStatusDistPointsSumm.ServerNALPath LIKE '%XXX%')---and InstallStatus <> 'Package Installation complete' --WHERE     (v_PackageStatusDistPointsSumm.ServerNALPath LIKE '%.stores.target.com%')and InstallStatus <> 'Package Installation complete' --and Name like '%neil%&

Below is a PowerShell script, this will list WDS Service status against of List of servers. $InPutComputersList = get-content "c:\MyScripts\list.txt" $OutPutFile = "c:\MyScripts\WDS_ServiceStatus.csv" $NotReachble = "c:\MyScripts\NonPingSystems.csv" $listResult = @() foreach($ForEverComputerIntheTextFilelinebyLine in $InPutComputersList) { if (test-path \$ForEverComputerIntheTextFilelinebyLine\c$\windows\write.exe) { $objService = Get-Service WDSServer -ComputerName $ForEverComputerIntheTextFilelinebyLine | select machinename, status, name, displayname $objResult = New-Object PSObject -Property @{ ComputerName = $ForEverComputerIntheTextFilelinebyLine ServiceStatus = $objService.Status ServiceDisplayName = $objService.DisplayName ServiceName = $objService.Name } $listResult += $objResult } Else { Write-Output "$ForEverComputerIntheTextFilelinebyLine,NotReachable" | out-file $NotReachble -append } } $listResult| Export-Csv -Path $OutPutFile

Select v_Add_Remove_Programs.DisplayName0, v_Add_Remove_Programs.Publisher0, v_Add_Remove_Programs.Version0 FROM v_Add_Remove_Programs JOIN  v_R_System ON v_Add_Remove_Programs.ResourceID = v_R_System.ResourceID WHERE v_R_System.Netbios_Name0 = @computername