NM, once again i'm impatient. the following code will return the display name, smtp, bes instance, version of app and their device model...
Code:
SELECT U.DisplayName, U.MailboxSMTPAddr, C.ServiceName, S.ModuleVersion, D.ModelName
FROM UserConfig U INNER JOIN SyncDeviceMgmt S ON U.Id = S.UserConfigId, ServerConfig C, SyncDeviceMgmtSummary D
WHERE (S.ModuleName = 'net_rim_bb_qm_lcs') and C.Id = U.ServerConfigId and U.ID = D.UserConfigID
i need this so that when we finally install LCS CWA, i need to push the new app (LCS version) to everyone who has it installed (Windows Messenger version). i also need to know who has a storm to give them the special version.