How We Turned an
Excel-Based IT Registry into
a Governed ServiceNow CMDB
What was
the goal?
Key details
Public Sector / EU Agency
IT Governance / CMDB
European Union
European Union agency responsible for food safety
Our client is an autonomous European Union agency responsible for independent scientific advice and risk assessment in the area of food and feed safety.
What was the challenge?
Before the project, the IT Registry was managed as a manually maintained Excel spreadsheet. While this supported basic tracking, it no longer met the organization’s governance and reporting needs.
The registry was disconnected from ServiceNow, which limited visibility, automation, role-based access, and integration with other IT processes. Ownership verification was handled manually, and data quality depended on manual updates with no enforced validation.
The organization also lacked structured relationships between IT systems and business processes, making it harder to support governance, continuity planning, and risk assessment.
How did we help?
SPOC supported the client in migrating the IT Registry into ServiceNow CMDB and configuring a governed model for ongoing management.
- Business Application Configuration
We extended the Business Application table with fields required for governance, reconfigured choice fields, implemented mandatory data policies, and introduced role-based access controls.
- Data Migration and Relationship Mapping
We migrated IT system records from Excel into ServiceNow using Import Sets and Transform Maps. We also migrated support vendor data, imported business process records, and established relationships between business applications and business processes.
- Automation and Data Quality Controls
We implemented automation for Business Criticality calculation based on confidentiality, integrity, and availability. Data policies were configured to enforce completion of key governance fields for active records.
- Documentation and Administrator Training
We prepared user, technical, and functional documentation, and delivered training for the IT Registry administrator to support everyday operations and future enhancements.
What were the results?
The IT System Catalogue was moved from Excel into ServiceNow CMDB as structured Business Application records. The client gained a centralized IT Registry with automated ownership review, enforced data quality, automatic business criticality calculation, and formal relationships between IT systems and business processes.
What was the impact?
The implementation helped the client:
ServiceNow Areas/Modules
Work with
ServiceNow
Trusted Advisors
ServiceNow partner,
you’re in the right place.
