Hi John thx for...

the solution proposed by John/Louis does the trick and I'm able to query data for each end point. Thx again for all the help.

All,

thx again for all the help much appreciated.

All, thx for the quick solution one thing I forgot to mention how would I also include the column that shows the # machines this patchgroup got deployed?

pgroup ...

hi,

that is what I wanted, thx very much for quick response, appreciated.

Hi,

the filter criteria should be following maybe it was not clear in my question

Machine has 1 IP Address ==> return that address even if it's '192.168.%'

Machine has > 1 IP...

I did find solution to my problem, using the for xml.

Query

SELECT

column1,

(SELECT COLUMN2 + '; ' FROM #test_table B WHERE B.column1 =...

It's only 1 column, I would like to concatenate the output from the various columns, using "|" as separator.

Main idea is to have everything returned in 1 row.

Thx for the info, I do have follow-up question

the 2nd query does acutally use function to return rows and that should also be populated with the info from first query

Your...

I've managed to create 2 queries that retrieve the data I need

--Query 1: Return machines with 1 IPAddress

select MachineId, MAX(IPAddress) as IPAddress from @IPInfo

group by MachineID

having COUNT(MachineID) = 1

--Query...

Correct I only want to exclude these IP Addresses if machine has > 1 IP Address.

if I have machine with 1 IP Address and it's inside the exclusion range, ...

Perfect, that did the trick, thx very much for all the help.