How to create a AM Query returning computers based on range of IP Address ?
Example :
How to return all computers inside these ranges of IP Address :
10.11.12.1 - 10.11.12.126 and 10.11.12.129 - 10.11.12.254
CA Client Automation
2- Select Computers and click OK
3- Click on Advanced Argument
4- In "Add Advanced Argument" dialog box, put :
Pseudo text : IP Address between 10.11.12.1-10.11.12.126 and 10.11.12.129-10.11.12.254
Table : -Any-
Additional WHERE clause :
select object_uuid from ca_agent where agent_type=1 and parsename(ip_address,4)=10 and parsename(ip_address,3)=11 and parsename(ip_address,2)=12 and ((parsename(ip_address,1)>=1 and parsename(ip_address,1)<=126) OR (parsename(ip_address,1)>=129 and parsename(ip_address,1)<=254))
Remark : The SQL query should be put in a single line without carriage return.
5- Click OK