Notification

Icon
Error

sqlServerId is changing - sqlServerId is changing

Posted: Friday, September 17, 2021 3:40:34 PM(UTC)
Ciro Bizelli

Ciro Bizelli

Member Original PosterPosts: 1
1
Like
Hello!

I'm doing an integration between the Servicenow and Lansweeper, and I noticed that my sqlServerId (table tblsqlServers) is changing, and that's impacting on the relationship between our assets, databases, etc.

So, I don't know exactly how I can fix it, because when I saw the other tables the id (pk) is the same even if the asset had some change.

Apparently, this occurs only on this table.

Does anyone know how I fix it?

Anyway, thank you!
FrankSc
#1FrankSc Member Administration Posts: 165  
posted: 9/23/2021 3:42:16 PM(UTC)
Hi,
When an asset gets rescanned, certain data that is picked up just gets re-inserted in the database. So the old data gets often removed and inserted again with the new scan, rather this just updating the existing data.
This is also the case for SQLServer data. So this is the reason why it gets a new SqlServerId after each scan.

Active Discussions

Lansweeper Chrome 95 Audit
by  Esben.D  
Go to last post Go to first unread
Last post: Yesterday at 11:14:31 AM(UTC)
Lansweeper Detecting and Reporting on Programs in Apps & Features
by  LANGuy  
Go to last post Go to first unread
Last post: 10/18/2021 6:09:11 PM(UTC)
Lansweeper OS: Not latest Build of Windows 10 not working
by  jmm25   Go to last post Go to first unread
Last post: 10/18/2021 12:48:41 PM(UTC)
Lansweeper AD DistinguishedName of Computer object
by  elKastr0nom   Go to last post Go to first unread
Last post: 10/14/2021 6:52:50 PM(UTC)
Lansweeper Report if Credential Guard is active
by  ericatbrandmauer  
Go to last post Go to first unread
Last post: 10/14/2021 10:28:15 AM(UTC)