Looking for a sql query that would allow to get all profiles that have no values in  SSRV2ConfigValue

book

Article ID: 192125

calendar_today

Updated On:

Products

NIMSOFT PROBES DX Infrastructure Management

Issue/Introduction

Looking for a sql query that would allow to get all profiles that have no values in  SSRV2ConfigValue

Environment

Release : 8..x. 9.x 20.x

Component : UNIFIED INFRASTRUCTURE MGMT

Resolution

If you want all the information about profile which is not present in SSRV2ConfigValue table, please run below query:

select profileid from ssrv2profile where profileid not in (select profile from ssrv2configvalue)

If you want all the profile id's which is not present in SSRV2ConfigValue table, please run below query:

select * from ssrv2profile where profileid not in (select profile from ssrv2configvalue)