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 Upgrade Win 10 build to version 2004
by  CyberCitizen   Go to last post Go to first unread
Last post: Today at 12:11:55 AM(UTC)
Lansweeper Sort Reports by Last Changed
by  LANGuy  
Go to last post Go to first unread
Last post: Yesterday at 7:02:23 PM(UTC)
Lansweeper Windows Encryption Method
by  elKastr0nom   Go to last post Go to first unread
Last post: Yesterday at 6:02:07 PM(UTC)
Lansweeper Built in report - AD Password Expired
by  FezUSA  
Go to last post Go to first unread
Last post: Yesterday at 3:12:17 PM(UTC)
Lansweeper Helpdesk Dashboard Shared Tab
by  mark chamberlain   Go to last post Go to first unread
Last post: Yesterday at 2:32:20 PM(UTC)
Lansweeper Uninstall an software with Password
by  CyberCitizen   Go to last post Go to first unread
Last post: Yesterday at 6:20:28 AM(UTC)
Lansweeper Scanning for Events in Applications and Services Logs
by  Geoff P G  
Go to last post Go to first unread
Last post: 10/20/2021 5:22:11 PM(UTC)