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 Webcam report, the wrong way
by  TimHolmes1973   Go to last post Go to first unread
Last post: 10/23/2020 4:38:45 PM(UTC)
Lansweeper zerologin posted report
by  hanslepire  
Go to last post Go to first unread
Last post: 10/23/2020 8:50:59 AM(UTC)
Lansweeper Need help finishing a report for Failed Logons
by  Helpdesk15   Go to last post Go to first unread
Last post: 10/20/2020 3:10:33 PM(UTC)
Report Center Chart: Microsoft Office 365 Versions
by  craigsmith.lpi  
Go to last post Go to first unread
Last post: 10/19/2020 10:18:21 PM(UTC)
Lansweeper Russian in Report
by  EStarshinov   Go to last post Go to first unread
Last post: 10/15/2020 7:18:22 AM(UTC)
Lansweeper Asset location report with count ?
by  Argon0  
Go to last post Go to first unread
Last post: 10/14/2020 11:05:33 AM(UTC)
Lansweeper Inventory for all Connected Headphone
by  Csteenhaut   Go to last post Go to first unread
Last post: 10/8/2020 1:45:25 PM(UTC)
Lansweeper All Ticket Overview Report
by  Ryan211  
Go to last post Go to first unread
Last post: 10/6/2020 11:27:33 PM(UTC)