Hello,
I have a SQL query:
select sys.name0, Creation_Date0, os.Caption0,WINSPrimaryServer0, WINSSecondaryServer0 from v_R_System sys
join v_GS_NETWORK_ADAPTER_CONFIGUR NAC on NAc.ResourceID=sys.ResourceID
join v_GS_OPERATING_SYSTEM os on os.ResourceID=sys.ResourceID
join v_FullCollectionMembership col on col.ResourceID = sys.ResourceID
where
OS.Caption0 like '%server%'
and nac.IPEnabled0='1'
and col.CollectionID = 'UCP00242'
and (NAC.WINSPrimaryServer0 IS NULL)
or NAC.WINSSecondaryServer0 IS NULL)
order by Name0 ASC
and a WQL for the collection
select SMS_R_SYSTEM.ResourceID,SMS_R_SYSTEM.ResourceType,SMS_R_SYSTEM.Name,SMS_R_SYSTEM.SMSUniqueIdentifier,SMS_R_SYSTEM.ResourceDomainORWorkgroup,SMS_R_SYSTEM.Client from SMS_R_System
inner join SMS_G_System_NETWORK_ADAPTER_CONFIGURATION on SMS_G_System_NETWORK_ADAPTER_CONFIGURATION.ResourceID = SMS_R_System.ResourceId where
SMS_R_System.OperatingSystemNameandVersion like "%server%" and SMS_G_System_NETWORK_ADAPTER_CONFIGURATION.IPEnabled = 1 and SMS_G_System_NETWORK_ADAPTER_CONFIGURATION.WINSPrimaryServer is null and SMS_G_System_NETWORK_ADAPTER_CONFIGURATION.WINSSecondaryServer is null
I have a result of 216 items in SQL and 192 only in the WQL. I noticed in SQL there are some servers which appear multiple time… but I am not sure how to identify them versus the collection which is displaying only 1 item per server.
Thanks,
Dom
