Hi List, I am on ARS 7.1.0 p003, AIE 7.1.0 p003 and CMDB 2.1.0 p3 on a SQL 2005 Database Server
AIE pulls data from SMS 2003 Service Pack 2 and updates the data into CMDB. The initial Load went on fine without any issues. Picked up only the Server data from SMS as per the configuration. When i run the exchange after this initial load, it picks up all the data in source as per the data query (only server data) and creates any new records or updates all the records in CMDB; wherein it should update only those records that have been modified in the source after the last update from SMS to CMDB was done. In the CI class mappings; I set the following options : Update record only if checksum for mapped field has changed - YEs Calculate and store checksum in 'tmpSMSCheckForUpdate' Retrieve Source records - Only new or updated since last transfer Last modified timestamp in source - 'TIMESTAMP' field from SMS. This is the default setting that is recommended for updating existing CMDB records which have been modified in the source. But when i run this exchange and the DB Trace on; the query picks up all the records and not just the modified records from last data load. Is this the way it should be done or am i doing something wrong here? Is this something you have encountered? What is the way around this? Am also looking at an alternate solution where after the initial load of data, I can update the External Data Query to filter the data and give me only the updated records. -- Thanks Satya _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are"
