workspace-insights
Workplace service delivery insights including space utilization, service request patterns, facility management metrics, and desk booking analytics
Happy Technologies LLC · 已有静态检查记录
安装与使用
运行命令前先阅读来源与依赖说明。复制命令不会自动安装或执行。
npx skills add Happy-Technologies-LLC/happy-platform-skills --skill workspace-insights技能说明
name: workspace-insights version: 1.0.1 description: Workplace service delivery insights including space utilization, service request patterns, facility management metrics, and desk booking analytics author: Happy Technologies LLC tags: [admin, workplace, facilities, space-utilization, desk-booking, service-delivery, analytics, wsd] platforms: [claude-code, claude-desktop, chatgpt, cursor, any] tools: mcp: - SN-Query-Table - SN-Get-Record - SN-Natural-Language-Search rest: - /api/now/table/wsd_space - /api/now/table/wsd_reservation - /api/now/table/wsd_floor - /api/now/table/wsd_building - /api/now/table/fm_facility_request - /api/now/table/sc_req_item - /api/now/table/incident - /api/now/table/cmn_location - /api/now/table/task_sla - /api/now/table/sys_user native: - Bash complexity: intermediate estimated_time: 20-40 minutes
Workplace Service Delivery Insights
Overview
This skill covers generating insights and analytics for Workplace Service Delivery (WSD) in ServiceNow:
- Analyzing space utilization rates across buildings, floors, and zones
- Tracking desk and room booking patterns to optimize space allocation
- Monitoring facility management service request volumes, categories, and SLA compliance
- Identifying peak usage periods and underutilized spaces for capacity planning
- Generating facility management KPI dashboards with trend analysis
- Producing actionable recommendations for workplace optimization
When to use: When reviewing workplace space efficiency, planning office reconfigurations, analyzing facility service delivery performance, optimizing hot-desking strategies, or preparing workplace analytics for real estate decisions.
Prerequisites
- Roles:
wsd_admin,facility_manager,admin, orworkspace_admin - Plugins:
com.snc.workplace_service_delivery(Workplace Service Delivery),com.snc.facility_management(Facility Management) recommended - Access: Read access to
wsd_space,wsd_reservation,wsd_floor,wsd_building,fm_facility_request,sc_req_itemtables - Data: Active workplace spaces with reservation and sensor data
- Related Skills:
reporting/executive-dashboardfor dashboard creation,reporting/trend-analysisfor trend analytics
Procedure
Step 1: Retrieve Building and Floor Inventory
Establish the baseline of available workspace inventory.
MCP Approach:
Tool: SN-Query-Table
Parameters:
table_name: wsd_building
query: active=true
fields: sys_id,name,location,total_floors,total_capacity,address,time_zone,operational_status
limit: 50
Tool: SN-Query-Table
Parameters:
table_name: wsd_floor
query: building=[BUILDING_SYS_ID]^active=true
fields: sys_id,name,building,floor_number,total_spaces,available_spaces,floor_plan
limit: 20
REST Approach:
GET /api/now/table/wsd_building
?sysparm_query=active=true
&sysparm_fields=sys_id,name,location,total_floors,total_capacity,address,time_zone,operational_status
&sysparm_display_value=true
GET /api/now/table/wsd_floor
?sysparm_query=building=[BUILDING_SYS_ID]^active=true
&sysparm_fields=sys_id,name,building,floor_number,total_spaces,available_spaces
&sysparm_display_value=true
Step 2: Analyze Space Utilization
Query space records to calculate utilization metrics.
MCP Approach:
Tool: SN-Query-Table
Parameters:
table_name: wsd_space
query: floor.building=[BUILDING_SYS_ID]^active=true
fields: sys_id,name,space_type,capacity,floor,is_reservable,status,amenities
limit: 500
Space Type Classification:
| Space Type | Typical Capacity | Bookable | Metrics Focus |
|---|---|---|---|
| Desk | 1 | Yes | Occupancy rate, booking frequency |
| Meeting Room | 2-20 | Yes | Booking rate, no-show rate, avg duration |
| Phone Booth | 1 | Yes | Utilization rate, peak hours |
| Collaboration Zone | 4-12 | Sometimes | Foot traffic, usage duration |
| Hot Desk | 1 | Yes | Daily booking rate, user diversity |
| Private Office | 1-2 | No | Assignment vs actual presence |
Step 3: Analyze Reservation Patterns
Query booking data to identify usage patterns.
MCP Approach:
Tool: SN-Query-Table
Parameters:
table_name: wsd_reservation
query: space.floor.building=[BUILDING_SYS_ID]^start_date>=javascript:gs.daysAgo(30)^ORDERBYstart_date
fields: sys_id,space,user,start_date,end_date,state,check_in_time,check_out_time,no_show,duration
limit: 2000
REST Approach:
GET /api/now/table/wsd_reservation
?sysparm_query=space.floor.building=[BUILDING_SYS_ID]^start_date>=javascript:gs.daysAgo(30)
&sysparm_fields=sys_id,space,user,start_date,end_date,state,check_in_time,check_out_time,no_show,duration
&sysparm_limit=2000
&sysparm_display_value=true
Key Metrics to Calculate:
| Metric | Formula | Target |
|---|---|---|
| Booking Rate | Booked hours / Available hours | >60% |
| No-Show Rate | No-show reservations / Total reservations | <15% |
| Peak Utilization | Max concurrent bookings / Total capacity | Track trend |
| Avg Booking Duration | Sum of durations / Count of bookings | Varies by type |
| Unique Users/Week | Distinct users with bookings per week | Track growth |
| Advance Booking Lead | Avg days between creation and start | 1-3 days typical |
Step 4: Identify Peak and Off-Peak Patterns
Analyze time-based usage patterns for capacity planning.
MCP Approach:
Tool: SN-Query-Table
Parameters:
table_name: wsd_reservation
query: space.floor.building=[BUILDING_SYS_ID]^start_date>=javascript:gs.daysAgo(30)^state=completed
fields: start_date,end_date,space.space_type,space.floor
limit: 5000
Aggregate by day of week and hour to build a heatmap:
=== UTILIZATION HEATMAP ===
Building: [name]
Period: Last 30 days
Mon Tue Wed Thu Fri
08:00 35% 42% 68% 55% 28%
09:00 62% 71% 88% 7
阅读完整来源 ↗