Video Screencast Help
Symantec Appoints Michael A. Brown CEO. Learn more.

user mode machines from the Database

Created: 09 Sep 2012 • Updated: 14 Sep 2012 | 3 comments
This issue has been solved. See solution.

Can someone share the SQL query to identify the clients in user mode from the database?

 

Comments 3 CommentsJump to latest comment

Ashish-Sharma's picture

For finding the computer in usermode in the database you can use following SQL command
SELECT [POLICY_MODE] FROM [sem5].[dbo].[SEM_CLIENT] WHERE [POLICY_MODE] = 0 

 

Check this thread

https://www-secure.symantec.com/connect/forums/find-all-clients-usermode

 

Note :If your Issue will be resolved don't forgot Mark a Solution

Thanks In Advance

Ashish Sharma

 

 

SOLUTION
Mithun Sanghavi's picture

Hello,

You can use the below SQL query to switch the user from to computer mode.

update SEM_CLIENT set [POLICY_MODE] =1 where [POLICY_MODE] = 0

For more on sql queries, check this Thread: 

https://www-secure.symantec.com/connect/forums/sql-querys-database

Hope that helps!!

Mithun Sanghavi
Senior Consultant
MIM | MCSA | MCTS | STS | SSE | SSE+ | ITIL v3

Don't forget to mark your thread as 'SOLVED' with the answer that best helped you.

sankareyes's picture

Hi,

Thanks, the above suggestions helped.

Sankar