Managed File Transfer

Select
From
??????
Where 
??????

Ok, what is the SQL statement I need to find all partners using PGP encryption.
I have looked on the Web and found this but not really seeing it. 

 Select
  *
from
     sci_profile a
         left join SCI_ENTITY_EXTNS b on a.object_id = b.object_id
order by
     object_name


Thanks 

=========================================================

and 



------------------------------
Jeff Endres
IT Senior Analyst EDI
GPC IT Shared Services


------------------------------

#filetransfer
#DataExchange

Try  select OBJECT_NAME from SCI_DOC_EXCHANGE where PGP_PK_ENCRYPT like '%'

Not sure if you can use two keys once on one profile

------------------------------
Rajasekhar Muthamsetty
------------------------------

Original Message:
Sent: Fri May 01, 2020 02:46 PM
From: Jeff Endres
Subject: SFG- MFT - SQL tables to find all Partners using PGP and.......

Select
From
??????
Where 
??????

Ok, what is the SQL statement I need to find all partners using PGP encryption.
I have looked on the Web and found this but not really seeing it. 

 Select
  *
from
     sci_profile a
         left join SCI_ENTITY_EXTNS b on a.object_id = b.object_id
order by
     object_name


Thanks 

=========================================================

and 

Any advice you can provide on how to utilize two keys at once, so that the old one can continue and the new one be tested.

------------------------------
Jeff Endres
IT Senior Analyst EDI
GPC IT Shared Services


------------------------------

#filetransfer
#DataExchange

THANKS




------------------------------
Jeff Endres
------------------------------

Original Message:
Sent: Fri May 01, 2020 03:12 PM
From: Rajasekhar Muthamsetty
Subject: SFG- MFT - SQL tables to find all Partners using PGP and.......

Try  select OBJECT_NAME from SCI_DOC_EXCHANGE where PGP_PK_ENCRYPT like '%'

Not sure if you can use two keys once on one profile

------------------------------
Rajasekhar Muthamsetty

Original Message:
Sent: Fri May 01, 2020 02:46 PM
From: Jeff Endres
Subject: SFG- MFT - SQL tables to find all Partners using PGP and.......

Select
From
??????
Where 
??????

Ok, what is the SQL statement I need to find all partners using PGP encryption.
I have looked on the Web and found this but not really seeing it. 

 Select
  *
from
     sci_profile a
         left join SCI_ENTITY_EXTNS b on a.object_id = b.object_id
order by
     object_name


Thanks 

=========================================================

and 

Any advice you can provide on how to utilize two keys at once, so that the old one can continue and the new one be tested.

------------------------------
Jeff Endres
IT Senior Analyst EDI
GPC IT Shared Services


------------------------------

#filetransfer
#DataExchange