PSPMHOST_VW (SQL View)	Index Back
Domain host/port view Performance monitor view of distinct host/ports under the current agent list.

PSPMHOST_VW

(SQL View)

Domain host/port view

Performance monitor view of distinct host/ports under the current agent list.

SELECT DISTINCT PM_SYSTEMID , PM_HOST_PORT FROM PSPMAGENT

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 PM_SYSTEMID Number(5,0) INTEGER NOT NULL Performance Monitor System Identifier.

2 PM_HOST_PORT Character(64) VARCHAR2(64) NOT NULL Performance Monitor host name.

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	PM_SYSTEMID	Number(5,0)	INTEGER NOT NULL	Performance Monitor System Identifier.
2	PM_HOST_PORT	Character(64)	VARCHAR2(64) NOT NULL	Performance Monitor host name.