How To Retrieve Rack-Enclosure-Bay Values In A Run Script Task
Article: 183
Applies to: All releases
To retrieve Rack-Enclosure-Bay values for the blade on which the job is executing, in a Run Script task running for Windows:
set rack=%#*"SELECT physical_rack.real_name FROM computer INNER JOIN physical_bay ON computer.computer_id = physical_bay.computer_id INNER JOIN physical_enclosure ON physical_bay.enclosure_id = physical_enclosure.enclosure_id INNER JOIN physical_rack ON physical_enclosure.rack_id = physical_rack.rack_id AND computer.computer_id = {ID}"%
set enclosure=%#*"SELECT physical_enclosure.real_name FROM computer INNER JOIN physical_bay ON computer.computer_id = physical_bay.computer_id INNER JOIN physical_enclosure ON physical_bay.enclosure_id = physical_enclosure.enclosure_id INNER JOIN physical_rack ON physical_enclosure.rack_id = physical_rack.rack_id AND computer.computer_id = {ID}"%
set bay=%#*"SELECT physical_bay.real_name FROM computer INNER JOIN physical_bay ON computer.computer_id = physical_bay.computer_id INNER JOIN physical_enclosure ON physical_bay.enclosure_id = physical_enclosure.enclosure_id INNER JOIN physical_rack ON physical_enclosure.rack_id = physical_rack.rack_id AND computer.computer_id = {ID}"%
NOTE: Each set line needs to be typed in as one line.
|
Printable version
