Hi @lycollicott,
In DMC, Instance page is using dmc_instances_view_default_search(1)
macro and this is the query.
| inputlookup dmc_assets | search search_group = $group$ | mvcombine search_group | join type=outer peerURI [| rest splunk_server=local /services/search/distributed/peers | rename title as peerURI ] | join type=outer peerURI [| rest splunk_server=local /services/server/info | eval peerURI = "localhost" | eval status = "Up"] | join peerURI [| `dmc_get_instance_roles` ] | eval status = if(status == "Up", status, "Unreachable") | eval Action = serverName." ".role | eval OS = os_name | eval ram = round(physicalMemoryMB / 1024, 2)." GB" | fields serverName, machine, role, OS, numberOfCores, ram, version, status, Action | sort status, serverName | rename serverName as Instance, machine as Machine, role as Role, numberOfCores as "Cores", ram as RAM, version as Version, status as Status
Are you looking for this?
Hi @lycollicott,
In DMC, Instance page is using dmc_instances_view_default_search(1)
macro and this is the query.
| inputlookup dmc_assets | search search_group = $group$ | mvcombine search_group | join type=outer peerURI [| rest splunk_server=local /services/search/distributed/peers | rename title as peerURI ] | join type=outer peerURI [| rest splunk_server=local /services/server/info | eval peerURI = "localhost" | eval status = "Up"] | join peerURI [| `dmc_get_instance_roles` ] | eval status = if(status == "Up", status, "Unreachable") | eval Action = serverName." ".role | eval OS = os_name | eval ram = round(physicalMemoryMB / 1024, 2)." GB" | fields serverName, machine, role, OS, numberOfCores, ram, version, status, Action | sort status, serverName | rename serverName as Instance, machine as Machine, role as Role, numberOfCores as "Cores", ram as RAM, version as Version, status as Status
Are you looking for this?
Perfect! Switch this to an answer and I'll accept it.