report on how many perforated floor are installed on a space

[DCIM_Support]

This question was originally posted on DCIM Support by nicholas borsetti on 2019-03-11

---

How can i report on how many perforated floor are installed?

(CID:140712870)

[DCIM_Support]

This answer was originally posted on DCIM Support by Greg Sterling on 2019-03-11

---

I do not think there's an easy way to report against floor tiles inside DCO today. In fact I noticed the equipment browser does not list floor tiles. You can however if you have an ETL export database run a query like this 

select * from configuration_item where ci_type = 'PerforatedFloorTile' and ci_room_label = 'RoomName';

To get a list and details of all of the perforated tiles in room RoomName

I didn't investigate is heavy detail but there's also a "perforated-floor-tile" type exposed in the DCO rest api's so it should be possible to identify perforated tiles through rest calls to the asset api's.

I suspect if an actual report is required it may have to be completed through services, or perhaps services could update the inventory report to include floor tiles (not sure that is possible).

Regards

Greg Sterling

(CID:140712892)

[DCIM_Support]

This comment was originally posted on DCIM Support by Ed Tarento on 2019-03-12

---

Hi Greg, I was able to extract servers, pdus and all types of devices via the API except perforated-floor-tile.  Are you able to test pls.  My DCO Offline 8.2.12

"perforated-floor-tile": { "borderWidth": 0, "symbol": "", "red": 150, "green": 150, "blue": 150 },

(CID:140712984)

[DCIM_Support]

This comment was originally posted on DCIM Support by Greg Sterling on 2019-03-12

---

I'm able to query the perforated-tile in REST when I direct query its uuid and when I fetch the room in which the perforated-tile is based and specify the children parameter. Both queries return the tile(s). The asset search api call does not seem to include the tiles.

Regards

GregS

(CID:140713184)

[DCIM_Support]

This comment was originally posted on DCIM Support by Ed Tarento on 2019-03-13

---

Thanks Greg,  Will you pls log a case to have the search adjusted?

Cheers

Ed

(CID:140713483)

[DCIM_Support]

This question is closed for comments. You're welcome to start a new topic if you have further comments on this issue.