cancel
Showing results for 
Search instead for 
Did you mean: 
cancel
574
Views
0
Helpful
4
Replies
Highlighted
Beginner

CMX 10.2 History Client

Hi,

I have the next issue with CMX 10.2.1-219

I need retrieve all the history Client from API but the response is an error with code 500

Error:

PRIMARY KEY column "changedon" cannot be restricted (preceding column "key" is either not restricted or by a non-EQ relation)

I tried the next calls with the same error:

http://myHostCMX/api/location/v1/history/clients

http://myHostCMX/api/location/v1/history/clients?mapHierarchy=MyBuilding>MyCampus>MyFloor

http://myHostCMX/api/location/v1/history/clients?mapHierarchy=MyBuilding>MyCampus>MyFloor&pageSize=10&page=1&sortBy=lastLocatedTime:ASC?lastLocatedTime=2016-04-08T01:37:38.519-0700&beforeLocatedTime=2016-04-08T01:37:38.519-0700

The only way for get information is call the RESTFul with the parameter MacAddress however I need get all the macAddress.

http://myHostCMX/api/location/v1/history/clients/XX:XX:XX:XX:XX:XX

I tried to get all the macAddress with this

http://myHostCMX/api/location/v2/clients?sortBy=lastLocatedTime:ASC?page=x&pageSize=100

but the response is only for Active MacAddress

Please do you know if this is a bug or something is wrong with the parameters?

thanks for your time.

Everyone's tags (1)
4 REPLIES 4
Highlighted
Frequent Contributor

Re: CMX 10.2 History Client

Hi,  I have been studying your questions, and have a couple back to you - what do you mean by Active MacAddress?  Do you mean associated (connected to AP) as active?  Thanks, Matt

Highlighted
Beginner

Re: CMX 10.2 History Client

Yes, Sorry Connected to AP

For example, if I search for a specific MAC address logged last week, this is not found, but today yes

Highlighted
Frequent Contributor

Re: CMX 10.2 History Client

Jorge,

If you have login credentials for your CMX, Prime Infrastructure, and Wireless LAN Controller user interface, then check the status of the MAC addresses in question on the other devices.  The CMX may not have current information on the particular wireless device in question, but may have location history available.  Also, see if the configuration guides for the products, Hopefully, can provide the missing information you need.

Matt

Highlighted
Beginner

Re: CMX 10.2 History Client

I'm seeing the same issue.

CreatePlease to create content
Content for Community-Ad
Cisco Community May 2020 Spotlight Award Winners
This widget could not be displayed.