report on how many perforated floor are installed on a space

[DCIM_Support]

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

(CID:140712870)

[DCIM_Support]

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]

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]

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]

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.