Mapping Applications to Servers - Excel sheet
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
2 hours ago
Hi ,
We are having the challenge in Mapping Applications to servers
The data is being provided in the Excel sheet , can anyone please provided the solutions if you have faced similar kind of scenario . Specifically need guidance for one->Many mapping
#CMDB
- Labels:
-
Data Acquisition
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
2 hours ago
To address one-to-many mapping of applications to servers using Excel data, consider these best practices and solutions:
-
Import Excel Data Using Transform Maps: Use ServiceNow's platform capability to import your Excel data. Transform maps allow you to map applications to the appropriate tables, including one-to-many relationships between applications and servers. This is a standard approach for bringing in external data and establishing relationships 1️⃣.
-
Tag-Based Service Mapping: If your Excel data includes tags (such as application names or server identifiers), leverage tag-based service mapping. Open the Key Value table in ServiceNow to review available tags, then use the Application Service wizard to create application services based on these tags. This method efficiently maps multiple applications to servers 2️⃣.
-
Dynamic CI Groups and Application Signatures: For environments lacking consistent tags, use dynamic CI groups and application signatures. Subject Matter Experts can define application signatures (e.g., specific processes or parameters), and ServiceNow Discovery can identify these across servers, enabling automated mapping 2️⃣.
-
Mapping Unmapped Servers: Use the Service Mapping workspace to identify unmapped servers and create application services for them. Review candidate servers, prioritize, and map them to applications to ensure all resources are efficiently utilized 3️⃣.
Recommendations and Best Practices:
- Always validate imported data for accuracy before committing changes.
- Use the CMDB Query Builder for advanced queries and relationship validation.
- Regularly review and update mapping logic as your environment evolves.
- Involve Subject Matter Experts to define accurate application signatures for dynamic mapping.
- Leverage scheduled jobs or run recalculations manually to keep service maps current
