Notification

Icon
Error

SCCM Integration

Posted: Thursday, April 30, 2020 4:18:06 PM(UTC)
joel.marquis

joel.marquis

Member Original PosterPosts: 5
0
Like
I've followed the guide on how to integrate Lansweeper with SCCM as shown here:

https://www.lansweeper.c...ng-lansweeper-with-sccm/

However, when I try to scan the newly created SCCM target it comes back with the below error which means absolutely nothing to me! Has anyone else experienced this and been able to resolve it?

The operation failed: The relationship could not be changed because one or more of the foreign-key properties is non-nullable. When a change is made to a relationship, the related foreign-key property is set to a null value. If the foreign-key does not support null values, a new relationship must be defined, the foreign-key property must be assigned another non-null value, or the unrelated object must be deleted.

Cheers
Joel
Erik.T
#1Erik.T Member Administration Posts: 99  
posted: 5/25/2020 5:29:26 PM(UTC)
Hi joel,

The error you are seeing can be throw when the account provided in Lansweeper does not have the correct privileges.
The account for scanning SCCM has to have local administrative permissions on the SCCM server and at minimum, the read-only analyst security role in the SCCM administrative users.

We have made some improvements to our SCCM scanning logic, so if you're not running the latest version of Lansweeper, I would recommend first updating to the latest version which could already fix your issue.
joel.marquis
#2joel.marquis Member Original PosterPosts: 5  
posted: 6/2/2020 8:51:33 AM(UTC)
Originally Posted by: Erik.T Go to Quoted Post
Hi joel,

The error you are seeing can be throw when the account provided in Lansweeper does not have the correct privileges.
The account for scanning SCCM has to have local administrative permissions on the SCCM server and at minimum, the read-only analyst security role in the SCCM administrative users.

We have made some improvements to our SCCM scanning logic, so if you're not running the latest version of Lansweeper, I would recommend first updating to the latest version which could already fix your issue.


Thanks for the reply but this doesn't appear to be the case. My Lansweeper service account is in the domain admins group in AD as well as being a local admin on the SCCM server itself, I've also tried Read-Only and Full Administrator rights within SCCM.

Are there any logs I can look at?

Cheers
Joel
Peter Trethewey
#3Peter Trethewey Member Posts: 2  
posted: 8/19/2020 9:38:31 PM(UTC)
Same error - not related to access levels
THODAH
#4THODAH Member Posts: 1  
posted: 9/25/2020 1:09:45 PM(UTC)
I too see this error, and I'm positive it has nothing to do with access permissions on either server or SCCM, as I'm currently trying with my own admin account, which I also use for a number of powershell scripts also heavily relying on WMI queries which is working.

Active Discussions

Lansweeper HP Warranty scan - broken for some products
by  TBMPS   Go to last post Go to first unread
Last post: Yesterday at 3:13:19 PM(UTC)
Lansweeper Assets with different MACs/IPs getting merged
by  MartinO  
Go to last post Go to first unread
Last post: 10/23/2020 3:15:25 PM(UTC)
Lansweeper Where is Extension Attribute 1
by  CoolDood   Go to last post Go to first unread
Last post: 10/22/2020 8:45:46 PM(UTC)
Lansweeper Accessing IMEI/MEID fields for manual assets
by  Tom Londe  
Go to last post Go to first unread
Last post: 10/22/2020 5:31:27 PM(UTC)
Lansweeper Server 2019 Version Numbers
by  MCBowman  
Go to last post Go to first unread
Last post: 10/22/2020 2:35:32 PM(UTC)