Video Screencast Help
Search Video Help Close Back
to help

user mode machines from the Database

Created: 09 Sep 2012 | Updated: 14 Sep 2012 | 3 comments
sankareyes's picture
sankareyes
0 0 Votes
Login to vote
This issue has been solved. See solution.

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

 

Discussion Filed Under:
, , , ,

Comments 3 Comments • Jump to latest comment

Ashish-Sharma's picture
Ashish-Sharma
user mode machines from the Database - Comment:09 Sep 2012 : Link

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

SEPM Knowledgebase Documents  

 

SOLUTION
+1
Login to vote
  • Actions
Mithun Sanghavi's picture
Mithun Sanghavi Symantec Employee Technical Support Accredited
user mode machines from the Database - Comment:10 Sep 2012 : Link

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
Symantec Technical Support Engineer, SEP
MIM | MCSA | MCTS | STS | ITIL v3

Twitter: @mithun_sanghavi

Don't forget to mark your thread as 'SOLVED' with the answer that best helps you.<&a

+2
Login to vote
  • Actions
sankareyes's picture
sankareyes
user mode machines from the Database - Comment:14 Sep 2012 : Link

Hi,

Thanks, the above suggestions helped.

Sankar

0
Login to vote
  • Actions