Sophos Sql commands need to expand

Posted on 2007-10-04
Last Modified: 2008-01-09

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 .

Question by:bsharath
    1 Comment
    LVL 27

    Accepted Solution

    You are using osql

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


    Write Comment

    Please enter a first name

    Please enter a last name

    We will never share this with anyone.

    Featured Post

    Find Ransomware Secrets With All-Source Analysis

    Ransomware has become a major concern for organizations; its prevalence has grown due to past successes achieved by threat actors. While each ransomware variant is different, we’ve seen some common tactics and trends used among the authors of the malware.

    Over the years I have built up my own little library of code snippets that I refer to when programming or writing a script.  Many of these have come from the web or adaptations from snippets I find on the Web.  Periodically I add to them when I come…
    Creating and Managing Databases with phpMyAdmin in cPanel.
    Illustrator's Shape Builder tool will let you combine shapes visually and interactively. This video shows the Mac version, but the tool works the same way in Windows. To follow along with this video, you can draw your own shapes or download the file…
    Polish reports in Access so they look terrific. Take yourself to another level. Equations, Back Color, Alternate Back Color. Write easy VBA Code. Tighten space to use less pages. Launch report from a menu, considering criteria only when it is filled…

    779 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

    Need Help in Real-Time?

    Connect with top rated Experts

    13 Experts available now in Live!

    Get 1:1 Help Now