Updating SQL database with webservice. Exception: The remote server returned an error: (400) Bad Request.

[nekumsft]

Hi I am new to the github, trying to implement the ConfigMgrClientHealth solution in my lab environment but getting the below error:

Updating SQL database with results using webservice
Error Invoking RestMethod POST on URI http://xxx-xxx01.xxxxxxxxxxx.com/ConfigMgrClientHealth/Clients. Failed to update d
atabase using webservice. Exception: The remote server returned an error: (400) Bad Request.
PS C:> $PSVersionTable

Name Value

---

PSVersion 5.1.14409.1005
PSEdition Desktop
PSCompatibleVersions {1.0, 2.0, 3.0, 4.0...}
BuildVersion 10.0.14409.1005
CLRVersion 4.0.30319.34209
WSManStackVersion 3.0
PSRemotingProtocolVersion 2.3
SerializationVersion 1.1.0.1

Hoping to get some help... :)

[NoDowt]

@nekumsft Did you find a solution to this? I'm getting the same thing now...

Might have found something... I'd put in some changes to the script to check for free space in GB, rather than %... guessing the web service doesn't like it... its working fine using the default script.

[Saxomania]

@nekumsft Did you find a solution to this? I'm getting the same thing now...

Might have found something... I'd put in some changes to the script to check for free space in GB, rather than %... guessing the web service doesn't like it... its working fine using the default script.

I have a similar problem:

Error Invoking RestMethod POST on URI https://server.fqdn/ConfigMgrClientHealth/Clients. Failed to update database using webservice. Exception: The remote server returned an error: (500) Internal Server Error.

i dont think its related to config settings for free space

the account who is running web service has dbo rights - tried it as well with an account who has sysadmin rights on the whole SQL instance - also no luck

i am wondering where the hell this "/Clients" comes from because what i run is (in an admin PS):

.\ConfigMgrClientHealth.ps1 -Config "\server.fqdn\Clienthealth$\Config\config.xml" -Webservice https://server.fqdn/ConfigMgrClientHealth

edit:

had an SQL database before so i deleted and recreated it but same problem