IT_SN_AUTH_VW (SQL View)	Index Back
IT Devices - SerialNbr-based IT Devices eligible for SerialNbr-based Software Authorizations.

IT_SN_AUTH_VW

(SQL View)

IT Devices - SerialNbr-based

IT Devices eligible for SerialNbr-based Software Authorizations.

SELECT A.SERIAL_ID , A.ASSET_SUBTYPE , A.TAG_NUMBER , A.NBR_OF_CPU FROM PS_ASSET A WHERE A.ASSET_TYPE = '010' AND EXISTS ( SELECT 'X' FROM PS_IT_SUBTYPE B WHERE B.AUTHORIZE_SFTWR = 'Y' AND A.ASSET_SUBTYPE = B.IT_SUBTYPE) AND A.IN_PHY_USE = 'Y'

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 SERIAL_ID Character(20) VARCHAR2(20) NOT NULL Serial ID

2 ASSET_SUBTYPE Character(15) VARCHAR2(15) NOT NULL Asset Subtype

3 TAG_NUMBER Character(12) VARCHAR2(12) NOT NULL Tag Number

4 NBR_OF_CPU Number(3,0) SMALLINT NOT NULL Used by ITAM. Servers and Desktops can have multiple CPUs. A separate Software License is needed for each CPU.

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	SERIAL_ID	Character(20)	VARCHAR2(20) NOT NULL	Serial ID
2	ASSET_SUBTYPE	Character(15)	VARCHAR2(15) NOT NULL	Asset Subtype
3	TAG_NUMBER	Character(12)	VARCHAR2(12) NOT NULL	Tag Number
4	NBR_OF_CPU	Number(3,0)	SMALLINT NOT NULL	Used by ITAM. Servers and Desktops can have multiple CPUs. A separate Software License is needed for each CPU.