IP_ADDRESS_VW (SQL View)	Index Back
Asset IP Address View View of IP Addresses in the Asset Repository.

IP_ADDRESS_VW

(SQL View)

Asset IP Address View

View of IP Addresses in the Asset Repository.

SELECT IP_ADDRESS , DESCR FROM PS_ASSET WHERE IP_ADDRESS <> ' '

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 IP_ADDRESS Character(39) VARCHAR2(39) NOT NULL Internet Protocol Address

2 DESCR Character(30) VARCHAR2(30) NOT NULL Description

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	IP_ADDRESS	Character(39)	VARCHAR2(39) NOT NULL	Internet Protocol Address
2	DESCR	Character(30)	VARCHAR2(30) NOT NULL	Description