Symantec Management Platform (Notification Server)

  I need create filter In NS7 who show  me computer from selected IP addresses.<o p=""></o>

 

<o p=""> </o>

I create SQL in MS database console like :<o p=""></o>

<o p=""> </o>

SELECT     [IP Address], [Host Name]<o p=""></o>

FROM         Inv_AeX_AC_TCPIP<o p=""></o>

WHERE     ([IP Address] between N'10.255.0.0' and N'10.255.0.255')<o p=""></o>

<o p=""> </o>

<o p=""> </o>

This sql show computer name and his IP address from range 10.255.0.0. to 10.255.0.255<o p=""></o>

<o p=""> </o>

Ok sql work in MS database but not work in NS7 filter raw creator when I copy this SQL and save I receive some error like :<o p=""></o>

<o p=""> </o>

Filter saved with an invalid filter definition query. Please ensure the first column returned from the query is of type GUID. <o p=""></o>

<o p=""> </o>

I was try create this in query developer but I lost my patient for this utility.

Please help.<o p=""></o>

<o p=""> </o>

Regards, <o p=""></o>

Michał Matukin<o p=""></o>

Professional Services Department <o p=""></o>

CompFort Meridian Polska Sp. z o.o. <o p=""></o>

Al.Jerozolimskie 65/79 <o p=""></o>

00-697 Warszawa <o p=""></o>

m_matukin@compfort.pl<o p=""></o>

You could check out the posting at http://www.altirigos.com/vbulletin/notification-server-7/11524-filters-based-subnet.html .  While that is for subnet, the same DB table is used for IP address and the query would be easy to modify.

keep in mind though, the error you see is because you haven't seleced a computer guid field. So in the future always try to include vcomputer.guid or vri.guid in your queries.

(Really Jesse's got the answer for you, but I wanted you to know why you got the error).