How to export user's application accesses

[Jaya]

Hi All,

Is there any way to download all the application access a user is having in Saviynt.

Like the export should contain user related details with application name & entitlement value.

As I cannot see any Inbuilt export option, if someone can provide me analytics query for same that would be so helpful & timesaving.

Thanks,

Jaya Karothia

[RakeshMG]

Please try using API call : Get Access Details For User
. 

Which will provide following result for any user.

{
"msg": "Successful",
"Entitlementdetails": [
{
"syscritical": "0",
"access": "Select",
"customproperty1": "test",
"confidentiality": "0",
"module": "Select",
"description": "",
"entitlementOwner": [
"jamessmith",
"peterpan"
],
"priviliged": "0",
"entitlementType": "Access",
"entitlement_glossary": "",
"endpoint": "System1",
"updatedate": "04/08/2017",
"requestForm": "Request Form Table",
"displayname": "Display Name One",
"soxcritical": "0",
"risk": "0",
"entitlement_value": "Entitlement1",
"status": "1",
"updateuser": "1"
},
{
"syscritical": "0",
"access": "Select",
"customproperty1": "test",
"confidentiality": "0",
"module": "Select",
"description": "",
"entitlementOwner": [
"jamessmith",
"peterpan"
],
"priviliged": "0",
"entitlementType": "Access",
"entitlement_glossary": "",
"endpoint": "System1",
"updatedate": "04/08/2017",
"requestForm": "Request Form Table",
"displayname": "Display Name One",
"soxcritical": "0",
"risk": "0",
"entitlement_value": "Entitlement2",
"status": "1",
"updateuser": "1"
},
{
"syscritical": "0",
"access": "Select",
"customproperty1": "test",
"confidentiality": "0",
"module": "Select",
"description": "",
"entitlementOwner": [
"jamessmith",
"peterpan"
],
"priviliged": "0",
"entitlementType": "Access",
"entitlement_glossary": "",
"endpoint": "System1",
"updatedate": "04/08/2017",
"requestForm": "Request Form Table",
"displayname": "Display Name One",
"soxcritical": "0",
"risk": "0",
"entitlement_value": "Entitlement3",
"status": "1",
"updateuser": "1"
},
{
"syscritical": "0",
"customproperty1": "test",
"description": "",
"entitlementOwner": [
"jamessmith",
"janedoe"
],
"entitlementType": "Access",
"entitlement_glossary": "",
"endpoint": "System1",
"updatedate": "02/22/2017",
"requestForm": "Request Form Table",
"displayname": "",
"soxcritical": "0",
"entitlement_value": "Entitlement4",
"status": "1"
},
{
"syscritical": "0",
"customproperty20": "cp20",
"customproperty3": "cp3",
"customproperty1": "ap1",
"description": "",
"entitlementOwner": "",
"entitlementType": "Access",
"entitlement_glossary": "",
"endpoint": "System1",
"updatedate": "04/27/2018",
"requestForm": "Request Form Table",
"displayname": "",
"soxcritical": "0",
"customproperty8": "cp8",
"entitlement_value": "Entitlement5",
"status": "1",
"updateuser": "191327"
},
{
"syscritical": "0",
"endpoint": "System1",
"updatedate": "02/22/2017",
"requestForm": "Request Form Table",
"displayname": "",
"soxcritical": "0",
"description": "",
"entitlementOwner": "",
"entitlement_value": "Entitlement6",
"entitlementType": "Access",
"entitlement_glossary": "",
"status": "1"
},
{
"syscritical": "0",
"endpoint": "System1",
"updatedate": "02/22/2017",
"requestForm": "Request Form Table",
"displayname": "",
"soxcritical": "0",
"description": "",
"entitlementOwner": "",
"entitlement_value": "Entitlement Name for testing the codec issue within user manager attestation",
"entitlementType": "Access",
"entitlement_glossary": "",
"status": "1"
},
{
"syscritical": "0",
"endpoint": "System1",
"updatedate": "02/22/2017",
"requestForm": "Request Form Table",
"displayname": "",
"soxcritical": "0",
"description": "",
"entitlementOwner": "",
"entitlement_value": "Entitlement7",
"entitlementType": "Access",
"entitlement_glossary": "",
"status": "1"
}
],
"totalEntitlementCount": 8,
"entitlementsCount": 8,
"UserDetails": {
"customproperty10": "",
"country": "US",
"customproperty12": "zzzTHIRD",
"customproperty11": "",
"customproperty18": "Allowed",
"customproperty17": "",
"jobCode": "zzzzzzzz",
"customproperty19": "1827",
"customproperty14": "20160803",
"startdate": "01/28/2018T08:00:00+0000",
"customproperty13": "ABCDE",
"secondaryManager": "jamessmith",
"customproperty16": "2016-08-03 00:00:00",
"failedTries": "0",
"customproperty15": "Data change",
"updatedate": "08/02/2018T04:08:16+0000",
"vendorManager": "awsadmin",
"Create Date": "03/28/2018T07:00:00+0000",
"preferedFirstName": "John",
"customproperty40": "1",
"encryptedSecurityAnswers": "0Ti6Bg7+E6QEKEd+x4GNhjWpG3KQ0jCbDzxhupvqPrTsrFM8vmoV/eq70xasjbuX7/amIxOXFHDVpPyHhDXA2AFHjnrHqung/1lBsLLr6tw=",
"enddate": "01/28/2019T08:00:00+0000",
"lastsyncdate": "02/28/2018T08:00:00+0000",
"statuskey": "1",
"departmentNumber": "565",
"jobcodedesc": "zzzzzzzz",
"Last Name": "Doe",
"termDate": "04/28/2018T07:00:00+0000",
"doNotDisturbDelegate": "jackwoods",
"customproperty32": "",
"customproperty4": "SITI",
"customproperty31": "",
"customproperty5": "C",
"customproperty2": "",
"customproperty34": "",
"firstname": "John",
"customproperty3": "Activated",
"customproperty33": "",
"Job Function": "A dummy name for a Skill Pool Group",
"locationnumber": "SF-OFC",
"city": "Atlanta",
"customproperty30": "2016-09-15 00:30:56",
"employeeclass": "C",
"customproperty39": "",
"locationdesc": "5 Longfellow St.Deer Park",
"customproperty36": "",
"title": "Analyst",
"customproperty35": "",
"employeeid": "",
"customproperty38": "",
"enabled": "true",
"customproperty37": "",
"Department Name": "IAM",
"Orgunit ID": "CO",
"systemUserName": "jdoe",
"street": "s",
"customproperty8": "mm",
"customproperty9": "",
"customproperty6": "John Doe",
"email": "jdoe@saviynt.com",
"customproperty7": "J.Doe",
"accountLocked": "false",
"customproperty21": "",
"owner": "janedoe",
"customproperty20": "INFORMATION TECHNOLOGY INTERNATIONAL B.V.",
"customproperty23": "",
"comments": "test",
"customproperty22": "",
"manager": "janedoe",
"User Name": "johndoe",
"customproperty29": "",
"customproperty28": "",
"middlename": "w",
"customproperty25": "",
"Custom Property 1": "IP",
"customproperty24": "",
"customproperty27": "",
"customproperty26": "",
"Company Name": "Information Technology International",
"employeeType": "Contractor",
"owneronTerminate": "4",
"createdBy": "admin",
"displayname": "Doe, John",
"accountExpired": "false",
"location": "SF-OFC",
"passwordExpired": "false",
"updateuser": "admin"
},
"Accountdetails": [
{
"customproperty10": "cp10",
"customproperty20": "cp20",
"customproperty2": "cp2",
"endpoint": "System1",
"customproperty1": "cp1",
"customproperty30": "cp30",
"name": "janedoe",
"description": "desc",
"createdon": "07/26/2018",
"status": "1"
}
],
"errorCode": "0",
"PrivilegeDetails": []
}

For more details please refer to following document. 

https://documenter.getpostman.com/view/20697337/2s935smLj6#b6eacac0-4e99-486a-9a26-0f32a52124a3