We are looking for a way to find all the users on our Google Apps domain / network that have enabled Chrome Offline Google Mail. Apparently this is not possible through the Google Apps Control Panel or the APIs. So I am looking at other options. I have been able to figure out a method to find all the Windows machines on the company network that have the Chrome Offline Google Mail enabled. I am querying the Chrome Database.db (located in C:\Documents and Settings\{username}\Local Settings\Application Data\Google\Chrome\User Data\Default\databases\) to retrieve the location of the OfflineMailUsers Database. Then I query the OfflineMailUsers DB to get a list of the Google Accounts that have enabled Chrome Offline Google Mail on that machine: C:\>sqlite3.exe "C:\Documents and Settings\{username}\Local Settings\Application Data\Google\Chrome\User Data\Default\databases\Databases.db" "select id, origin, name from databases WHERE name='OfflineMailUsers'" 15|https_mail.google.com_0|OfflineMailUsersC:\>sqlite3.exe "C:\Documents and Settings\{username}\Local Settings\Application Data\Google\Chrome\User Data\Default\databases\https_mail.google.com_0\15" "SELECT email from users"my.email@gmail.comsaqib.n.ali@domain.tldNow I need to post the query results from the second command to a centralized Database. This way we will be able to enumerate all the machines/users that have enabled Chrome Offline Google Mail on our domain / network. This is a rather cumbersome method, but seems like it is the only way to collect the data we are looking for. If you know of a alternate way, please email me |