Learn how to a build a cloud-first strategyRegister Now

x
?
Solved

Sophos Sql commands need to expand

Posted on 2007-10-04
1
Medium Priority
?
456 Views
Last Modified: 2008-01-09
Hi,

I know some of the Sophos commands.Do any one knows for a way to make more of these commands.

osql -S .\sophos -E -d sophos -q "delete from computersanddeletedcomputers where name = "computername""

osql -E -S \ -d -Q "Select ComputersAndDeletedComputers.Name from Groups, ComputerGroupMapping, ComputersAndDeletedComputers where Groups.Name = 'groupname' and Groups.ID = ComputerGroupMapping.GroupID and ComputersAndDeletedComputers.ID = ComputerGroupMapping.ComputerID" -o C:\groupname.txt


Any idea's about these Sophos commands and does any one know more of these command .

Regards
Sharath
0
Comment
Question by:bsharath
1 Comment
 
LVL 27

Accepted Solution

by:
ptjcb earned 2000 total points
ID: 20015933
You are using osql
http://www.di-mgt.com.au/osqlUtility.htm

The
 -S .\sophos
means the local server instance name sophos.

0

Featured Post

NEW Veeam Backup for Microsoft Office 365 1.5

With Office 365, it’s your data and your responsibility to protect it. NEW Veeam Backup for Microsoft Office 365 eliminates the risk of losing access to your Office 365 data.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Containers like Docker and Rocket are getting more popular every day. In my conversations with customers, they consistently ask what containers are and how they can use them in their environment. If you’re as curious as most people, read on. . .
This post contains step-by-step instructions for setting up alerting in Percona Monitoring and Management (PMM) using Grafana.
In this video, Percona Solution Engineer Rick Golba discuss how (and why) you implement high availability in a database environment. To discuss how Percona Consulting can help with your design and architecture needs for your database and infrastr…
In this video, Percona Solutions Engineer Barrett Chambers discusses some of the basic syntax differences between MySQL and MongoDB. To learn more check out our webinar on MongoDB administration for MySQL DBA: https://www.percona.com/resources/we…

810 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question