Just incase people are wondering what these Auras are, they simply refer to the switches (and therefore color of the environment) that are needed to reach and open the chests. You do NOT require the lockpicking skill.
(Blue & Normal Aura) Group Heal - After activating the lyrium well (or cube), head out into the room you came from. Instead of going up the stairs, go north to a room with a bunch of skeletons. Return to the switch and deactivate it, then return to that room.
(Blue Aura) Stat Boost - After recruiting Brogan, continue Eastward till you get to a large room with 2 Twisted Sentinels and a Warped Watcher. Kill them and then open the center chest near the Watcher.
(Blue Aura) Flaming Weapons - Same room as the previous, in the Northwestern corner of the room, behind a broken wall with pillars.
(Purple & Green Auras) Tempest & Revival - After activating the purple switch, head to Darions first journal (just a bit past where Brogan was), there will be a door on the Northern wall, go in (you might wish to save). Use the switch in the room ahead, go towards the green switch and fight the Sentinels, once you finish, activate the green switch and open the chests.
(Red Aura) Stat Boost - After activating the red switch, continue till you reach the forge. Once you do, turn right and head North to a staircase leading up to a cave in.