Auto comparison of device records and ping sweep data
We have a requirement wherein we need to compare the device records in the existing device application with that of the data received from pingsweep information of nCircle.
i.e. A device IP and hostname is generated through Pingsweep and provided in a .csv format to us. Now system should compare this IP with the existing device IP records within Device application. Incase the device application record has an IP which is not present in the .csv file, system should trigger a notification to IT group and also at the same time change the device status from "Active" to "Validate"
The primary key for device application is tracking id (i.e. device ID)
can you ase suggest some approach. for new device identification, I am doing this through archer data feed and trigger notification.
but how do I compare the .csv file data records with existing records and change the device status and also at the same time trigger notifications to IT group members ?
Any approach/ idea/ suggestions will be highly appreciated .Thank you
Based on your requirements I can layout a plan for a Data Feed that might work for you.
- Map the IP Address in your source file to the IP Address in the Devices application you want to compare. There should be no need to map any other fields.
- Set the IP Address as your key field in the Key Fields tab.
- Since you do not want to create new records in the target application then uncheck the Create option in the Archive/Update tab.
- Select the Set Value option in the Archive Options tab. Select the Device Status as your field and the value of Validate as your value.
- You should be able to setup your notification template so that notifications are only sent out when the Device Status is set to Validate.
The Set Value in the Archive Options will set the Device Status to Validate for every record in the target application that was not found in the source file. It uses the key field to do the comparison so by setting the IP Address to the key field you will be comparing the IP Addresses in the source file to the IP Address in the target application. Also since the key field is the only field mapped no records that were found in the source file will be created or updated in your target application.
This should get your started.
Thank you so much for your prompt response. This is really a good suggestion.
While I have configured the data feed accordingly. Will now do some testing with sample records. Incase I come across any issues/ concerns will write back.
But ideally this should work fine. its one / two scenarios ...that I have to ponder a bit.