Instead of using 0-9, just use the wildcard char (*) - e.g "Like *.*.*.203"
Tried it on mine and it worked just fine.
I had already tried that and the LANDesk query came back as no results found. If I use:
It returns results, but the results are from all matching octets. Any other thoughts?
are you using Oracle? The original poster is, and I'm wondering if this is one of those things that may work well with Microsoft's SQL, since Oracle does sometimes things differently (which was quite an "oh" educational moment) ... could be one of those instances.
LANDesk EMEA Technical Lead
1 of 1 people found this helpful
Sorry to reply to an old post, but I was poking around trying to do something similar and wanted to let you know what I found.
It seems that the query function on Oracle databases uses the Like operator which only offers two wildcard options, percent (%) and underscore (_) instead of the
REGEXP_LIKE function which supports regular expressions. (%) will match any number of characters including zero characters. (_) will match any single character.
To return machines matching the last octet as you were attempting to do, you would need to use this query on Oracle systems:
"Computer"."Network"."TCPIP"."Address" Like "____________203"
I also observed that queries created in LANDesk seem to include (%) before and after the value so queries for a string will match the occurence even if the data has additional blank characters stored.
No, I am still working on this. Late response is welcome! This worked for queries such as the one I am looking at for IP addresses where I know it will be 3 characters (___.___.___.203) in the octet. I will be doing more testing and if my other testing does not have issue with "%" wildcards... possibly specifically with periods. If it all pans out, I will consider this answered and will post accordingly.
Sorry for the (extremely) late confirmation on this. Using ___.___.___.203 did the trick. Curious that I am still unable to get a general wildcard to work, however. Thanks for the help.