I need create filter In NS7 who show me computer from selected IP addresses.
Normal
0
21
false
false
false
PL
X-NONE
X-NONE
MicrosoftInternetExplorer4
I need create filter In NS7 who show me computer from selected IP addresses.
I create SQL in MS database console like :
SELECT [IP Address], [Host Name]
FROM Inv_AeX_AC_TCPIP
WHERE ([IP Address] between N'10.255.0.0' and N'10.255.0.255')
This sql show computer name and his IP address from range 10.255.0.0. to 10.255.0.255
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 :
Filter saved with an invalid filter definition query. Please ensure the first column returned from the query is of type GUID.
I was try create this in query developer but I lost my patient for this utility.
Please help.
Michał Matukin
Professional Services Department
CompFort Meridian Polska Sp. z o.o.
Al.Jerozolimskie 65/79
00-697 Warszawa
Comments
You could check out the
You could check out the posting at http://www.altirigos.com/vbulletin/notification-se... . While that is for subnet, the same DB table is used for IP address and the query would be easy to modify.
Jesse Kozikowski
Aspirus, Inc.
That query is an excellent one
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).
Jim Harings
HP Enterprise Services
1st Rule of Connect Club: Mark the post that helped you the most as a 'solution'. 2nd Rule of Connect Club:You must talk about Connect club.
Would you like to reply?
Login or Register to post your comment.