Discovery Testing Tracker

Document status
WORK IN PROGRESS
Project ManagerDavid Swanson
Tech leadAllena Kendrick
Technical writersVandana Bansal

Challenges

ItemsWorking SessionConcern
Waiting for ServiceNow to Assign a ServiceNow JEA EngineerTBD
Received Aperture data model Under Review  so we can re-pull data


Discovery Sandbox Testing


CI ClassCredentialsOwnerMid-Server ParametersDiscovery ScheduleIssueStatusOwner
WindowsJEA

Torres


Waiting for ServiceNow to assign a ServiceNow JEA engineer

WindowsHi Ticket - CS4346800

work in progress

Hi Ticket opened

Torres
LinuxSudoBraen

https://yalesandbox.service-now.com/nav_to.do?uri=cmdb_ci_linux_server.do?sys_id=6d5e99011bdf778093463153cd4bcb0f

ServiceNow Change

When Discovery runs dmidecode | cat, it returns garbage.
{"related_data":{"tDataObj":{}}}

This article:
https://community.servicenow.com/community?id=community_question&sys_id=21e8e0b4db903f04fece0b55ca961926
states that a user running London had a very similar issue and resolved it by adding the mid server property “mid.property.ssh.use_snc”When Discovery runs dmidecode | cat, it returns garbage.
{"related_data":{"tDataObj":{}}}

This article:
https://community.servicenow.com/community?id=community_question&sys_id=21e8e0b4db903f04fece0b55ca961926
states that a user running London had a very similar issue and resolved it by adding the mid server property “mid.property.ssh.use_snc”

On the linux side, we made the following changes which are applicable to our entire environment, not just for the ServiceNow sandbox:


Allowed the linux ServiceNow credential – s_svcnow_mid – to run the following commands as sudo without a password:

              '/usr/sbin/dmidecode',

              '/sbin/dmidecode',

              '/usr/sbin/lsof',

              '/sbin/lsof',

              '/usr/bin/fdisk -l',

              '/usr/bin/multipath -ll',

              '/usr/sbin/dmsetup table *',

              '/usr/sbin/dmsetup table',

              '/usr/sbin/dmsetup ls',

              '/usr/bin/ls',

              '/usr/bin/cat',

              '/bin/stat',

              '/usr/bin/netstat'


Changed /etc/hostname to reflect the fqdn instead of just the short name.


Linux Test

Braen
OracleSudoDixit


https://yalesandbox.service-now.com/nav_to.do?uri=cmdb_ci_db_ora_instance.do?sys_id=cd0372c9db1f33807150132968961915


https://yalesandbox.service-now.com/nav_to.do?uri=cmdb_ci_db_ora_instance.do?sys_id=df59af1ddb5bb3807150132968961933



Sudo

Hi Ticket Open CS4339197

Meeting 20190827

Dixit
MSSQLPowershellSerena

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 20190820Failed 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 ElvinSerena, Morales
Network (Firewall,  Switches, Routers)
Kumar
Network Test
IP address requested to be able to scan to ElvinKumar
StorageSNMP,  Basic AuthenticationDeGroat
Image preview
Storage TestHI Ticket - CS4343054Storage is able to be scanned. Additional Data needs an additional credentialDeGroat
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




















VISTARepository_v650_DB_Model_&_Concepts

Aperture Requirements





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