ALERT: Some images may not load properly within the Knowledge Base Article. If you see a broken image, please right-click and select 'Open image in a new tab'. We apologize for this inconvenience.

Client Automation - AM Query based on IP Address range

book

Article ID: 133012

calendar_today

Updated On:

Products

CA Client Automation - Asset Management CA Client Automation - IT Client Manager CA Client Automation

Issue/Introduction

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


Environment

Client Automation 12.9 and after

Starting Microsoft SQL Server 2012

Resolution

  1. In DSM Explorer, go under Queries. Right on a folder where the query should be created and select New

 
                

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 

Attachments