mrt3385 ✭✭✭

Yes, it does. I'm trying to understand what the calculation is. 

What error do you get when trying to add the individual node?

Hang on....is there a specific formula or matching that needs to occur somewhere? Are there specific keywords? Based on what you pointed out, I changed up my query: SELECT TOP 1000 c.ContainerID, c.DetailsUrl, c.Name, c.StatusDescription AS GroupStatus, c.Status AS GroupStatusNumber, c.Members.DisplayName, SI.StatusName,…

Hello, Any idea how to get this to work with a linked or joined table? My goal is to be able to show the member status as well as the group status. I do get the right status for GroupStatus (via the dropdowns), but I cannot get the status dropdown for member. Here is my query: SELECT TOP 1000 c.ContainerID, c.DetailsUrl,…

Thanks for your reply and explanation Produces no results. That's been my experience with anything where I filter on the ancestorDisplayNames column unfortunately. 

hello, table in question is the Orion.Container table. You're right, even though it says System.String, there are [] brackets after. Much different than the other standard strings.

thanks. what tables would i start from?

this helped with my onprem and OCI oracle instances, thank you!

 a millions thanks!!! this did work. Two more questions if you please; -How would I filter the count based on values in the name of the entry in the members table? For example, I have switches and routers named differently, and would like to get counts for each of those. - I added some more columns to the select statement…