Skip to content
OpenAgentSkill
Browsing is open · Catalog captured 2026-11-21 · Automatic updates and account services are paused.
Data & analytics

workspace-insights

Workplace service delivery insights including space utilization, service request patterns, facility management metrics, and desk booking analytics

Happy Technologies LLC · Static checks on file

Installation

Read the source and dependencies before running a command. Copying does not install or execute anything.

npx skills add Happy-Technologies-LLC/happy-platform-skills --skill workspace-insights

About this skill


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, or workspace_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_item tables
  • Data: Active workplace spaces with reservation and sensor data
  • Related Skills: reporting/executive-dashboard for dashboard creation, reporting/trend-analysis for 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 TypeTypical CapacityBookableMetrics Focus
Desk1YesOccupancy rate, booking frequency
Meeting Room2-20YesBooking rate, no-show rate, avg duration
Phone Booth1YesUtilization rate, peak hours
Collaboration Zone4-12SometimesFoot traffic, usage duration
Hot Desk1YesDaily booking rate, user diversity
Private Office1-2NoAssignment 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:

MetricFormulaTarget
Booking RateBooked hours / Available hours>60%
No-Show RateNo-show reservations / Total reservations<15%
Peak UtilizationMax concurrent bookings / Total capacityTrack trend
Avg Booking DurationSum of durations / Count of bookingsVaries by type
Unique Users/WeekDistinct users with bookings per weekTrack growth
Advance Booking LeadAvg days between creation and start1-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
Read the complete source ↗