cgrinton
Thank you,
it worked, though the data was populated in the dbo.aduser in FNMSinventory, this data was not populated into the dbo.ActiveDirectoryUsers as the compliance reader for some reason did not run automatically. Further to your input, i went ahead and ran compliancereader.exe from the dotnet bin and that worked like a charm.
Thanks a ton for the quick response.
Regards
Bhanu