Inner Join tblQuickFi圎ngineeringUni On tblQuickFi圎ngineeringUni.QFEID Left Join (Select Top 1000000 tblQuickFi圎ngineering.AssetID Left Join tsysOS On tsysOS.OScode = tblAssets.OScode Inner Join tblComputersystem On tblAssets.AssetID = tblComputersystem.AssetID Inner Join tblState On tblState.State = tblAssetCustom.State Inner Join tblOperatingsystem On tblOperatingsystem.AssetID = Inner Join tsysAssetTypes On tsysAssetTypes.AssetType = tblAssets.Assettype Inner Join tblAssetCustom On tblAssets.AssetID = tblAssetCustom.AssetID 'Windows update information may not be up to date. When Convert(nvarchar,DateDiff(day, QuickFixLastScanned.QuickFixLastScanned,
GetDate())) + ' days ago' As WindowsUpdateInfoLastScanned, When tsysOS.OScode Like '3' Then 'KB4532693'Ĭonvert(nvarchar,DateDiff(day, QuickFixLastScanned.QuickFixLastScanned, When tsysOS.OScode Like '2' Then 'KB4532693' When tsysOS.OScode Like '4' Then 'KB4537762' When tsysOS.OScode Like '9' Then 'KB4537789' When tsysOS.OScode Like '3' Then 'EOL, update to a higher Windows version' When tsysOS.OScode Like '6' Then 'EOL, update to a higher Windows version' When tsysOS.OScode Like '0' Then 'KB4537776' When tsysOS.OSname = 'Win 7' Or tsysOS.OSname = 'Win 7 RC' Or When tblAssets.AssetID = SubQuery1.AssetID Then '' 'Scanning Error: ' + tsysasseterrortypes.ErrorMsg When tblComputersystem.Domainrole > 1 Then 'Server' Patch Tuesday Audit Query Select Distinct Top 1000000 Coalesce(tsysOS.Image, You can find all the details in our Patch Tuesday February blog post. This Patch Tuesday is the first time Microsoft will not release a Windows 7 update as it has reached end-of-life. This patch Tuesday also includes a fix for an Internet Explorer zero-day vulnerability (CVE-2020-0674) that is being actively exploited, so it is important to patch as soon as possible. Run our Patch Tuesday February audit to keep your devices safe.įebruary's Patch Tuesday includes fixes for a whopping 99 vulnerabilities, 10 are rated as critical and should be patched as soon as possible. Detect outdated machines, start updating or simply manage your updating process in your network. This gives you a quick and easy overview of your patch status and allows you to find devices that might be having issues receiving Microsoft updates. The audit for the Microsoft Patch Tuesday of February 2020 provides a color-coded overview of all Windows computers and their Windows patch status. Discover All Windows Computers and Their Patch Tuesday February 2020 Status
0 kommentar(er)
