11 Replies Latest reply on Feb 22, 2018 12:33 PM by Andrew Waters

Associating network device dependencies to BAI instances

Neal Meagher Feb 21, 2018 3:13 PM

Share This:

I have query that associates hosts to BAI instances. Im not able to Associate network device dependencies. Not sure how to write that into query

search BusinessApplicationInstance

show name as bai_name,

hash(key) as bai_key_hash,

key as bai_key,

description as bai_description, type as bai_type, version as bai_version,

hash(#AggregateSoftware:HostedSoftware:Host:Host.key) as host_key_hash,

#AggregateSoftware:HostedSoftware:Host:Host.hostname as host_hostname,

#InterfaceOfDevice:DeviceInterface:DeviceWithInterface:NetworkDevice.name as "Network Device Name",

#AggregateSoftware:HostedSoftware:Host:Host.name as host_name,

#SoftwareContainer:SoftwareContainment:ContainedSoftware:BusinessApplicationInstance.key as containedbai_key,

hash(#SoftwareContainer:SoftwareContainment:ContainedSoftware:BusinessApplicationInstance.key) as containedbai_key_hash,

hash(#Dependant:Dependency:DependedUpon:BusinessApplicationInstance.key) as dependedonbai_key_hash

1. Re: Associating network device dependencies to BAI instances

Andrew Waters Feb 22, 2018 1:23 AM (in response to Neal Meagher)

How are you deciding network devices are associated with BAIs? I suppose you could follow the relationship

#AggregateSoftware:HostedSoftware:Host:Host.
#DeviceWithInterface:DeviceInterface:InterfaceOfDevice:NetworkInterface.
#EdgeDevice:NetworkLink:EdgeClient:NetworkInterface.
#InterfaceOfDevice:DeviceInterface:DeviceWithInterface:.name
1 of 1 people found this helpful
Like Show 0 Likes(0)

Actions
2. Re: Associating network device dependencies to BAI instances

Neal Meagher Feb 22, 2018 8:47 AM (in response to Andrew Waters)

I was trying to associate BAI to host, then host to Network device
Like Show 0 Likes(0)

Actions
3. Re: Associating network device dependencies to BAI instances

Neal Meagher Feb 22, 2018 9:55 AM (in response to Andrew Waters)

I tried this. Also build out similar

#AggregateSoftware:HostedSoftware:Host:Host.#DeviceWithInterface:DeviceInterface:InterfaceOfDevice:NetworkInterface.#InterfaceOfDevice:DeviceInterface:DeviceWithInterface:NetworkDevice.name as 'Name'

Doesnt set a value
Like Show 0 Likes(0)

Actions
4. Re: Associating network device dependencies to BAI instances

Andrew Waters Feb 22, 2018 10:21 AM (in response to Neal Meagher)

Is there edge connectivity - if you look at the Host does it say it is connected to the network device?
Like Show 0 Likes(0)

Actions
5. Re: Associating network device dependencies to BAI instances

Neal Meagher Feb 22, 2018 10:42 AM (in response to Andrew Waters)

All these servers/hosts which sit under BAI have network connectivity.
Like Show 0 Likes(0)

Actions
6. Re: Associating network device dependencies to BAI instances

Andrew Waters Feb 22, 2018 10:49 AM (in response to Neal Meagher)

That is not what I asked. Do they show as connected to NetworkDevice on the Host page. If they don't then there is no relationship to follow to a NetworkDevice. (Discovery has not determined the a Host is connect to specific NetworkDevice(s))
1 of 1 people found this helpful
Like Show 0 Likes(0)

Actions
7. Re: Associating network device dependencies to BAI instances

Neal Meagher Feb 22, 2018 10:51 AM (in response to Andrew Waters)

Without looking at all hosts. I did look at a good portion and they all have network device connectivity under the host page (network interfaces). This query doesnt show any connection
Like Show 0 Likes(0)

Actions
8. Re: Associating network device dependencies to BAI instances

Neal Meagher Feb 22, 2018 11:05 AM (in response to Neal Meagher)

When I run my script take the output and run report "show Network Device Dependencies" against the query result. It shows all connected network devices.
Like Show 0 Likes(0)

Actions
9. Re: Associating network device dependencies to BAI instances

Andrew Waters Feb 22, 2018 12:02 PM (in response to Neal Meagher)

If you are talking about key expression you wrote that will not work because you are missing the EdgeClient:NetworkLink:EdgeDevice:NetworkInterface relationship.
1 of 1 people found this helpful
Like Show 0 Likes(0)

Actions
10. Re: Associating network device dependencies to BAI instances

Neal Meagher Feb 22, 2018 12:18 PM (in response to Andrew Waters)

Got this to work

search ModelDefinition where state = 'published' traverse Definition:Maintainer:Element: processwith show
name,
hash(key) as bai_key_hash,
key as bai_key,
hash(#AggregateSoftware:HostedSoftware:Host:Host.key) as host_key_hash,
#AggregateSoftware:HostedSoftware:Host:.name as 'Hosts', #AggregateSoftware:HostedSoftware:Host:Host.#DeviceWithInterface:DeviceInterface:InterfaceOfDevice:NetworkInterface.#EdgeClient:NetworkLink:EdgeDevice:NetworkInterface.name as 'Network Interface/Connected Device'
1 of 1 people found this helpful
Like Show 0 Likes(0)

Actions
11. Re: Associating network device dependencies to BAI instances

Andrew Waters Feb 22, 2018 12:33 PM (in response to Neal Meagher)

You do not need the processwith
1 of 1 people found this helpful
Like Show 0 Likes(0)

Actions

Go to original post

Communities

Communities

Associating network device dependencies to BAI instances

1. Re: Associating network device dependencies to BAI instances

2. Re: Associating network device dependencies to BAI instances

3. Re: Associating network device dependencies to BAI instances

4. Re: Associating network device dependencies to BAI instances

5. Re: Associating network device dependencies to BAI instances

6. Re: Associating network device dependencies to BAI instances

7. Re: Associating network device dependencies to BAI instances

8. Re: Associating network device dependencies to BAI instances

9. Re: Associating network device dependencies to BAI instances

10. Re: Associating network device dependencies to BAI instances

11. Re: Associating network device dependencies to BAI instances

Actions

More Like This