Discovery Testing Tracker
Challenges
Items | Working Session | Concern |
Waiting for ServiceNow to Assign a ServiceNow JEA Engineer | TBD | |
Received Aperture data model | Under Review so we can re-pull data |
Discovery Sandbox Testing
CI Class | Credentials | Owner | Mid-Server Parameters | Discovery Schedule | Issue | Status | Owner | |||
---|---|---|---|---|---|---|---|---|---|---|
Windows | JEA | Torres | Waiting for ServiceNow to assign a ServiceNow JEA engineer | Windows | Hi Ticket - CS4346800 | work in progress Hi Ticket opened | Torres | |||
Linux | Sudo | Braen |
| Linux Test | Braen | |||||
Oracle | Sudo | Dixit | Sudo | Hi Ticket Open CS4339197 Meeting 20190827 | Dixit | |||||
MSSQL | Powershell | Serena | Elvin will have to go into active directory and find the firewall for these IP addresses. He is working on this Waiting for ServiceNow to assign a ServiceNow JEA engineer. | MSSQL 20190820 | Failed to access target system. Please check credentials and firewall settings on the target system to ensure accessibility: Access is denied. (Exception from HRESULT: 0x80070005 (E_ACCESSDENIED)) | yalesand1 Mid-Server can't reach the 11 IP addresses provided; Checking with Elvin | Serena, Morales | |||
Network (Firewall, Switches, Routers) | Kumar | Network Test | IP address requested to be able to scan to Elvin | Kumar | ||||||
Storage | SNMP, Basic Authentication | DeGroat | Storage Test | HI Ticket - CS4343054 | Storage is able to be scanned. Additional Data needs an additional credential | DeGroat | ||||
Vm Ware | Dunlap | Note: Target is blacklisted. No valid credential found for types [SSH Password,SSH Private Key] - Use Vcenter credential | VMWare | Out of range for yalesand1 | ||||||
APERTURE | ||||||||||
Aperture Data | ||||||||||
DEVICE_NAME | varchar | 42 | The name of this device. This is blank for cards. | |||||||
BOTTOM_RACK_UNIT | float | 8 | The Bottom Rack Unit of the device in the Rack. | |||||||
CLIENT | varchar | 25 | Obsolete field. | |||||||
RACK_SPACE_NO | varchar | 25 | Obsolete field. | |||||||
CAGE_SIZE | varchar | 10 | Obsolete field. | |||||||
OBJECT_LOCATION | varchar | 20 | Obsolete field. | |||||||
CATEGORY | varchar | 256 | The category to which the device belongs | |||||||
PARENT_UNIQUE_ID | varchar | 18 | If this device instance describes a card, then this field points to the Parent Unique ID of the containing device. | |||||||
RACK_UNIQUE_ID | varchar | 18 | The unique identifier of the Rack this device is installed in. | |||||||
SPACE_UNIQUE_ID | varchar | 18 | The unique identifier of the Space (Raised Floor Space) where this device is located. | |||||||
PLATFORM | varchar | 50 | The Platform such as Unix, Wintel, Linux, etc for this device | |||||||
RECEPTACLE_TYPE | varchar | 25 | Receptacle type assoicated with the device. | |||||||
DUAL_POWER | varchar | 4 | Inidicates if this device requires redundant power sources | |||||||
NUM_CORDS | varchar | 4 | The number of power cords available on this device. | |||||||
POWER_NEEDS | text | 16 | Describes any special power requirements for this device. | |||||||
OBJECTID_TD | varchar | 18 | The Aperture OBJECTID of the top down visual for this device. | |||||||
ROTATION | float | 8 | The Rotation angle for this device (0,90,180,270) for an FMD. (0,90) if device is an RMD. | |||||||
DEPTH | float | 8 | The Depth of the device as indicated in the DV_MANUFUCATURER_DEVICE_SPECS_T table. | |||||||
OBJECTID_REAR | varchar | 18 | The Aperture OBJECTID of the rear visual for this device. | |||||||
RACK_MOUNT_SIDE | varchar | 10 | Indicates which side of the Rack the device is mounted. Values can be Front or Rear. | |||||||
MOUNT_TYPE | varchar | 50 | Indicates the Mount Type for this device. Values are RACK MOUNT, FLOOR MOUNT, DEVICE MOUNT. This determines how the device can be placed. | |||||||
ASSET_CLASS | varchar | 50 | The Asset Class categorization of this Device Model. This value comes from the symbol library. Values can be Server, Rack/Cabinet, Card, etc. This field is filtered throughout the product. | |||||||
RACK_UNITS | float | 8 | If this device instance describes a Rack, then this field indicates the total Rack Units available in the rack. | |||||||
RACK_INSIDE_HEIGHT | float | 8 | If this device instance describes a Rack, then this field indicates the inside height of the rack. | |||||||
RACK_INSIDE_DEPTH | float | 8 | If this device instance describes a Rack, then this field indicates the inside depth of the rack. | |||||||
RACK_INSIDE_WIDTH | float | 8 | If this device instance describes a Rack, then this field indicates the inside width of the rack. | |||||||
DMZ | varchar | 8 | Indicates if this device is IN or OUTSIDE the DMZ. | |||||||
TERM_SERVER_CONNECT | varchar | 12 | Inidicates if this device requires a terminal server connection. | |||||||
MACHINE_CATEGORY | varchar | 50 | The Machine Category of the device such as Production, Development, QA, etc. | |||||||
MACHINE_TYPE | varchar | 50 | The Machine Type indicates the function of this device. Values can be Domain Server, Application Server, Database Server, etc. | |||||||
DATABASE_TYPE | varchar | 50 | If the Machine Type is Database Server, then this field indicates the name of the database. Values can be Oracle, SQL Server, etc. | |||||||
OS_LEVEL | varchar | 50 | The OS Level of the PLATFORM associated with this device. | |||||||
ALIGNMENT | varchar | 50 | The aligment of the device relative to a Floor Tile or relative to the Rack. | |||||||
OFFSET_X | float | 8 | The Offset X of the device relative to the floor tile or relative to the rack. | |||||||
OFFSET_Y | float | 8 | The Offset Y position of the device relative to the floor. | |||||||
PLACEMENT_GRID | varchar | 12 | The internal Grid Location of the device. This is not user defineable. | |||||||
RACK_START_UNIT | float | 8 | If this device instance describes a Rack, then this field indicates the start rack unit number. Values can be 0 or 1. | |||||||
RU_SCALE_POS | varchar | 10 | If this device instance describes a Rack, then this field indicates if the Rack units are number Top to Bottom or Bottom to Top. | |||||||
RACK_ROW_NAME | varchar | 50 | The Row Name associated with this device or rack | |||||||
VC_VISUAL_PENDING | varchar | 1 | System field to indicate if a visual needs to be generated. | |||||||
VC_VISUAL_PENDING_COUNTER | float | 8 | System field for managing generation of drawings | |||||||
VC_VISUAL_STATUS | int | 4 | System field for managing generation of drawings | |||||||
ASSET_SUB_CLASS | varchar | 50 | The Asset Sub Class associated with the Asset Class of the device. This is a more granualr categorization of the device (i.e. Asset Class = CARD, Asset Sub Class = BLADE SERVER) | |||||||
OP_VOLTS | float | 8 | The operating voltage of this device | |||||||
PSUPPLY_N | int | 4 | The minimum number of active power supplies in the device | |||||||
PSUPPLY_MAX | int | 4 | The Maximum number of power supplies in the device - Obsolete. | |||||||
POWER_FACTOR | float | 8 | The Power Factor assigned to the device | |||||||
WATTS | float | 8 | The Watts of the device as indicated in the DV_MANUFACTURER_DEVICE_SPECS_T table. | |||||||
VOB_ID | uniqueidentifier | 16 | The VOB_ID of this device instance | |||||||
MLOAD_WATTS | float | 8 | The Measured Load (in Watts) of this device. | |||||||
PARENT_VOB_ID | uniqueidentifier | 16 | If this device instance describes a card, then this field points to the Parent VOB_ID of the containing device. | |||||||
RACK_VOB_ID | uniqueidentifier | 16 | The VOB_ID of the rack where this device is located. | |||||||
SPACE_VOB_ID | uniqueidentifier | 16 | The VOB_ID of the Space (Raised Floor Space) where this device is located. | |||||||
CONTAINER | varchar | 20 | The Container location for this device. Values can be RAISED FLOOR, RACK FRONT, RACK REAR, SLOT | |||||||
LOCATION | varchar | 20 | Location of the device within the container. Values can be RAISED FLOOR - CEILING, WALL, FLOOR SURFACE, OTHER. RACK FRONT/REAR - INSIDE, TOP, BOTTOM, LEFT, RIGHT, LEFT RAIL, RIGHT RAIL, OTHER. SLOT - INSIDE | |||||||
VISUAL | char | 1 | Y/N. Internal use. If Y, a visual is created for the device. | |||||||
PLACE_COMMENT | varchar | 100 | A placement comment to describe any unique characteristics of the device placement. | |||||||
VC_REBUILD_TOPDOWN | varchar | 1 | Indicates if the Topdown visual should be rebuilt | |||||||
VC_REBUILD_FRONT_ELEVATION | varchar | 1 | Indicates if the Front Elevation visual should be rebuilt | |||||||
VC_REBUILD_REAR_ELEVATION | varchar | 1 | Indicates if the Rear Elevation visual should be rebuilt | |||||||
FMD_PARENT_VOB_ID | uniqueidentifier | 16 | The FMD relative to which this device has been placed, if applicable. | |||||||
GHOST_VOB_ID | uniqueidentifier | 16 | Internal use, used during a device move. | |||||||
ORIGINAL_VOB_ID | uniqueidentifier | 16 | Internal use, used during a device move. | |||||||
SLOT_VOB_ID | uniqueidentifier | 16 | If this device instance describes a card, then this field indicates the SLOT VOB_ID this card is associated with. | |||||||
SLOT_UNIQUE_ID | varchar | 18 | If this device instance describes a card, then this field indicates the slot unqiueid this card is associated with. | |||||||
VC_VISUAL_PENDING_TIMESTAMP | datetime | 8 | An internal use field for Visual Generator. | |||||||
MLOAD_WATTS_OVERRIDE_DEFAULT | varchar | 1 | Indicates if the default was overridden for this field | |||||||
OP_VOLTS_OVERRIDE_DEFAULT | varchar | 1 | Indicates if the default was overridden for this field | |||||||
PSUPPLY_N_OVERRIDE_DEFAULT | varchar | 1 | Indicates if the default was overridden for this field |