[TowerFast]

After installing BES express I realized that some of the IT policies I had in place are not available in the BES express. I was looking for some SQL queries that would allow me to keep track of users who have installed 3rd party apps, personal email accts, and changed their GPS location.

Thanks

--Chris

[knottyrope]

There are only 35 rules, making it a fairly open system.

If you really need them you could install a trial of BES 5 and export the policies and import to express. You still can not edit them in express though.

[TowerFast]

Would I be able to delete the policies once they are created? Also, could i import my policies from the BPS 4.1 server I am retiring?

[BBExpert]

3rd party apps - You can use select * from SyncDeviceMgmt to get all the raw data and filter it out. Probably TableID 6 or 2 could provide more help. However, I would suggest you to look at BESUserAdminClient for 3rd party apps - more information at InsideBES.blogspot.com

- personal email accounts
again from same table under TableId 6 - You may need to filter it again.

- GPS - Can you explain further.

[TowerFast]

I am looking for a way to determine if their GPS location is set to "on". We use Field Force Manager for fleet tracking and if the GPS location is turn off, we cannot track the users location. GPS location is set to E911 only by default.

[knottyrope]

Originally Posted by TowerFast

Would I be able to delete the policies once they are created? Also, could i import my policies from the BPS 4.1 server I am retiring?

Delete yes.

Can knot export from BPS to BES express5, sorry.

[BBExpert]

Look for in table SyncLBS. probably you may find something.