1 of 1 people found this helpful
You will find the answer in [dbo].[IPAM_Group] - FriendlyName and comments field.
Perfect, thank you.
3 of 3 people found this helpful
If you can share the query, that would be great.
This will give you the most interesting parts off that table:
SELECT TOP (1000) [GroupId]
Here is the query I used to find the Scopes with a blank or NULL comments field as their DHCP scope Description. Note, The Comments like '' is two single quotes not a double quotes:
SELECT top 1000
,CONCAT([Address],' /',[CIDR]) AS [Proposed Comments]
Where GroupType like '8' And (Comments is NULL Or Comments like '')