SERIAL_IDIT_GRP_IDIT_SWG_CPU_VW(SQL View) |
Index Back |
|---|---|
Number of CPUs for IT AssetITAM - View of the number of CPUs an IT Device has defined. Used in the component where the number of licenses are declared for an IT Device that uses the Serial Number/Device-Based Software Authorization/Compliance Model. |
| SELECT A.SERIAL_ID , C.IT_GRP_ID , D.DESCR , D.GRP_OWNER_ID , B.SFTWR_TITLE , A.NBR_OF_CPU FROM PS_ASSET A , PS_IT_SFTWR_AUTHVW B , PS_IT_SWGRP_DTLVW C , PS_IT_SWGRP D WHERE A.ASSET_TYPE = '010' AND B.AUTH_TYPE = 'D' AND C.GRP_TYPE = 'D' AND C.GRP_VALUE = A.SERIAL_ID AND C.IT_GRP_ID = D.IT_GRP_ID AND EXISTS ( SELECT 'X' FROM PS_IT_SUBTYPE D WHERE D.AUTHORIZE_SFTWR = 'Y' AND A.ASSET_SUBTYPE = D.IT_SUBTYPE) |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | SERIAL_ID |
Character(20) | VARCHAR2(20) NOT NULL | Serial ID |
| 2 | IT_GRP_ID |
Character(11) | VARCHAR2(11) NOT NULL | Group Id |
| 3 | DESCR | Character(30) | VARCHAR2(30) NOT NULL | Description |
| 4 | GRP_OWNER_ID | Character(11) | VARCHAR2(11) NOT NULL | Group Owner Id |
| 5 | SFTWR_TITLE | Character(50) | VARCHAR2(50) NOT NULL | Software Title |
| 6 | 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. |