Adding Environmental Sensors to Asset Manager with the Export and Import Functions
Entering Environmental Sensors into the Asset Manager User ConsoleUse the Asset Manager user console to configure a few environmental sensors that you will later export as a CSV file (spreadsheet). This spreadsheet will then serve as a template to which you can add the rest of your environmental sensors.
Environmental sensor tags must be assigned to an “Asset” in Asset Manager. To add a new asset (sensor), perform the following steps:
1. In User Console > Tag Management > Manage Tags,right-click on the tag to be assigned in the far right column and then select New Asset.
2. Select the appropriate Asset Type to assign to the tag.
NOTE: In this example, you are adding a Temperature-Humidity sensor and are therefore choosing Temperature – Humidity as the Asset Type.
3. Complete all of the following information:
· Name: Common descriptor that must be unique for the Asset. Typically pre-pending a type designator (TempHum), then a location descriptor will suffice. In the example below, this temperature sensor/asset is going to be located at the “Top” of “Rack 1” in the Austin Data Center’s Row 1.
· Asset Tag: Depending on the method used to get to this screen, this field may be pre-populated. If not, simply start typing the Tag ID of the tag and select the appropriate Tag ID from the dynamic list presented.
· Asset Location: This field is used to tell Asset Manager where the tag will reside, physically, and is designated using the “Location” hierarchy configured earlier. In this example the Rack in which this temperature sensor/asset is physically installed is selected.
· Lock Location: For non-mobile assets, such as environmental sensors, selecting this check box is important, as their location should not be modified after deployment.
· Temp Sensor Application: This pull-down allows the software to designate how this sensor is deployed, in this example on an IT Cabinet/Rack.
· Airflow Position: This field designates if the sensor is in the front or back of the cabinet/rack, in this case, the front (i.e. “Intake”)
· Rack Position: Designates the “Top”, “Middle”, or “Bottom” placement of the sensor on the front of the rack door, in this example, “Top” of the door.
Exporting Environmental Sensor Data
After successfully installing and configuring a base collection of tags and a single reader and configuring Asset Manager to display and report on RCI metrics for a couple of racks in a row, follow the instructions in this section to export a template based on the sensors with attributes that you have already configured.
NOTE: If you are still doing installations and configurations for the pilot, skip this section of the document.
You will use the exported template, a CSV file, and augment it with the rest of your tags. To export a template, follow these instructions.
1. Go to User Console > Assets > Manage Assets.
2. Click the Export button.
3. Dot the radio button next to Export all asset attributes and then click Export CSV.
4. Save the File or open it with a spreadsheet program that reads CSV files, e.g., Microsoft Office (as seen below).
The spreadsheet will look similar to the following:
5. Highlight all of the cells and then double-click the line between the first two columns to expand all the columns wide enough to read all of the cell values.
NOTE: A vast majority of the columns will not be required for our purposes, so after deleting those columns, the remaining spreadsheet columns “A” through “M” will result.
Below are screenshots and descriptions of the columns you’ll use.
NOTE: The screenshot has been cut in half and enlarged.
Column A = “class” will in almost all cases be “entity”
Column B = “type” is the type of sensor/asset, in this case a “TEMPERATURE_HUMIDITY” sensor
Column C = “guid” is the unique identifier for this object in the system. If you are editing an existing asset, leave this field intact with the exact data from the export. If a new instance of the sensor is being imported/created, delete the contents of the cell.
Column D = “retired” is almost always “false” as the asset will not be retired
Column E = “deletable” is almost always “true”, in the event the asset needs to be removed in the future
Column F = “RACK_POSITION” is the place in the cabinet, vertically, where the asset will be physically deployed. Options are “Top”, “Middle”, or “Bottom”
Column G = “TEMP_PROFILE” is the designation of the type of application for the sensor. A sensor in a rack/cabinet would be “IT_RACK_SENSOR”, conversely, a “ROOM_SENSOR” can also be specified for an application outside of a cabinet, or for more general temperature/humidity deployments
Column H = “$aLocation” is the physical “Location” where the sensor is to be deployed. In rack environments it will be the Rack itself, for rooms, it would be the room.
NOTE: To find the exact location id, consult the “Admin Console -> Locations/Rules/Maps -> Locations & Rules” and navigate to the respective, desired location. The “ID:” of that location (highlighted in yellow below) is the exact string that will be used in this column
Column I = “AIRFLOW_POSITION” is the designation of whether the sensor is in the front (“RACK_INTAKE_TEMPERATURE”) or rear (“RACK_EXHAUST_TEMPERATURE”) of the cabinet/rack
Column J = “$aLockLocation” In environmental monitoring solutions, this is almost always set to “TRUE” as environmental sensors are stationary
Column K = “$aName” is the field that designates how the asset/sensor will be seen in the software. In the graphic above it corresponds to the “Name:” field
Column L = “$aDescription” is a generic string used to provide descriptive commentary about the sensor, it is not required
Column M = “$aAssetTag” is the 6 digit Group Code and 8 digit ID of the Tag, also known as the “Asset Tag” or “Tag ID”
6. Add the rest of your tags and their attributes to the spreadsheet and then click Save.
NOTE: If you are warned by Excel about CSV incompatibilities, click Yes and continue.
7. Import the populated spreadsheet by going to User Console > Assets > Import Assets.
8. Navigate to the file you created and click the Upload button.