Technical Document Importing Physical Groups and Device Association from a CSV file Abstract This whitepaper provides information about importing and creating physical groups using a CSV file.
Revisions Revisions Date Description October 2020 Initial release Acknowledgements Author: Rishi Mukherjee The information in this publication is provided “as is.” Dell Inc. makes no representations or warranties of any kind with respect to the information in this publication, and specifically disclaims implied warranties of merchantability or fitness for a particular purpose. Use, copying, and distribution of any software described in this publication requires an applicable software license.
Table of contents Table of contents Revisions............................................................................................................................................................................. 2 Acknowledgements ............................................................................................................................................................. 2 Table of contents ...............................................................................................
Executive summary Executive summary Use this whitepaper to import your existing device groups into OpenManage Enterprise Power Manager as physical groups to replicate the devices and their locations in your data center and, leading to an effective rack management system.
Requirement 1 Requirement Creation of physical groups hierarchies for existing devices in a data center can be a time-consuming activity and hence, Power Manager facilitates importing the devices as physical groups through a csv file. The logic of creation of physical groups is defined in the following section. When there are device entries in the CSV file, the script performs an additional validation check to confirm that the devices are discovered in OpenManage Enterprise.
Requirement Data Center No No No No Room Yes No No No Aisle Yes Yes No No Rack Yes Yes Yes No Apart from the general considerations mentioned in Table 2 and 3, following are the CSV specific checks on validating the format of the file at the time of import: • • There is reference of only one device per row. Rack name, and capacity are the mandatory fields. - • Each physical group and their siblings in a physical group hierarchy are identified by a unique name.
Requirement ,,,Rack1,100,24,4,G72SQ12 ,,Aisle4,Rack4,100,24,4,CQ2RG52 • Configure the console specific parameters in configfile.properties. Below is a sample for your reference: [consoleaccessdetails] ipaddress = 100.96.33.208 username = admin password = linux 1.2 Usage Download the following files to the local system from https://github.com/dell/OpenManageEnterprise/tree/master/Plugins/Power%20Manager/Import%20Physical%20Hierarchy/Python • • • createphysicalgroups.py physicalgroups.csv configfile.
Requirement The individual elements in a row in the predefined order are: ,,,,,,, Below is a sample for your reference: DC1,Room1,Aisle1,Rack1,100,42,1,GMJ3GL2 DC1,Room1,Aisle1,Rack1,100,42,3,BN1JR42 DC1,,Aisle1,Rack1,100,21,4,D4QBBS2 DC1,,,Rack1,100,21,10,6SM09X2 ,Room1,Aisle1,Rack1,100,48,1,BCF5GY1 ,Room1,,Rack1,100,48,5,H2CHH32 ,,Aisle1,Rack1,100,48,4,DR6R7C2 ,,,Rack1,100,24,4,G72SQ12
Requirement AISLE Description Name of the Aisle Value Types String Required No Constraints Created if non-existent. RACK Description Name of the Rack Value Types String Required Yes Constraints Created if non-existent. RACK_CAPACITY and RACK_POWER must be provided for a rack entry.
Requirement RACK_SLOT_NUMBER Description Specifies the rack slot number where the device will be associated Value Types Number Required Yes Constraints Must be unique to avoid error in device association DEVICE_SERVICE_TAG 10 Description Service tag of the device that will be associated with rack slot Value Types String Required Yes Constraints Must be a valid service tag of the on-boarded devices in Open Manage Enterprise to avoid error in device association Importing Physical Groups and
Behavior 2 Behavior The script processes only one physical group, the defined hierarchy and device to rack group association at a time. Any grouping structure specified for the device is created only if they do not exist. Ensure that the devices that are mentioned in the CSV file and meant for associating with the rack group in a defined slot are discovered and on-boarded in Open Manage Enterprise using the discovery task before executing the script.
Conclusion 3 Conclusion Using this whitepaper, create physical groups hierarchies via a CSV file by running an automated script.
Technical Support and Resources 4 Technical Support and Resources • • 4.1 Related Resources • • • • • 13 Dell.com/support is focused on meeting customer needs with proven services and support. To watch quick and short videos about handling the PowerEdge server components, visit the QRL video website. Knowledge Base for Dell EMC OpenManage Enterprise HTML Knowledge Base for Dell EMC OpenManage Enterprise Power Manager and Power Center HTML Dell EMC OpenManage Enterprise Power Manager Version 1.
