This discussion has been locked. The information referenced herein may be inaccurate due to age, software updates, or external references.

You can no longer post new replies to this discussion. If you have a similar question you can start a new discussion in this forum.

What is the curl command to update my fetched available IP address as reserved or used

azhar_yousuf over 5 years ago

I am using the following curl command which is fetching me the first available IP address from my subnet ID.

curl -k -v -u "myuser:password" mysolarwinds:17778/.../Query

Output

* About to connect() to mysolarwinds port 17778 (#0)

* Trying mysolarwinds...

* Connected to mysolarwinds (mysolarwinds) port 17778 (#0)

* Initializing NSS with certpath: sql:/etc/pki/nssdb

* skipping SSL peer certificate verification

* SSL connection using TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384

* Server certificate:

* subject: CN=SolarWinds-Orion

* start date: Nov 23 00:21:10 2017 GMT

* expire date: Dec 31 23:59:59 2039 GMT

* common name: SolarWinds-Orion

* issuer: CN=SolarWinds-Orion

* Server auth using Basic with user 'myuser'

> GET /SolarWinds/InformationService/v3/Json/Query?query=SELECT+TOP+1+STATUS,+DisplayName+FROM+IPAM.IPNode+WHERE+Status=2+AND+SubnetId=100 HTTP/1.1

> Authorization: Basic XYZW245R

> User-Agent: curl/7.29.0

> Host: mysolarwinds:17778

> Accept: */*

< HTTP/1.1 200 OK

< Content-Length: 56

< Content-Type: application/json

< Server: Microsoft-HTTPAPI/2.0

< Date: Wed, 19 Dec 2018 13:06:40 GMT

* Connection #0 to host mysolarwinds left intact

{"results":[{"STATUS":2,"DisplayName":"10.248.1.10"}]}

Now what do I have to do to my above curl commad to mar the fetched IP address as reserved or used, so that next time when I run the above command it will fetch the second IP instead of he first one. Kindly assist me on this

Thanks and Regards,

Azhar

Top Replies

tdanner over 5 years ago +1 verified

Try this: curl -k -v -u "myuser:password" -d '["10.248.1.10","Used"]' -H "Content-Type: application/json" https://mysolarwinds:17778/SolarWinds/InformationService/v3/Json/Invoke/IPAM.SubnetManagement/

0 tdanner over 5 years ago

Try this:
curl -k -v -u "myuser:password" -d '["10.248.1.10","Used"]' -H "Content-Type: application/json" https://mysolarwinds:17778/SolarWinds/InformationService/v3/Json/Invoke/IPAM.SubnetManagement/ChangeIPStatus
Cancel
Vote Up +1 Vote Down

Cancel
0 azhar_yousuf over 5 years ago in reply to tdanner

Hey ,
Thanks for providing the proper API call and it worked absolutely fine.
Also could you please tell me if there any other ways of fetching the available IP via endpoint URL instead of using the below command
curl -k -v -u "myuser:password" https://mysolarwinds:17778/SolarWinds/InformationService/v3/Json/Query?query=SELECT+TOP+1+STATUS,+DisplayName+FROM+IPAM.IPNode+WHERE+Status=2+AND+SubnetId=10
Thanks and Regards,
Azhar
Cancel
Vote Up 0 Vote Down

Cancel
0 tdanner over 5 years ago in reply to azhar_yousuf

Sure. You can call the GetFirstAvailableIp verb: https://github.com/solarwinds/OrionSDK/wiki/IPAM-4.7-API#get-first-available-ip-address-for-specific-subnet
From curl, that would look like this:
curl -k -v -u "myuser:password" -d '["10.248.1.0","24"]' -H "Content-Type: application/json" https://mysolarwinds:17778/SolarWinds/InformationService/v3/Json/Invoke/IPAM.SubnetManagement/GetFirstAvailableIp
Cancel
Vote Up 0 Vote Down

Cancel
0 azhar_yousuf over 5 years ago in reply to tdanner

Hey,
Yes it works as well. Thank you so much for your help
Thanks and Regards,
Azhar
Cancel
Vote Up 0 Vote Down

Cancel