Is It Possible To Find Subnet ID Associated With An IP/Mask?

k_barton

Hi Everyone,

I have searched all over the forums, as well as SWQL Studio, and I can't see to find any information on whether or not it's possible to find the subnet ID/network when given an IP/mask.

For example: A node has an IP address 10.10.10.1 with mask /24. Does there exist a SWQL variable where it would return the subnet ID/network of 10.10.10.0?

Thanks!

mesverrum

SQL/SWQL doesn't have a native function for converting masks between cidr and binary formats.  When I've had to do this I've either exported lists out to excel and used a function there or written one directly in powershell scripts.