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

Products

• DX Unified Infrastructure Management (Nimsoft / UIM)

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)