Limiting Windows reports to Nodes in a Group

Hey All,

Is there a way natively in reports to limit the report to nodes that are in certain groups, while keeping the full report options as if you are reporting on a node?

That's the data I need, however under select the object you are going to report on, I want to limit the report to certain nodes, in set groups.

I know can you limit the Nodes through other methods like custom properties etc, but I really just need a way to limit based on the group it's in.

So for example I want the full inventory report for Nodes that are in group LON-MGMT

Thanks in advance

Find more posts tagged with

sam

Reporting

Windows

report

Accepted answers

All comments

christopher.t.jones123

@grantallenby you'd have to do a custom SWQL query to get it, but its relatively straightforward. The below query should get you started all you have to do is define the cm.ContainerID to the group ID of the group containing all the nodes you want, then make sure that you add the columns in that you want in the select statement.

SELECT TOP 1000 n.caption, n.ip, n.AssetInventory.ServerInformation.OperatingSystem
FROM Orion.Nodes N
join Orion.ContainerMembers CM  on n.Nodeid = cm.MemberPrimaryID and cm.EntityDisplayName = 'Node'
where cm.ContainerID =

grantallenby

Hey,

Thank you for helping, much appreciated.

Sadly it does limit it but it then basically gives me the group variables in reports. So I still can't get any of the information I need.

I need all of the node variables selectable whilst limiting it to a group or groups.

grantallenby

These are the only 3 variable options it gives me.

grantallenby

Right so beacuse the "Nodes" that the groups are made up of are the virtual machines and not the windows node its where these get convoluted.

So I have LDN-TEST1 in a group for example but its the VMware entity and not the Windows entity of the same node. So maybe it would be possible if I remade th groups using the windows version of the same node, however that kind of defeats the point. Got to love Solarwinds and the million of different variables.

I ended up talking to a colleague and going off of cluster ID, it's not quite the same level of filter that we wanted with using the pre made groups, but it's close enough.

SO this is what we are using now. Who would have thought it would have got this complex

SELECT TOP 1000 n.Caption, n.Vendor, n.MachineType, n.AssetInventory.ServerInformation.OSVersion, n.VCenter.VMwareProductName, n.vcenter.VMwareProductVersion, n.VCenter.BuildNumber, n.VirtualMachine.GuestName as [VMware OS tag set at creation]--, n.AssetInventory.Software.Name

, CASE

WHEN n.vendor = 'windows' then concat(n.MachineType, ' ', n.AssetInventory.ServerInformation.OSVersion)

WHEN n.vendor = 'VMware Inc.' then concat(n.VCenter.VMwareProductName, ' ', n.vcenter.VMwareProductVersion,' ', n.VCenter.BuildNumber)

WHEN n.vendor = 'unknown' then n.VirtualMachine.GuestName

else 'error'

end as [Version]

, n.AssetInventory.WindowsUpdates.OptionalCount, n.AssetInventory.WindowsUpdates.ImportantCount, n.AssetInventory.WindowsUpdates.OptionalCount+n.AssetInventory.WindowsUpdates.ImportantCount as [Total Updates Due]

FROM Orion.Nodes n

where n.VirtualMachine.Host.Cluster.ClusterID in (13, 12)

--and n.AssetInventory.Software.Name like ''

order by n.vendor desc, n.MachineType desc, n.caption desc