Video Screencast Help
Give us your opinion and win with Symantec! Please help us by taking this survey to tell us about your experience with Symantec Connect, so that we can continue to grow and improve.  Take the survey.

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
Associate Security Architect

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