SG-SCCM Computer Identity Data source Fails with SQL error: S0001 | Invalid column name 'TimeKey'Issue <!-- /*NS Branding Styles*/ --> .ns-kb-css-body-editor-container { p { font-size: 12pt; font-family: Lato; color: var(--now-color--text-primary, #000000); } span { font-size: 12pt; font-family: Lato; color: var(--now-color--text-primary, #000000); } h2 { font-size: 24pt; font-family: Lato; color: var(--now-color--text-primary, black); } h3 { font-size: 18pt; font-family: Lato; color: var(--now-color--text-primary, black); } h4 { font-size: 14pt; font-family: Lato; color: var(--now-color--text-primary, black); } a { font-size: 12pt; font-family: Lato; color: var(--now-color--link-primary, #00718F); } a:hover { font-size: 12pt; color: var(--now-color--link-primary, #024F69); } a:target { font-size: 12pt; color: var(--now-color--link-primary, #032D42); } a:visited { font-size: 12pt; color: var(--now-color--link-primary, #00718f); } ul { font-size: 12pt; font-family: Lato; } li { font-size: 12pt; font-family: Lato; } img { display: ; max-width: ; width: ; height: ; } } When you do a test load on "SG-SCCM Computer Identity" data source, you will encounter below error MID Server reported error: SQLState: S0001com.microsoft.sqlserver.jdbc.SQLServerException: Invalid column name 'TimeKey'.at com.microsoft.sqlserver.jdbc.SQLServerException.makeFromDatabaseError(SQLServerException.java:262)at com.microsoft.sqlserver.jdbc.SQLServerStatement.getNextResult(SQLServerStatement.java:1624)at com.microsoft.sqlserver.jdbc.SQLServerStatement.doExecuteCursored(SQLServerStatement.java:2021)at com.microsoft.sqlserver.jdbc.SQLServerStatement.doExecuteStatement(SQLServerStatement.java:844)at com.microsoft.sqlserver.jdbc.SQLServerStatement$StmtExecCmd.doExecute(SQLServerStatement.java:768)at com.microsoft.sqlserver.jdbc.TDSCommand.execute(IOBuffer.java:7194)at com.microsoft.sqlserver.jdbc.SQLServerConnection.executeCommand(SQLServerConnection.java:2979)at com.microsoft.sqlserver.jdbc.SQLServerStatement.executeCommand(SQLServerStatement.java:248)at com.microsoft.sqlserver.jdbc.SQLServerStatement.executeStatement(SQLServerStatement.java:223)at com.microsoft.sqlserver.jdbc.SQLServerStatement.executeQuery(SQLServerStatement.java:693)at com.service_now.monitor.jdbc.JDBCRowSet.query(JDBCRowSet.java:66)at com.service_now.mid.probe.JDBCProbe.doSelect(JDBCProbe.java:479)at com.service_now.mid.probe.JDBCProbe.doQuery(JDBCProbe.java:341)at com.service_now.mid.probe.JDBCProbe.probe(JDBCProbe.java:228)at com.service_now.mid.probe.AProbe.process(AProbe.java:155)at com.service_now.mid.queue_worker.AWorker.runWorker(AWorker.java:140)at com.service_now.mid.queue_worker.AWorkerThread.run(AWorkerThread.java:20)at com.service_now.mid.threadpool.ResourceUserQueue$RunnableProxy.run(ResourceUserQueue.java:643)at java.base/java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1136)at java.base/java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:635)at java.base/java.lang.Thread.run(Thread.java:840) Release<!-- /*NS Branding Styles*/ --> .ns-kb-css-body-editor-container { p { font-size: 12pt; font-family: Lato; color: var(--now-color--text-primary, #000000); } span { font-size: 12pt; font-family: Lato; color: var(--now-color--text-primary, #000000); } h2 { font-size: 24pt; font-family: Lato; color: var(--now-color--text-primary, black); } h3 { font-size: 18pt; font-family: Lato; color: var(--now-color--text-primary, black); } h4 { font-size: 14pt; font-family: Lato; color: var(--now-color--text-primary, black); } a { font-size: 12pt; font-family: Lato; color: var(--now-color--link-primary, #00718F); } a:hover { font-size: 12pt; color: var(--now-color--link-primary, #024F69); } a:target { font-size: 12pt; color: var(--now-color--link-primary, #032D42); } a:visited { font-size: 12pt; color: var(--now-color--link-primary, #00718f); } ul { font-size: 12pt; font-family: Lato; } li { font-size: 12pt; font-family: Lato; } img { display: ; max-width: ; width: ; height: ; } } Any Cause<!-- /*NS Branding Styles*/ --> .ns-kb-css-body-editor-container { p { font-size: 12pt; font-family: Lato; color: var(--now-color--text-primary, #000000); } span { font-size: 12pt; font-family: Lato; color: var(--now-color--text-primary, #000000); } h2 { font-size: 24pt; font-family: Lato; color: var(--now-color--text-primary, black); } h3 { font-size: 18pt; font-family: Lato; color: var(--now-color--text-primary, black); } h4 { font-size: 14pt; font-family: Lato; color: var(--now-color--text-primary, black); } a { font-size: 12pt; font-family: Lato; color: var(--now-color--link-primary, #00718F); } a:hover { font-size: 12pt; color: var(--now-color--link-primary, #024F69); } a:target { font-size: 12pt; color: var(--now-color--link-primary, #032D42); } a:visited { font-size: 12pt; color: var(--now-color--link-primary, #00718f); } ul { font-size: 12pt; font-family: Lato; } li { font-size: 12pt; font-family: Lato; } img { display: ; max-width: ; width: ; height: ; } } PRB1751433 PRB1850589 Resolution<!-- /*NS Branding Styles*/ --> .ns-kb-css-body-editor-container { p { font-size: 12pt; font-family: Lato; color: var(--now-color--text-primary, #000000); } span { font-size: 12pt; font-family: Lato; color: var(--now-color--text-primary, #000000); } h2 { font-size: 24pt; font-family: Lato; color: var(--now-color--text-primary, black); } h3 { font-size: 18pt; font-family: Lato; color: var(--now-color--text-primary, black); } h4 { font-size: 14pt; font-family: Lato; color: var(--now-color--text-primary, black); } a { font-size: 12pt; font-family: Lato; color: var(--now-color--link-primary, #00718F); } a:hover { font-size: 12pt; color: var(--now-color--link-primary, #024F69); } a:target { font-size: 12pt; color: var(--now-color--link-primary, #032D42); } a:visited { font-size: 12pt; color: var(--now-color--link-primary, #00718f); } ul { font-size: 12pt; font-family: Lato; } li { font-size: 12pt; font-family: Lato; } img { display: ; max-width: ; width: ; height: ; } } You need to update the SQL query used by the data source with the correct statement shown below.This tells the system exactly which columns to look for and avoids the error. Open the SG-SCCM Computer Identity data source in your system. Replace its SQL query with this updated one: SELECT v_GS_COMPUTER_SYSTEM.Name0 as name,v_GS_COMPUTER_SYSTEM.domain0 as domain,v_GS_COMPUTER_SYSTEM.Model0 as model,v_GS_COMPUTER_SYSTEM.Manufacturer0 as manufacturer,v_GS_COMPUTER_SYSTEM.ResourceID,v_GS_SYSTEM_CONSOLE_USAGE.TopConsoleUser0 as username,v_GS_COMPUTER_SYSTEM.NumberOfProcessors0 as numberofprocessors,v_GS_SYSTEM.SystemRole0 as SystemRole,v_GS_OPERATING_SYSTEM.Caption0 as caption,v_GS_OPERATING_SYSTEM.Version0 as Version,v_GS_SYSTEM_ENCLOSURE.ChassisTypes0 as chassistype,CONVERT(datetime, SWITCHOFFSET(TODATETIMEOFFSET(WorkstationStatus_DATA.LastHWScan,datepart(tz,SYSDATETIMEOFFSET())),0)) AS LastHWScan,v_GS_PC_BIOS.SerialNumber0 as BIOSSerialNumber,v_GS_COMPUTER_SYSTEM_PRODUCT.IdentifyingNumber0 as SystemSerialNumber,v_GS_COMPUTER_SYSTEM_PRODUCT.UUID0 as UUIDSerialNumber,v_GS_SYSTEM_ENCLOSURE.SerialNumber0 as ChassisSerialNumber,v_GS_BASEBOARD.SerialNumber0 as BaseboardSerialNumber,WorkstationStatus_DATA.TimeKey as TimeKey,v_GS_OPERATING_SYSTEM.TimeStamp as OsTimeStamp,v_R_System.Creation_Date0 as AssignedDate,null as OUName,v_GS_SYSTEM_ENCLOSURE.SMBIOSAssetTag0 as AssetTagFROM v_GS_COMPUTER_SYSTEMLEFT JOIN WorkstationStatus_DATA ON v_GS_COMPUTER_SYSTEM.ResourceID = WorkstationStatus_DATA.MachineID LEFT JOIN v_GS_SYSTEM ON v_GS_COMPUTER_SYSTEM.ResourceID = v_GS_SYSTEM.ResourceID LEFT JOIN v_GS_PC_BIOS ON v_GS_COMPUTER_SYSTEM.ResourceID = v_GS_PC_BIOS.ResourceIDLEFT JOIN v_GS_OPERATING_SYSTEM ON v_GS_COMPUTER_SYSTEM.ResourceID = v_GS_OPERATING_SYSTEM.ResourceIDLEFT JOIN v_GS_COMPUTER_SYSTEM_PRODUCT ON v_GS_COMPUTER_SYSTEM.ResourceID = v_GS_COMPUTER_SYSTEM_PRODUCT.ResourceIDLEFT JOIN v_GS_SYSTEM_ENCLOSURE ON v_GS_COMPUTER_SYSTEM.ResourceID = v_GS_SYSTEM_ENCLOSURE.ResourceIDLEFT JOIN v_GS_BASEBOARD ON v_GS_COMPUTER_SYSTEM.ResourceID = v_GS_BASEBOARD.ResourceIDLEFT JOIN v_GS_SYSTEM_CONSOLE_USAGE ON v_GS_COMPUTER_SYSTEM.ResourceID = v_GS_SYSTEM_CONSOLE_USAGE.ResourceIDLEFT JOIN v_R_System ON v_GS_COMPUTER_SYSTEM.ResourceID = v_R_System.ResourceID ***IMPORTANT*** After the change is applied, we want the SQL to remain OOB for the "SG-SCCM Computer Identity" data source and be replaced with the next SGC SCCM upgrade for the data source SG-SCCM Computer Identity. To ensure this upgrade completes successfully, please perform these steps Navigate to sys_update_xml tableUse filter conditions to help query the record. The target name is 'SG-SCCM Computer Identity', and the type is 'Data Source'Ensure the 'Replace on Upgrade' checkbox on the corresponding sys_update_xml record is checked. NOTE: You may have to configure the form layout to show the 'Replace On Upgrade' selection or add it in list view (by personalising the list) https://www.servicenow.com/docs/bundle/xanadu-application-development/page/build/system-update-sets/task/t_OverwriteCustomizsDuringUpgrades.html