Archives August 2019

Windows Update error code 0x80092004 on Windows 7 or Server 2008 R2

In case that you are receiving the error code (0x80092004) when installing the August 2019 released patches you need to know that this is a consequence of SHA 2 implementation for patch signing.

The following 2 patches should be installed on the machine in order to complete the installation.

  • KB4474419 — SHA-2 code signing support update for Windows Server 2008 R2, Windows 7, and Windows Server 2008: August 13, 2019.
  • KB4490628 — Servicing stack update for Windows 7 SP1 and Windows Server 2008 R2 SP1: March 12, 2019, not listed as a dependency.

Search for column in SCCM Database views

Sometimes is hard to find the proper table or column in the available views.

The easiest way would be to use simple database query to search in the information schema. For Microsoft reference please check the url below. https://docs.microsoft.com/en-us/sql/relational-databases/system-information-schema-views/system-information-schema-views-transact-sql?view=sql-server-2017

SELECT DISTINCT table_name,column_name FROM INFORMATION_SCHEMA.COLUMNS WHERE TABLE_NAME LIKE ('v_%') AND COLUMN_NAME LIKE '%sourcepath%'
SELECT DISTINCT table_name,column_name FROM INFORMATION_SCHEMA.COLUMNS WHERE TABLE_NAME LIKE ('v_%') ORDER BY column_name