Endpoint Protection

 View Only
  • 1.  SEP 14 Queries

    Posted Dec 26, 2016 11:46 AM

    1. Can anyone please confirm if there is any maximum size limitiation for the SEPM database backup file that we can restore? As far as I know there isn't one but still wana confirm to avoid any issues during the restore. The size of the backup file is 45GB. Version of SEPM is 12.1.6

    2. I am trying to use the move client utility that is available under the NoSupport folder in SEP 14 Tools to automatically move large number of clients into different groups in SEPM based on different criteria. Can anyone please confirm and provide me the location as where do I need to specify the SEPM SQL DB details?? 

    Appreciate if you can hightlight the place and the syntax. I am specifying it in the below line but for some reasons it is not working.

     

    ------------------------------------------------------------------------------------------------------------------------------------------

    Option Explicit

    '--------------------------------------------------------
    'Set the below values to your database password and username
    '--------------------------------------------------------

    Dim DBUser : DBUser = "sem5"
    Dim DBPass : DBPass = "password123"
    Dim TempGroupName : TempGroupName = "Default Group"

    '--------------------------------------------------------
    'Other settings
    '--------------------------------------------------------

    Dim DomainName : DomainName = "%"
    Dim OnlyCheckClientsInTempGroup : OnlyCheckClientsInTempGroup = False
    Dim MoveClientsToNewDomain : MoveClientsToNewDomain = False
    Dim SilentMode : SilentMode = False
    Dim EnableLogging : EnableLogging = True
    Dim sLogFile : sLogFile = "MoveClients.log"
    Dim ConnectionString : ConnectionString = 172.2.2.x;UID=" & DBUser & ";PWD=" & DBPass

    -------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------



  • 2.  RE: SEP 14 Queries

    Posted Dec 26, 2016 11:56 AM

    There is no documented size limit that I've seen.

    It goes in the MoveClient.vbs file, like you highlighted above.



  • 3.  RE: SEP 14 Queries

    Posted Dec 26, 2016 11:59 AM

    Thanks for the reply brian. Well when I specify the details there I get the error that cannot establish the connection with the database which isn't accurate as everything is open, so it appears that I am missing some syntanx or something or the way I am spcifying these details isn't correct.

    Can you please mention the correct syntax, if I am making some mistake there while specifying those details?

    Appreciate your support. Thanks 



  • 4.  RE: SEP 14 Queries

    Posted Dec 26, 2016 12:21 PM

    Are you using SQL? If so you need to enter in the SQL user and password on the database. The file is already configured you just need to add the credentials. Can you authenticate to the database using the credentials? Did you verify they work?



  • 5.  RE: SEP 14 Queries

    Posted Dec 26, 2016 12:41 PM

    Brian yes I am using SQL. SQL username and password was provided. I added the credentials into the file. I can use the SQL management studio and can login fine with the same credentials to the database. From the SQL side I varified the credentials and they are working fine.

    I don't need to specify the SQL server IP and database name into the file?



  • 6.  RE: SEP 14 Queries
    Best Answer

    Posted Dec 26, 2016 01:11 PM

    You run this on the SEPM. It should find the db automatically.



  • 7.  RE: SEP 14 Queries

    Posted Dec 26, 2016 01:22 PM
      |   view attached

    Dear Brian. Yes I am running it directly on the SEPM. Please refer to the attached screenshot for the error I am getting. 



  • 8.  RE: SEP 14 Queries

    Posted Dec 26, 2016 01:28 PM

    Follow the steps in this article to test the connection from the SEPM:

    http://www.symantec.com/docs/HOWTO80753



  • 9.  RE: SEP 14 Queries

    Posted Dec 26, 2016 01:33 PM

    Hi Brian, it is working now. Much appreciated. Thanks 



  • 10.  RE: SEP 14 Queries

    Posted Dec 26, 2016 01:40 PM

    You're welcome.



  • 11.  RE: SEP 14 Queries

    Posted Dec 26, 2016 02:31 PM

    Observed one more thing that you need to copy the whole MoveClient folder inside the Tools directory under SEPM and run it from their, it works then. If it is executed from any other place on the SEPM machine it gives the above error.