on 10-08-2009 5:56 PM
Hi ,
Could you let me know any abap table which contains information about communication channels in PI 7.0.
I have checked the following link
But the table SMPREL3 is not active in our data dictionary. is there any other table which stores this information.
-
My requirement is to get the list of all channels which have quality of service as EOIO in the processing tab of the comm channel.
Let me know if there are any other ways of checking this.
Here Is complete solution:
select * from XI_DIRKEYCHANNEL; --- Channel Name and Channel ID
select * from XI_DIRSYNCADMIN; --- Channel ID and Channel Date
select * from XI_DIRDATACHANNEL; -- Channel ID and Channel whole XML as field ATTRBTS
To decipher LOB data type ATTRBTS field of above table to get channel data.
use below string:
select cast(BINTOSTR(cast(ATTRBTS as binary)) as varchar) from XI_DIRDATACHANNEL;
Navdeep Swami
PI Expert
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi,
Some tables in following blog:
Regards,
Giuseppe
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi Varun,
Check "SSRVCHANNEL" table in the PI server.
This table contains the communication channels information.
Regards
Ramesh
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
87 | |
10 | |
10 | |
10 | |
7 | |
6 | |
6 | |
5 | |
5 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.