White Papers

Requirement
5 Importing Physical Groups and Device Association from a CSV file
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. Only after a successful validation, the devices are
added and assigned to a rack in Power Manager. If the devices are not present in OpenManage Enterprise
the devices are ignored.
Example of csv file format (* specifies mandatory field)
Data Center Room Aisle Rack*
Rack
Space
Capacity*
Rack Slot * Device Identifier
DC1
Room1
Aisle1
Rack1
21
1
ServiceTag1
DC1
Room1
Aisle1
Rack1
21
3
ServiceTag5
DC1
Room1
Aisle1
Rack1
21
4
ServiceTag6
DC1
Room2
Aisle1
Rack2
48
1
ServiceTag9
DC1
Room2
Aisle1
Rack2
48
5
ServiceTag10
DC1
Room2
Aisle1
Rack2
48
4
ServiceTag14
DC1
Room2
Aisle1
Rack2
48
10
ServiceTag12
After you import the csv file, the script ensures that the validation checks mentioned below are met before
running the script. If there are any errors, the operation fails with details of the error so that you can rectify
and resume the upload.
Following table depicts the rules while creating a physical group hierarchy.
Rules to create a physical group hierarchy
Physical Group
Allowable Children
Mandatory
Data Center
Room, Aisle, Rack
No
Room
Aisle, Rack
No
Aisle
Rack
No
Rack
Not applicable
Yes
Following table depicts the supported hierarchies for creation and movements of physical groups.
Supported hierarchies for physical groups
Data Center
Room
Aisle
Rack