Endpoint Protection

 View Only

  • 1.  SQL installation

    Posted Jan 25, 2013 05:53 AM

    SQL server 2008 installation..?



  • 2.  RE: SQL installation

    Posted Jan 25, 2013 06:02 AM

    Hi,

    Please follow the below steps for the same and let know if it helps you.

    http://blog.sqlauthority.com/2008/06/12/sql-server-2008-step-by-step-installation-guide-with-images/

     

    http://experiencing-sql-server-2008.blogspot.in/2008/09/step-by-step-installation-of-sql-server.html

     

    http://www.sqlserverclub.com/essentialguides/how-to-install-sql-server-2008-step-by-step-guide.aspx

     

     

     



  • 3.  RE: SQL installation

    Posted Jan 25, 2013 06:14 AM

    If you need information for installing SEPM with a database on SQL Server please have a look here:

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

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



  • 4.  RE: SQL installation

    Trusted Advisor
    Posted Jan 25, 2013 06:53 AM

    Hello,

    Could you be a little more specific??

    Are you looking forward for assistance to know - 

    1) If the SEP/SEPM is supported on SQL Server 2008?

    If yes, then yes it is supported. Check this Article:

    http://www.symantec.com/business/support/index?page=content&id=TECH163806

    2) Best Practices of SEP installation in SQL server 2008??

    Check this - 

    Best Practices for Installing Symantec Endpoint Protection (SEP) on Windows Servers

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

    3) What are the SQL Server configuration settings ?

    Check these Articles:

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

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

    4) Migrating to Microsoft SQL 2008 from a previous version?

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

    Hope that helps!!


  • 5.  RE: SQL installation

    Posted Jan 28, 2013 04:51 AM
    Hi Team, Is there any query for sep host name?


  • 6.  RE: SQL installation
    Best Answer

    Posted Jan 28, 2013 04:57 AM

    Hello Annie,

    Please let me know if your sql installation problem id resolved or not...? If yes then plz mark as a solutions which articles you helps best.

    and please find the below query for the sep host name and check i hope it will be help you.

     

     
    Use sem5
    SELECT DISTINCT "SEM_AGENT"."DELETED","PATTERN"."VERSION","PATTERN"."PATTERNDATE","SEM_AGENT"."AGENT_VERSION","SEM_CLIENT"."COMPUTER_NAME" "Computer Name", 
    "SEM_COMPUTER"."OPERATION_SYSTEM" "Operation System",dateadd(s,convert(bigint,"SEM_AGENT"."CREATION_TIME")/1000,'01-01-1970 00:00:00') CREATION_DTTM, dateadd(s,convert(bigint,"SEM_AGENT"."LAST_UPDATE_TIME")/1000,'01-01-1970 00:00:00') Lastupdatetime, 
     DATEADD(s, convert(bigint,LAST_SCAN_TIME)/1000, '01-01-1970 00:00:00')"Last Scan Time", 
    "PATTERN"."PATTERNDATE" "Pattern Date", "SEM_CLIENT"."USER_NAME" "User Name",
     "V_SEM_COMPUTER"."IP_ADDR1_TEXT" "IP Address", "IDENTITY_MAP"."NAME" "Group Name"
     FROM   (((("SEM_AGENT" "SEM_AGENT" INNER JOIN "SEM_CLIENT" "SEM_CLIENT" ON (("SEM_AGENT"."COMPUTER_ID"="SEM_CLIENT"."COMPUTER_ID") AND ("SEM_AGENT"."DOMAIN_ID"="SEM_CLIENT"."DOMAIN_ID")) AND ("SEM_AGENT"."GROUP_ID"="SEM_CLIENT"."GROUP_ID")) INNER JOIN "SEM_COMPUTER" "SEM_COMPUTER" ON (("SEM_AGENT"."COMPUTER_ID"="SEM_COMPUTER"."COMPUTER_ID") AND ("SEM_AGENT"."DOMAIN_ID"="SEM_COMPUTER"."DOMAIN_ID")) AND ("SEM_AGENT"."DELETED"="SEM_COMPUTER"."DELETED")) INNER JOIN "PATTERN" "PATTERN" ON "SEM_AGENT"."PATTERN_IDX"="PATTERN"."PATTERN_IDX") INNER JOIN "IDENTITY_MAP" "IDENTITY_MAP" ON "SEM_CLIENT"."GROUP_ID"="IDENTITY_MAP"."ID") INNER JOIN "V_SEM_COMPUTER" "V_SEM_COMPUTER" ON "SEM_COMPUTER"."COMPUTER_ID"="V_SEM_COMPUTER"."COMPUTER_ID" and "SEM_AGENT"."DELETED"=0 and "V_SEM_COMPUTER"."computer_name" in 
    ('2356-w-6001',
    2356-w-6002',
    2356-w-6003',
    2356-w-6004',
    ' 2356-w-6005')
     
     
    Note:- (2356-w-6001 to 2356-w-6005 are the host name of your coputer's, So whenever you run the query the delete the below host name and add your system's host name.)


  • 7.  RE: SQL installation

    Posted Jan 28, 2013 05:04 AM
    Hi Annie, Please check this thread. Here are some Queries https://www-secure.symantec.com/connect/forums/sql-querys-database And please be more specific while Questioning... Regards, Zafar


  • 8.  RE: SQL installation

    Posted Jan 28, 2013 05:05 AM

    Have a look at the SQL database Scheme reference - this may be helpful for you:

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

     

    As well note that you can get logs and reports about the SEPM clients by using logs and reports:

    http://www.symantec.com/business/support/index?page=content&id=HOWTO27271

     

    Here another thread about SQL Queries to SEPMd database:

    https://www-secure.symantec.com/connect/forums/sql-querys-database



  • 9.  RE: SQL installation

    Posted Jan 28, 2013 05:07 AM
    Hi Ambesh, This query is for ?


  • 10.  RE: SQL installation

    Posted Jan 28, 2013 05:14 AM

    Hi All,

    This query for sep host name.

     



  • 11.  RE: SQL installation

    Posted Jan 28, 2013 05:51 AM

    Hi Ambesh,

    Thanks for prompt reply.