Welcome to the new Schneider Electric Community

It's your place to connect with experts and peers, get continuous support, and share knowledge.

  • Explore the new navigation for even easier access to your community.
  • Bookmark and use our new, easy-to-remember address (community.se.com).
  • Get ready for more content and an improved experience.

Contact SchneiderCommunity.Support@se.com if you have any questions.

Close
Invite a Co-worker
Send a co-worker an invite to the Exchange portal.Just enter their email address and we’ll connect them to register. After joining, they will belong to the same company.
Send Invite Cancel
84686members
354048posts

report on how many perforated floor are installed on a space

EcoStruxure IT forum

A support forum for Data Center Operation, Data Center Expert, and EcoStruxure IT product users to share knowledge on installation, configuration, and general product use.

DCIM_Support
Picard
Picard
0 Likes
5
172

report on how many perforated floor are installed on a space

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)

5 Replies 5
DCIM_Support
Picard
Picard
0 Likes
3
172

Re: report on how many perforated floor are installed on a space

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
Picard
Picard
0 Likes
0
172

Re: report on how many perforated floor are installed on a space

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
Picard
Picard
0 Likes
0
172

Re: report on how many perforated floor are installed on a space

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
Picard
Picard
0 Likes
0
172

Re: report on how many perforated floor are installed on a space

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
Picard
Picard
0 Likes
0
172

🔒 Closed

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