query to get Disconnected security system ,endpoint,entitlement type and entitlement list

[Harish1]

Hi Team,

we require query to get list of Disconnected security system ,endpoint,entitlement type and entitlement list from Saviynt.

As we tried using below query but getting syntax error. Can you please suggest?

SELECT
ss.systemname,
e.endpointname AS 'EndpointName',
et.displayname AS 'EntitlementType',
ev.entitlement_value AS 'Entitlement Value',
ev.description AS 'EntitlementDescription',
FROM
securitysystems ss
INNER JOIN endpoints e
ON ss.systemKey = e.securitysystemKey
INNER JOIN entitlement_values ev
ON ae.entitlement_valuekey = ev.entitlement_valuekey
INNER JOIN entitlement_types et
ON ev.entitlementtypekey = et.entitlementtypekeyWHEREss.systemname in('')

Regards,

Harish

[AmitM]

Hi @Harish1 

SELECT ss.systemname,e.endpointname AS 'EndpointName',
et.displayname AS 'EntitlementType',
ev.entitlement_value AS 'Entitlement Value' FROM securitysystems ss
JOIN endpoints e ON ss.systemKey = e.securitysystemKey
Join entitlement_types et on et.endpointkey=e.endpointkey
Join entitlement_values ev on ev.entitlementtypekey=et.entitlementtypekey
where (ss.reconapplication ='false')

Thanks,

Amit

If this answers your query, Please ACCEPT SOLUTION and give KUDOS.

[dgandhi]

Can you please try below?

[rushikeshvartak]

SELECT ss.systemname,
       e.endpointname       AS 'EndpointName',
       et.displayname       AS 'EntitlementType',
       ev.entitlement_value AS 'Entitlement Value',
       ev.description       AS 'EntitlementDescription'
FROM   securitysystems ss
       INNER JOIN endpoints e
               ON ss.systemkey = e.securitysystemkey
                  AND ss.automatedprovisioning = false
       INNER JOIN entitlement_types et
               ON et.endpointkey = e.endpointkey
       INNER JOIN entitlement_values ev
               ON ev.entitlementtypekey = et.entitlementtypekey