How to use the ISE API to obtain as many data as the .csv file fields generated from Total Endpoints->Export->Export All in the web page?
Currently, I use Postman to use https://XXX.XXX.XXX.XXX:9060/ers/config/endpoint to obtain the following:
{
"SearchResult": {
"total": XXXXX,
"resources": [
{
"id": "XXXXXXXX-XXXX-XXXX-XXXX-XXXXXXXXXXXX",
"name": "XX:XX:XX:XX:XX:XX",
"link": {
"rel": "self",
"href": "https://XXX.XXX.XXX.XXX:9060/ers/config/endpoint/XXXXXXXX-XXXX-XXXX-XXXX-XXXXXXXXXXXX",
"type": "application/json"
}
},
{
"id": "XXXXXXXX-XXXX-XXXX-XXXX-XXXXXXXXXXXX",
"name": "XX:XX:XX:XX:XX:XX",
"link": {
"rel": "self",
"href": "https:// XXX.XXX.XXX.XXX:9060/ers/config/endpoint/XXXXXXXX-XXXX-XXXX-XXXX-XXXXXXXXXXXX",
"type": "application/json"
}
},
{…
Then use the value of KEY as href in each project https://XXX.XXX.XXX.XXX:9060/ers/config/endpoint/XXXXXXXX-XXXX-XXXX-XXXX-XXXXXXXXXXXX to obtain the individual information as follows:
{
"ERSEndPoint": {
"id": "XXXXXXXX-XXXX-XXXX-XXXX-XXXXXXXXXXXX",
"name": "XX:XX:XX:XX:XX:XX",
"mac": "XX:XX:XX:XX:XX:XX",
"profileId": "XXXXXXXX-XXXX-XXXX-XXXX-XXXXXXXXXXXX",
"staticProfileAssignment": false,
"staticProfileAssignmentDefined": true,
"groupId": "XXXXXXXX-XXXX-XXXX-XXXX-XXXXXXXXXXXX",
"staticGroupAssignment": false,
"staticGroupAssignmentDefined": true,
"portalUser": "",
"identityStore": "",
"identityStoreId": "",
"link": {
"rel": "self",
"href": "https:// XXX.XXX.XXX.XXX:9060/ers/config/endpoint/XXXXXXXX-XXXX-XXXX-XXXX-XXXXXXXXXXXX",
"type": "application/json"
}
}
}
However, in the above attributes (fields), there are not as many fields as the .csv file generated from Total Endpoints->Export->Export All in the ISE Web page as follows:
MACAddress,EndPointPolicy,IdentityGroup,AuthenticationIdentityStore,AuthenticationMethod,AllowedProtocolMatchedRule,AuthorizationPolicyMatchedRule,SelectedAuthorizationProfiles,Description,DeviceRegistrationStatus,BYODRegistration,Device Type,EmailAddress,ip,ipv6,FirstName,host-name,LastName,LogicalProfile,Total Certainty Factor,NADAddress,Location,NAS-IP-Address,NAS-IPv6-Address,NAS-Port-Id,UserName,NetworkDeviceName,operating-system,operating-system-result,OS Version,OUI,PortalUser User-Name,StaticAssignment,StaticGroupAssignment,UpdateTime,MessageCode,FailureReason,UserType,EndpointIdentityGroup,EndpointOperatingSystem,PortalUser.FirstName,PortalUser.LastName,PortalUser.EmailAddress,PortalUser.PhoneNumber,PortalUser.GuestType,PortalUser.GuestStatus,PortalUser.Location,PortalUser.GuestSponsor,PortalUser.CreationType,AUPAccepted,EndPointGroup,EndPointProfilerServer,cts-security-group,Failure_Reason,PassiveID_Username,AD-Operating-System,Certificate Expiration Date,Certificate Issue Date,Certificate Issuer Name,User-Fetch-Department,User-Fetch-Telephone,User-Fetch-Job-Title,User-Fetch-Organizational-Unit,User-Fetch-CountryName,User-Fetch-LocalityName,User-Fetch-StateOrProvinceName,User-Fetch-StreetAddress,User-Fetch-First-Name,User-Fetch-Email,User-Fetch-Last-Name,SSID,DTLSSupport,Portal.Name,RegistrationTimeStamp,AnomalousBehaviour,PhoneID,posturePassCondition,postureFailCondition
Thanks!