Hi All,
I have a list of hundreds of server with multiple applications on them. I want to lookup and list all servers with the same application on them but also want to identify server dependencies which occur through additional applications on the server. Hopefully this example will explain what I am trying to achieve.
<tbody>
</tbody>
SVFRA1 has ForeFront on it so it has a dependency to SVFRA5 BUT
SVFRA5 also has LatencyMon on it which means that SVFRA1 also has a dependency to SVFRA2 (has LatencyMon on it).
SVFRA2 has Wireshark on it which means SVFRA1 has a dependency with SVFRA3 (has Wireshark on it).
For each server I am trying to get a list of which servers it is dependent on.
I can create a lookup that lists all servers with ForeFront on it but I haven't been able to create this list of expanding dependencies.
Just as a bit of background: when a server is migrated to another datacenter you need to consider which other servers must be migrated with it due to applications on the server relying on databases or file shares from multiple servers.
Does someone know of a way to solve this problem using formulas or even VBA?
Cheers folks,
Ian
I have a list of hundreds of server with multiple applications on them. I want to lookup and list all servers with the same application on them but also want to identify server dependencies which occur through additional applications on the server. Hopefully this example will explain what I am trying to achieve.
Servername | Application | Application | Application | Application |
SVFRA1 | ForeFront | MS SQL | NetBackup | |
SVFRA2 | WinPcap | Wireshark | MS SQL | LatencyMon |
SVFRA3 | Emulex | PageGate | Wireshark | Solarwinds |
SVFRA4 | SharePoint | CMTrace | ||
SVFRA5 | ForeFront | BGInfo | LogParser 2 | LatencyMon |
<tbody>
</tbody>
SVFRA1 has ForeFront on it so it has a dependency to SVFRA5 BUT
SVFRA5 also has LatencyMon on it which means that SVFRA1 also has a dependency to SVFRA2 (has LatencyMon on it).
SVFRA2 has Wireshark on it which means SVFRA1 has a dependency with SVFRA3 (has Wireshark on it).
For each server I am trying to get a list of which servers it is dependent on.
I can create a lookup that lists all servers with ForeFront on it but I haven't been able to create this list of expanding dependencies.
Just as a bit of background: when a server is migrated to another datacenter you need to consider which other servers must be migrated with it due to applications on the server relying on databases or file shares from multiple servers.
Does someone know of a way to solve this problem using formulas or even VBA?
Cheers folks,
Ian