Announcing the Saviynt Knowledge Exchange unifying the Saviynt forums, documentation, training,
and more in a single search tool across platforms. Read the announcement here.
This website uses cookies. By clicking Accept, you consent to the use of cookies. Click Here to learn more about how we use cookies.
Accept
Reject
Help
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 

Need to run SQL: Which table can give me endpoint names?

ashutoshb
New Contributor
New Contributor

‎06/29/2022 01:25 PM

Can someone suggest me which table store endpoint details?

0 Kudos
5 REPLIES 5

rushikeshvartak
All-Star
All-Star

‎06/29/2022 01:32 PM - edited ‎06/29/2022 01:33 PM

select * from endpoints

endpointname is column name

https://saviynt.freshdesk.com/support/solutions/articles/43000521404-saviynt-enterprise-identity-clo... 


Regards,
Rushikesh Vartak
If you find the response useful, kindly consider selecting Accept As Solution and clicking on the kudos button.
0 Kudos

ashutoshb
New Contributor
New Contributor
In response to rushikeshvartak

‎06/29/2022 01:57 PM

Thanks much.

0 Kudos

ashutoshb
New Contributor
New Contributor
In response to rushikeshvartak

‎06/29/2022 02:02 PM

Column STATUS,UPDATEDATE are restricted from use. Please specify columns other than these. Also, use of symbols <,>,& in column name is restricted.

 

I am getting above error, any suggestions

0 Kudos

rushikeshvartak
All-Star
All-Star
In response to ashutoshb

‎06/29/2022 03:13 PM

select endpointname, displayname from endpoints 

Select systemname, displayname from securitysystems 


Regards,
Rushikesh Vartak
If you find the response useful, kindly consider selecting Accept As Solution and clicking on the kudos button.
0 Kudos

ashutoshb
New Contributor
New Contributor

‎06/29/2022 02:06 PM

Also I need list of all security systems

0 Kudos
Copyright © 2024 Khoros, LLC