Facilities Inventory: Exporting a List of Rooms to Excel
Last updated: July 9, 2024
Back to Facilities Inventory Documentation
Back to Common Facilities Inventory Tasks
There is not a mechanism in the facilities inventory system to export a list of rooms to Excel. To do so, use the Oracle Analytics Server (OAS) report called "Room Information".
- Login to the Oracle Analytics Server (OAS) web page at https://oasprod.db.cornell.edu/analytics. All users of the facilities inventory are granted access to these reports.
- In the upper-right corner of the screen, from the blue menu bar, select "Dashboards".
- From the choices in the drop-down menu, in the "IWMS" category, select "Facilities Inventory".
- From the list of reports under the new menu bar, select "Room Information".
- In the left sidebar, under the "Org" category, click on the small downward-facing triangle to the right of the word "Select" to expand the choices.
- Uncheck the checkbox to the left of the word "Select".
- Search the list to put a checkbox next to the KFS org name corresponding to the relevant KFS orgs.
- Scroll down to the bottom of the left sidebar.
- Click "Apply".
- When the list of rooms has appeared, scroll all the way down to the bottom of the list. Select "Export".
- There are a number of choices of format. The "Data" > "Excel" option works well.
Note that the resulting list of rooms will contain multiple instances of any rooms in cases where the room is shared by more than one department or when the room has more than one function code.
These lists are always one business-day old. They do not contain any changes made on the day you export the list. Those changes appear in the report the following business day.