This discussion has been locked. The information referenced herein may be inaccurate due to age, software updates, or external references.
You can no longer post new replies to this discussion. If you have a similar question you can start a new discussion in this forum.

Application Dependencies mapping Report SAM6.6.1

Recently we have installed on SAM 6.6.1 in to our platform.Can we have Application Dependencies mapping report which is current environment?.
Application Dependencies polling overview

SAM uses two types of polling to collect application dependency data:

Application Dependency polling is enabled by default but Connection Quality polling is not. See Enable Connection Quality polling.

  • Application Dependency polling: Discovers and monitors the following types of connections:
    • Application to application, in a typical client/server process monitored by SAM
    • Application to node, with a server process not currently monitored by SAM
    • Node to application, with a client application process not monitored by SAM
It will be useful for us to explaining in front of Application owner.
In below SWQL to extend to include additional columns are [CPU,P-MEM,V-MEM,R-IOPS,W-IOPS,Port,Lat.Pkt Loss]
SELECT d.Name as [Dependency]
,Replace(Replace(Replace(d.ParentEntityType,'Orion.',''),'SEUM.','WPM '),'s','') as [Parent Type] --,d.ParentEntityType as [Parent Type]
,case when np.caption is not null then np.Caption
when ap.Name is not null then ap.Name
when gp.Name is not null then gp.Name
--when tp.Name is not null then tp.Name
when ip.FullName is not null then ip.FullName
end as [Parent]
,Replace(Replace(Replace(d.ChildEntityType,'Orion.',''),'SEUM.','WPM '),'s','') as [Child Type] --,d.ChildEntityType as [Child Type]
,case when nc.caption is not null then nc.Caption
when ac.Name is not null then ac.Name
when gc.Name is not null then gc.Name
--when tc.Name is not null then tc.Name
when ic.FullName is not null then ic.FullName
end as [Child]
FROM Orion.Dependencies d
left join orion.nodes np on np.Uri=d.ParentUri --Nodes
left join orion.nodes nc on nc.Uri=d.ChildUri
left join orion.apm.Application ap on ap.Uri=d.ParentUri --Applications
left join orion.apm.Application ac on ac.Uri=d.ChildUri
left join orion.Groups gp on gp.Uri=d.ParentUri --Groups
left join orion.Groups gc on gc.Uri=d.ChildUri
--left join orion.seum.Transactions tp on tp.Uri=d.ParentUri --Transactions
--left join orion.seum.Transactions tc on tc.Uri=d.ChildUri
left join orion.npm.Interfaces ip on ip.Uri=d.ParentUri --Interfaces
left join orion.npm.Interfaces ic on ic.Uri=d.ChildUri
order by d.Name

Please refer the attached screen which we are seeking.

Thanks

Suresh