2015-02-09 14:29:04.997 THREAD 1 SEVERE: ================== Server Environment =================== 2015-02-09 14:29:04.999 THREAD 1 SEVERE: os.name = Windows Server 2008 R2 2015-02-09 14:29:04.999 THREAD 1 SEVERE: os.version = 6.1 2015-02-09 14:29:04.999 THREAD 1 SEVERE: os.arch = x64 2015-02-09 14:29:05.000 THREAD 1 SEVERE: java.version = 1.7.0_55 2015-02-09 14:29:05.000 THREAD 1 SEVERE: java.vendor = Oracle Corporation 2015-02-09 14:29:05.000 THREAD 1 SEVERE: java.vm.name = Java HotSpot(TM) Client VM 2015-02-09 14:29:05.000 THREAD 1 SEVERE: java.vm.version = 24.55-b03 2015-02-09 14:29:05.000 THREAD 1 SEVERE: java.home = D:\Program Files\Symantec\Symantec Endpoint Protection Manager\jre 2015-02-09 14:29:05.000 THREAD 1 SEVERE: catalina.home = D:\Program Files\Symantec\Symantec Endpoint Protection Manager\tomcat 2015-02-09 14:29:05.000 THREAD 1 SEVERE: java.user = null 2015-02-09 14:29:05.000 THREAD 1 SEVERE: user.language = en 2015-02-09 14:29:05.000 THREAD 1 SEVERE: user.country = GB 2015-02-09 14:29:05.000 THREAD 1 SEVERE: scm.server.version = 12.1.5337.5000 2015-02-09 14:29:05.000 THREAD 1 INFO: Main> Main>> Checking upgrade arguments... Command-line argument is empty. 2015-02-09 14:29:05.000 THREAD 1 INFO: Main> Main>> Server Home = D:\Program Files\Symantec\Symantec Endpoint Protection Manager\tomcat 2015-02-09 14:29:05.215 THREAD 1 INFO: DatabaseUtilities> initDataSource>> Found 12.x driver 2015-02-09 14:29:05.238 THREAD 1 INFO: DatabaseUtilities> initDataSource>> dbport : 2638 2015-02-09 14:29:05.239 THREAD 1 INFO: DatabaseUtilities> initDataSource>> Datasource set in sqlanywhere>>ds:sybase.jdbc4.sqlanywhere.ASADataSource@1b94a21 2015-02-09 14:29:05.243 THREAD 1 INFO: Main> Main>> Database server is Embedded. 2015-02-09 14:29:05.251 THREAD 1 INFO: SemServiceManager> getServiceStatus>> Retrieve status for service SQLANYs_sem5 2015-02-09 14:29:05.319 THREAD 1 INFO: SemServiceManager> getServiceStatus>> The status for SQLANYs_sem5' service is 4 2015-02-09 14:29:05.337 THREAD 1 INFO: Main> Main>> Database server is Embedded. Embedded DB version (before upgrade) is 16.x or above. Testing DB connection... Current time = Mon Feb 09 14:29:05 GMT 2015 2015-02-09 14:29:05.337 THREAD 1 INFO: DatabaseUtilities> testDBConnection>> Testing DB connection using 'DefaultDatabaseConnection' method. Parameters used (needDateFormat: false, isRetryUntilDBUp: false, defaultConnectionMaxRetry: 20) 2015-02-09 14:29:05.421 THREAD 1 INFO: Main> Main>> DB(Embedded) test connection succeeded. Continuing with upgrade process... Current time = Mon Feb 09 14:29:05 GMT 2015 2015-02-09 14:29:05.626 THREAD 1 INFO: Has valid SAV license 2015-02-09 14:29:05.626 THREAD 1 INFO: Info>> No SNAC license file in D:\Program Files\Symantec\Symantec Endpoint Protection Manager\tomcat\etc\license 2015-02-09 14:29:07.108 THREAD 1 INFO: Main> executePreLaunchSteps>> Config schema format is getting upgraded from (schema version from db): 12.1.3.0 2015-02-09 14:29:07.259 THREAD 1 INFO: Saving disaster recovery data to: D:\Program Files\Symantec\Symantec Endpoint Protection Manager\tomcat\..\Server Private Key Backup\recovery_2015-02-09-14-29-07.zip 2015-02-09 14:29:07.310 THREAD 1 INFO: Main> executePreLaunchSteps>> DbVersion: 12.1.3.0 schemaVersionFromDB: 12.1.3.0 isSpm51Mr7: false hasOtherOSAgents: false dbcompanySize: 3 dbConnected: true 2015-02-09 14:29:07.310 THREAD 1 INFO: Main> checkUpgradeFeasibility>> Checking for upgrade feasibility, current schema version = 12.1.5.4, schema version from db = 12.1.3.0 2015-02-09 14:29:07.311 THREAD 1 INFO: VersionToBeSupported: 12.1.3.0 2015-02-09 14:29:07.311 THREAD 1 INFO: SchemaVersion>> isSupported> versionToBeSupported '12.1.3.0 is supported for this release 2015-02-09 14:29:07.321 THREAD 1 INFO: Main> displayOnlineServerListIfAny>> Checking online servers. siteId = 96B58BB1C0A8003401C1991909C89285 2015-02-09 14:29:07.327 THREAD 1 INFO: SELECT CONTENT FROM SYSTEM_STATE WHERE OWNER = '9A680152C0A8003401B67D6A484CEE4D' 2015-02-09 14:29:07.337 THREAD 1 INFO: SYSOUT : Checking onlist status for server localhost 2015-02-09 14:29:07.338 THREAD 1 INFO: SYSOUT : Not checking status. offline status detected 2015-02-09 14:29:07.338 THREAD 1 INFO: SYSOUT : [name=localhost,id=9A680152C0A8003401B67D6A484CEE4D] is offline 2015-02-09 14:29:07.339 THREAD 1 INFO: Main> displayOnlineServerListIfAny>> Checking online servers. Exclude local server id = 9A680152C0A8003401B67D6A484CEE4D 2015-02-09 14:29:07.339 THREAD 1 INFO: Main> displayOnlineServerListIfAny>> Online servers = [] 2015-02-09 14:29:07.340 THREAD 1 INFO: Main> launchMainFrame>> Launching the UI. 2015-02-09 14:29:07.628 THREAD 1 INFO: ServerConfigurationRemediator >> needChooseLaunchServicePort >> ServerVersion.FERRARI_VERSION=12.1.4426.5000 2015-02-09 14:29:07.628 THREAD 1 INFO: ServerConfigurationRemediator >> needChooseLaunchServicePort >> needChooseLaunchServicePort=true serverVersionPreUpgrade=12.1.2015.2015 2015-02-09 14:29:07.658 THREAD 1 INFO: ServerConfigurationRemediator >> needChooseLaunchServicePort >> ServerVersion.FERRARI_VERSION=12.1.4426.5000 2015-02-09 14:29:07.658 THREAD 1 INFO: ServerConfigurationRemediator >> needChooseLaunchServicePort >> needChooseLaunchServicePort=true serverVersionPreUpgrade=12.1.2015.2015 2015-02-09 14:29:07.719 THREAD 1 INFO: isLicenseInstallationValid: sep.slf =true OD file=true 2015-02-09 14:29:07.723 THREAD 1 INFO: MainFrame >> needShowUpgradeDBTasksConfigPanel >> skipping panel because preUpgradeVersion=12.1.2015.2015 2015-02-09 14:29:21.463 THREAD 23 INFO: scm.server.port is found in conf.properties 2015-02-09 14:29:21.463 THREAD 23 INFO: scm.http.port is found in conf.properties 2015-02-09 14:29:21.463 THREAD 23 INFO: scm.webserver.http.port is found in conf.properties 2015-02-09 14:29:21.463 THREAD 23 INFO: scm.webserver.https.port is not found in conf.properties 2015-02-09 14:29:21.463 THREAD 23 INFO: scm.shutdown.port is found in conf.properties 2015-02-09 14:29:21.463 THREAD 23 INFO: scm.console.reporting.https.port is found in conf.properties 2015-02-09 14:29:21.463 THREAD 23 INFO: scm.webservices.port is found in conf.properties 2015-02-09 14:29:21.463 THREAD 23 INFO: scm.iis.http.port is not found in conf.properties 2015-02-09 14:29:21.463 THREAD 23 INFO: scm.iis.https.port is not found in conf.properties 2015-02-09 14:29:21.463 THREAD 23 INFO: scm.iisproxy.http.port is not found in conf.properties 2015-02-09 14:29:21.463 THREAD 23 INFO: scm.iisproxy.https.port is not found in conf.properties 2015-02-09 14:29:21.463 THREAD 23 INFO: scm.rmmwebservices.port is found in conf.properties 2015-02-09 14:29:23.702 THREAD 23 INFO: Run LiveUpdate during upgrade=true 2015-02-09 14:29:23.707 THREAD 27 WARNING: Upgrade> doUpgrade>> Upgrade process started @ : 0 2015-02-09 14:29:23.709 THREAD 27 INFO: UpgradeStep >> checkUpgradeStatus. 2015-02-09 14:29:23.715 THREAD 27 WARNING: Upgrade> doUpgrade>> Stopping SemSrv... 2015-02-09 14:29:23.789 THREAD 27 INFO: The Symantec Endpoint Protection Manager service is not started.More help is available by typing NET HELPMSG 3521. 2015-02-09 14:29:23.789 THREAD 27 INFO: SemServiceManager> serviceControl>> Executed command - stop semsrv, process return value = 2 2015-02-09 14:29:23.789 THREAD 27 INFO: SemServiceManager> waitForServiceTermination>> Waiting for service termination: semsrv 2015-02-09 14:29:23.790 THREAD 27 INFO: SemServiceManager> getServiceStatus>> Retrieve status for service semsrv 2015-02-09 14:29:23.858 THREAD 27 INFO: SemServiceManager> getServiceStatus>> The status for semsrv' service is 1 2015-02-09 14:29:23.873 THREAD 27 INFO: SemServiceManager> waitForServiceTermination>> Service is stopped. 2015-02-09 14:29:23.946 THREAD 27 INFO: The Symantec Endpoint Protection Manager Webserver service is not started.More help is available by typing NET HELPMSG 3521. 2015-02-09 14:29:23.946 THREAD 27 INFO: SemServiceManager> serviceControl>> Executed command - stop semwebsrv, process return value = 2 2015-02-09 14:29:24.022 THREAD 27 INFO: The service name is invalid.More help is available by typing NET HELPMSG 2185. 2015-02-09 14:29:24.022 THREAD 27 INFO: SemServiceManager> serviceControl>> Executed command - stop semlaunchsrv, process return value = 2 2015-02-09 14:29:24.022 THREAD 27 INFO: SemServiceManager> waitForServiceTermination>> Waiting for service termination: semlaunchsrv 2015-02-09 14:29:24.022 THREAD 27 INFO: SemServiceManager> getServiceStatus>> Retrieve status for service semlaunchsrv 2015-02-09 14:29:24.103 THREAD 27 INFO: SemServiceManager> getServiceStatus>> Error code from sc query: 1060 2015-02-09 14:29:24.103 THREAD 27 INFO: SemServiceManager> waitForServiceTermination>> Service is stopped. 2015-02-09 14:29:24.103 THREAD 27 WARNING: Upgrade> doUpgrade>> Stopping SemSrv done! 2015-02-09 14:29:24.107 THREAD 27 INFO: DatabaseUtilities> initDataSource>> Found 12.x driver 2015-02-09 14:29:24.108 THREAD 27 INFO: DatabaseUtilities> initDataSource>> dbport : 2638 2015-02-09 14:29:24.108 THREAD 27 INFO: DatabaseUtilities> initDataSource>> Datasource set in sqlanywhere>>ds:sybase.jdbc4.sqlanywhere.ASADataSource@11f0ad2 2015-02-09 14:29:24.108 THREAD 27 INFO: SemServiceManager> getServiceStatus>> Retrieve status for service SQLANYs_sem5 2015-02-09 14:29:24.177 THREAD 27 INFO: SemServiceManager> getServiceStatus>> The status for SQLANYs_sem5' service is 4 2015-02-09 14:29:26.770 THREAD 27 INFO: The Symantec Embedded Database service is stopping.The Symantec Embedded Database service was stopped successfully. 2015-02-09 14:29:26.770 THREAD 27 INFO: SemServiceManager> serviceControl>> Executed command - stop SQLANYs_sem5, process return value = 0 2015-02-09 14:29:26.770 THREAD 27 INFO: SemServiceManager> waitForServiceTermination>> Waiting for service termination: SQLANYs_sem5 2015-02-09 14:29:26.770 THREAD 27 INFO: SemServiceManager> getServiceStatus>> Retrieve status for service SQLANYs_sem5 2015-02-09 14:29:26.838 THREAD 27 INFO: SemServiceManager> getServiceStatus>> The status for SQLANYs_sem5' service is 1 2015-02-09 14:29:26.853 THREAD 27 INFO: SemServiceManager> waitForServiceTermination>> Service is stopped. 2015-02-09 14:29:26.882 THREAD 27 INFO: UpgradeDBUtil> getEmbeddedDBVersion>> embeddedDBVersion matching string = 12.0.1.3152 2015-02-09 14:29:29.069 THREAD 27 INFO: The Symantec Embedded Database service is starting.The Symantec Embedded Database service was started successfully. 2015-02-09 14:29:29.069 THREAD 27 INFO: SemServiceManager> serviceControl>> Executed command - start SQLANYs_sem5, process return value = 0 2015-02-09 14:29:29.069 THREAD 27 INFO: Upgrade> doUpgrade>> Embedded database is 12x or higher, version number is 12.0.1.3152 2015-02-09 14:29:29.139 THREAD 27 INFO: 'SQLANYs_sem5' service is installed... 2015-02-09 14:29:29.139 THREAD 27 INFO: STATE : 4 RUNNING 2015-02-09 14:29:29.154 THREAD 27 INFO: Upgrade> doUpgrade>> Embedded database 12x or higher upgrade process done! 2015-02-09 14:29:29.229 THREAD 27 INFO: The requested service has already been started.More help is available by typing NET HELPMSG 2182. 2015-02-09 14:29:29.229 THREAD 27 INFO: SemServiceManager> serviceControl>> Executed command - start SQLANYs_sem5, process return value = 2 2015-02-09 14:29:29.229 THREAD 27 INFO: Waiting for service running: SQLANYs_sem5 2015-02-09 14:29:29.229 THREAD 27 INFO: SemServiceManager> getServiceStatus>> Retrieve status for service SQLANYs_sem5 2015-02-09 14:29:29.298 THREAD 27 INFO: SemServiceManager> getServiceStatus>> The status for SQLANYs_sem5' service is 4 2015-02-09 14:29:29.313 THREAD 27 INFO: The service SQLANYs_sem5 has already been started. 2015-02-09 14:29:29.316 THREAD 27 INFO: DatabaseUtilities> initDataSource>> Found 12.x driver 2015-02-09 14:29:29.317 THREAD 27 INFO: DatabaseUtilities> initDataSource>> dbport : 2638 2015-02-09 14:29:29.317 THREAD 27 INFO: DatabaseUtilities> initDataSource>> Datasource set in sqlanywhere>>ds:sybase.jdbc4.sqlanywhere.ASADataSource@1a9d40f 2015-02-09 14:29:29.317 THREAD 27 INFO: DatabaseUtilities> testDBConnection>> Testing DB connection using 'DefaultDatabaseConnection' method. Parameters used (needDateFormat: false, isRetryUntilDBUp: false, defaultConnectionMaxRetry: 20) 2015-02-09 14:29:29.404 THREAD 27 INFO: isLicenseInstallationValid: sep.slf =true OD file=true 2015-02-09 14:29:29.540 THREAD 27 INFO: UpgradeDBUtil> createODBC>> Creating ODBC... [dbServer: localhost, dbDomain: null, dbUser: DBA, dbPwd: ***, dbName: sem5, dbServerPort: 2638, dbVendor: Embedded, SPMport: 8443, remotePort: 9090] 2015-02-09 14:29:29.656 THREAD 27 INFO: UpgradeDBUtil> createODBC>> Creating ODBC done! 2015-02-09 14:29:29.657 THREAD 27 INFO: UpgradeStep >> checkUpgradeStatus. 2015-02-09 14:29:29.657 THREAD 27 INFO: UpgradeStep >> checkUpgradeStatus. 2015-02-09 14:29:29.657 THREAD 27 INFO: Set the config manager cache threshold to 500! 2015-02-09 14:29:29.670 THREAD 27 INFO: updateEmbeddedStatementCount done 2015-02-09 14:29:29.688 THREAD 27 WARNING: Upgrade> doUpgrade>> Upgrading database schema... [formatVersion = 12.1.3.0, dbVersion = 12.1.3.0] 2015-02-09 14:29:29.700 THREAD 27 INFO: Process SQL script file:EmbeddedMcLarenToTesla.sql 2015-02-09 14:29:29.700 THREAD 27 INFO: Process SQL InputStream sqlis:sun.net.www.protocol.jar.JarURLConnection$JarURLInputStream@8b641b 2015-02-09 14:29:29.701 THREAD 27 INFO: DatabaseUtilities> execCommandFromScript>> cmdSeperator : ;; , sqlStr : IF NOT EXISTS (SELECT COLUMN_NAME FROM SYSTABLE T, SYSCOLUMN C WHERE T.TABLE_ID=C.TABLE_ID AND T.TABLE_NAME='SEM_COMPUTER' AND COLUMN_NAME = 'BIOS_SERIALNUMBER' ) ALTER TABLE SEM_COMPUTER ADD BIOS_SERIALNUMBER VARCHAR(128) NULL 2015-02-09 14:29:29.701 THREAD 27 INFO: IF NOT EXISTS (SELECT COLUMN_NAME FROM SYSTABLE T, SYSCOLUMN C WHERE T.TABLE_ID=C.TABLE_ID AND T.TABLE_NAME='SEM_COMPUTER' AND COLUMN_NAME = 'BIOS_SERIALNUMBER' ) ALTER TABLE SEM_COMPUTER ADD BIOS_SERIALNUMBER VARCHAR(128) NULL 2015-02-09 14:29:29.723 THREAD 27 INFO: DROP VIEW V_SEM_COMPUTER 2015-02-09 14:29:30.257 THREAD 27 INFO: CREATE VIEW V_SEM_COMPUTER AS SELECT *, CAST((case when DNS_SERVER1 < 0 then 0xFFFFFFFF + DNS_SERVER1 else DNS_SERVER1 end / 256 / 256 / 256) & 0xFF as VARCHAR) + '.' + CAST((case when DNS_SERVER1 < 0 then 0xFFFFFFFF + DNS_SERVER1 else DNS_SERVER1 end / 256 / 256) & 0xFF as VARCHAR) + '.' + CAST((case when DNS_SERVER1 < 0 then 0xFFFFFFFF + DNS_SERVER1 else DNS_SERVER1 end / 256) & 0xFF as VARCHAR) + '.' + CAST( case when DNS_SERVER1 < 0 then 0xFFFFFFFF + DNS_SERVER1 else DNS_SERVER1 end & 0xFF as VARCHAR) as DNS_SERVER1_TEXT, CAST((case when DNS_SERVER2 < 0 then 0xFFFFFFFF + DNS_SERVER2 else DNS_SERVER2 end / 256 / 256 / 256) & 0xFF as VARCHAR) + '.' + CAST((case when DNS_SERVER2 < 0 then 0xFFFFFFFF + DNS_SERVER2 else DNS_SERVER2 end / 256 / 256) & 0xFF as VARCHAR) + '.' + CAST((case when DNS_SERVER2 < 0 then 0xFFFFFFFF + DNS_SERVER2 else DNS_SERVER2 end / 256) & 0xFF as VARCHAR) + '.' + CAST( case when DNS_SERVER2 < 0 then 0xFFFFFFFF + DNS_SERVER2 else DNS_SERVER2 end & 0xFF as VARCHAR) as DNS_SERVER2_TEXT, CAST((case when WINS_SERVER1 < 0 then 0xFFFFFFFF + WINS_SERVER1 else WINS_SERVER1 end / 256 / 256 / 256) & 0xFF as VARCHAR) + '.' + CAST((case when WINS_SERVER1 < 0 then 0xFFFFFFFF + WINS_SERVER1 else WINS_SERVER1 end / 256 / 256) & 0xFF as VARCHAR) + '.' + CAST((case when WINS_SERVER1 < 0 then 0xFFFFFFFF + WINS_SERVER1 else WINS_SERVER1 end / 256) & 0xFF as VARCHAR) + '.' + CAST( case when WINS_SERVER1 < 0 then 0xFFFFFFFF + WINS_SERVER1 else WINS_SERVER1 end & 0xFF as VARCHAR) as WINS_SERVER1_TEXT, CAST((case when WINS_SERVER2 < 0 then 0xFFFFFFFF + WINS_SERVER2 else WINS_SERVER2 end / 256 / 256 / 256) & 0xFF as VARCHAR) + '.' + CAST((case when WINS_SERVER2 < 0 then 0xFFFFFFFF + WINS_SERVER2 else WINS_SERVER2 end / 256 / 256) & 0xFF as VARCHAR) + '.' + CAST((case when WINS_SERVER2 < 0 then 0xFFFFFFFF + WINS_SERVER2 else WINS_SERVER2 end / 256) & 0xFF as VARCHAR) + '.' + CAST( case when WINS_SERVER2 < 0 then 0xFFFFFFFF + WINS_SERVER2 else WINS_SERVER2 end & 0xFF as VARCHAR) as WINS_SERVER2_TEXT, CAST((case when DHCP_SERVER < 0 then 0xFFFFFFFF + DHCP_SERVER else DHCP_SERVER end / 256 / 256 / 256) & 0xFF as VARCHAR) + '.' + CAST((case when DHCP_SERVER < 0 then 0xFFFFFFFF + DHCP_SERVER else DHCP_SERVER end / 256 / 256) & 0xFF as VARCHAR) + '.' + CAST((case when DHCP_SERVER < 0 then 0xFFFFFFFF + DHCP_SERVER else DHCP_SERVER end / 256) & 0xFF as VARCHAR) + '.' + CAST( case when DHCP_SERVER < 0 then 0xFFFFFFFF + DHCP_SERVER else DHCP_SERVER end & 0xFF as VARCHAR) as DHCP_SERVER_TEXT, CAST((case when IP_ADDR1 < 0 then 0xFFFFFFFF + IP_ADDR1 else IP_ADDR1 end / 256 / 256 / 256) & 0xFF as VARCHAR) + '.' + CAST((case when IP_ADDR1 < 0 then 0xFFFFFFFF + IP_ADDR1 else IP_ADDR1 end / 256 / 256) & 0xFF as VARCHAR) + '.' + CAST((case when IP_ADDR1 < 0 then 0xFFFFFFFF + IP_ADDR1 else IP_ADDR1 end / 256) & 0xFF as VARCHAR) + '.' + CAST( case when IP_ADDR1 < 0 then 0xFFFFFFFF + IP_ADDR1 else IP_ADDR1 end & 0xFF as VARCHAR) as IP_ADDR1_TEXT, CAST((case when GATEWAY1 < 0 then 0xFFFFFFFF + GATEWAY1 else GATEWAY1 end / 256 / 256 / 256) & 0xFF as VARCHAR) + '.' + CAST((case when GATEWAY1 < 0 then 0xFFFFFFFF + GATEWAY1 else GATEWAY1 end / 256 / 256) & 0xFF as VARCHAR) + '.' + CAST((case when GATEWAY1 < 0 then 0xFFFFFFFF + GATEWAY1 else GATEWAY1 end / 256) & 0xFF as VARCHAR) + '.' + CAST( case when GATEWAY1 < 0 then 0xFFFFFFFF + GATEWAY1 else GATEWAY1 end & 0xFF as VARCHAR) as GATEWAY1_TEXT, CAST((case when SUBNET_MASK1 < 0 then 0xFFFFFFFF + SUBNET_MASK1 else SUBNET_MASK1 end / 256 / 256 / 256) & 0xFF as VARCHAR) + '.' + CAST((case when SUBNET_MASK1 < 0 then 0xFFFFFFFF + SUBNET_MASK1 else SUBNET_MASK1 end / 256 / 256) & 0xFF as VARCHAR) + '.' + CAST((case when SUBNET_MASK1 < 0 then 0xFFFFFFFF + SUBNET_MASK1 else SUBNET_MASK1 end / 256) & 0xFF as VARCHAR) + '.' + CAST( case when SUBNET_MASK1 < 0 then 0xFFFFFFFF + SUBNET_MASK1 else SUBNET_MASK1 end & 0xFF as VARCHAR) as SUBNET_MASK1_TEXT, CAST((case when IP_ADDR2 < 0 then 0xFFFFFFFF + IP_ADDR2 else IP_ADDR2 end / 256 / 256 / 256) & 0xFF as VARCHAR) + '.' + CAST((case when IP_ADDR2 < 0 then 0xFFFFFFFF + IP_ADDR2 else IP_ADDR2 end / 256 / 256) & 0xFF as VARCHAR) + '.' + CAST((case when IP_ADDR2 < 0 then 0xFFFFFFFF + IP_ADDR2 else IP_ADDR2 end / 256) & 0xFF as VARCHAR) + '.' + CAST( case when IP_ADDR2 < 0 then 0xFFFFFFFF + IP_ADDR2 else IP_ADDR2 end & 0xFF as VARCHAR) as IP_ADDR2_TEXT, CAST((case when GATEWAY2 < 0 then 0xFFFFFFFF + GATEWAY2 else GATEWAY2 end / 256 / 256 / 256) & 0xFF as VARCHAR) + '.' + CAST((case when GATEWAY2 < 0 then 0xFFFFFFFF + GATEWAY2 else GATEWAY2 end / 256 / 256) & 0xFF as VARCHAR) + '.' + CAST((case when GATEWAY2 < 0 then 0xFFFFFFFF + GATEWAY2 else GATEWAY2 end / 256) & 0xFF as VARCHAR) + '.' + CAST( case when GATEWAY2 < 0 then 0xFFFFFFFF + GATEWAY2 else GATEWAY2 end & 0xFF as VARCHAR) as GATEWAY2_TEXT, CAST((case when SUBNET_MASK2 < 0 then 0xFFFFFFFF + SUBNET_MASK2 else SUBNET_MASK2 end / 256 / 256 / 256) & 0xFF as VARCHAR) + '.' + CAST((case when SUBNET_MASK2 < 0 then 0xFFFFFFFF + SUBNET_MASK2 else SUBNET_MASK2 end / 256 / 256) & 0xFF as VARCHAR) + '.' + CAST((case when SUBNET_MASK2 < 0 then 0xFFFFFFFF + SUBNET_MASK2 else SUBNET_MASK2 end / 256) & 0xFF as VARCHAR) + '.' + CAST( case when SUBNET_MASK2 < 0 then 0xFFFFFFFF + SUBNET_MASK2 else SUBNET_MASK2 end & 0xFF as VARCHAR) as SUBNET_MASK2_TEXT, CAST((case when IP_ADDR3 < 0 then 0xFFFFFFFF + IP_ADDR3 else IP_ADDR3 end / 256 / 256 / 256) & 0xFF as VARCHAR) + '.' + CAST((case when IP_ADDR3 < 0 then 0xFFFFFFFF + IP_ADDR3 else IP_ADDR3 end / 256 / 256) & 0xFF as VARCHAR) + '.' + CAST((case when IP_ADDR3 < 0 then 0xFFFFFFFF + IP_ADDR3 else IP_ADDR3 end / 256) & 0xFF as VARCHAR) + '.' + CAST( case when IP_ADDR3 < 0 then 0xFFFFFFFF + IP_ADDR3 else IP_ADDR3 end & 0xFF as VARCHAR) as IP_ADDR3_TEXT, CAST((case when GATEWAY3 < 0 then 0xFFFFFFFF + GATEWAY3 else GATEWAY3 end / 256 / 256 / 256) & 0xFF as VARCHAR) + '.' + CAST((case when GATEWAY3 < 0 then 0xFFFFFFFF + GATEWAY3 else GATEWAY3 end / 256 / 256) & 0xFF as VARCHAR) + '.' + CAST((case when GATEWAY3 < 0 then 0xFFFFFFFF + GATEWAY3 else GATEWAY3 end / 256) & 0xFF as VARCHAR) + '.' + CAST( case when GATEWAY3 < 0 then 0xFFFFFFFF + GATEWAY3 else GATEWAY3 end & 0xFF as VARCHAR) as GATEWAY3_TEXT, CAST((case when SUBNET_MASK3 < 0 then 0xFFFFFFFF + SUBNET_MASK3 else SUBNET_MASK3 end / 256 / 256 / 256) & 0xFF as VARCHAR) + '.' + CAST((case when SUBNET_MASK3 < 0 then 0xFFFFFFFF + SUBNET_MASK3 else SUBNET_MASK3 end / 256 / 256) & 0xFF as VARCHAR) + '.' + CAST((case when SUBNET_MASK3 < 0 then 0xFFFFFFFF + SUBNET_MASK3 else SUBNET_MASK3 end / 256) & 0xFF as VARCHAR) + '.' + CAST( case when SUBNET_MASK3 < 0 then 0xFFFFFFFF + SUBNET_MASK3 else SUBNET_MASK3 end & 0xFF as VARCHAR) as SUBNET_MASK3_TEXT, CAST((case when IP_ADDR4 < 0 then 0xFFFFFFFF + IP_ADDR4 else IP_ADDR4 end / 256 / 256 / 256) & 0xFF as VARCHAR) + '.' + CAST((case when IP_ADDR4 < 0 then 0xFFFFFFFF + IP_ADDR4 else IP_ADDR4 end / 256 / 256) & 0xFF as VARCHAR) + '.' + CAST((case when IP_ADDR4 < 0 then 0xFFFFFFFF + IP_ADDR4 else IP_ADDR4 end / 256) & 0xFF as VARCHAR) + '.' + CAST( case when IP_ADDR4 < 0 then 0xFFFFFFFF + IP_ADDR4 else IP_ADDR4 end & 0xFF as VARCHAR) as IP_ADDR4_TEXT, CAST((case when GATEWAY4 < 0 then 0xFFFFFFFF + GATEWAY4 else GATEWAY4 end / 256 / 256 / 256) & 0xFF as VARCHAR) + '.' + CAST((case when GATEWAY4 < 0 then 0xFFFFFFFF + GATEWAY4 else GATEWAY4 end / 256 / 256) & 0xFF as VARCHAR) + '.' + CAST((case when GATEWAY4 < 0 then 0xFFFFFFFF + GATEWAY4 else GATEWAY4 end / 256) & 0xFF as VARCHAR) + '.' + CAST( case when GATEWAY4 < 0 then 0xFFFFFFFF + GATEWAY4 else GATEWAY4 end & 0xFF as VARCHAR) as GATEWAY4_TEXT, CAST((case when SUBNET_MASK4 < 0 then 0xFFFFFFFF + SUBNET_MASK4 else SUBNET_MASK4 end / 256 / 256 / 256) & 0xFF as VARCHAR) + '.' + CAST((case when SUBNET_MASK4 < 0 then 0xFFFFFFFF + SUBNET_MASK4 else SUBNET_MASK4 end / 256 / 256) & 0xFF as VARCHAR) + '.' + CAST((case when SUBNET_MASK4 < 0 then 0xFFFFFFFF + SUBNET_MASK4 else SUBNET_MASK4 end / 256) & 0xFF as VARCHAR) + '.' + CAST( case when SUBNET_MASK4 < 0 then 0xFFFFFFFF + SUBNET_MASK4 else SUBNET_MASK4 end & 0xFF as VARCHAR) as SUBNET_MASK4_TEXT FROM SEM_COMPUTER WHERE DELETED=0 2015-02-09 14:29:30.317 THREAD 27 INFO: IF NOT EXISTS (SELECT COLUMN_NAME FROM SYSTABLE T, SYSCOLUMN C WHERE T.TABLE_ID=C.TABLE_ID AND T.TABLE_NAME='SEM_SVA_COMPUTER' AND COLUMN_NAME = 'BIOS_SERIALNUMBER' ) ALTER TABLE SEM_SVA_COMPUTER ADD BIOS_SERIALNUMBER VARCHAR(128) NULL 2015-02-09 14:29:30.319 THREAD 27 INFO: DROP VIEW V_SEM_SVA_COMPUTER 2015-02-09 14:29:30.359 THREAD 27 INFO: CREATE VIEW V_SEM_SVA_COMPUTER as SELECT *, CAST((case when DNS_SERVER1 < 0 then 0xFFFFFFFF + DNS_SERVER1 else DNS_SERVER1 end / 256 / 256 / 256) & 0xFF as VARCHAR) + '.' + CAST((case when DNS_SERVER1 < 0 then 0xFFFFFFFF + DNS_SERVER1 else DNS_SERVER1 end / 256 / 256) & 0xFF as VARCHAR) + '.' + CAST((case when DNS_SERVER1 < 0 then 0xFFFFFFFF + DNS_SERVER1 else DNS_SERVER1 end / 256) & 0xFF as VARCHAR) + '.' + CAST( case when DNS_SERVER1 < 0 then 0xFFFFFFFF + DNS_SERVER1 else DNS_SERVER1 end & 0xFF as VARCHAR) as DNS_SERVER1_TEXT, CAST((case when DNS_SERVER2 < 0 then 0xFFFFFFFF + DNS_SERVER2 else DNS_SERVER2 end / 256 / 256 / 256) & 0xFF as VARCHAR) + '.' + CAST((case when DNS_SERVER2 < 0 then 0xFFFFFFFF + DNS_SERVER2 else DNS_SERVER2 end / 256 / 256) & 0xFF as VARCHAR) + '.' + CAST((case when DNS_SERVER2 < 0 then 0xFFFFFFFF + DNS_SERVER2 else DNS_SERVER2 end / 256) & 0xFF as VARCHAR) + '.' + CAST( case when DNS_SERVER2 < 0 then 0xFFFFFFFF + DNS_SERVER2 else DNS_SERVER2 end & 0xFF as VARCHAR) as DNS_SERVER2_TEXT, CAST((case when WINS_SERVER1 < 0 then 0xFFFFFFFF + WINS_SERVER1 else WINS_SERVER1 end / 256 / 256 / 256) & 0xFF as VARCHAR) + '.' + CAST((case when WINS_SERVER1 < 0 then 0xFFFFFFFF + WINS_SERVER1 else WINS_SERVER1 end / 256 / 256) & 0xFF as VARCHAR) + '.' + CAST((case when WINS_SERVER1 < 0 then 0xFFFFFFFF + WINS_SERVER1 else WINS_SERVER1 end / 256) & 0xFF as VARCHAR) + '.' + CAST( case when WINS_SERVER1 < 0 then 0xFFFFFFFF + WINS_SERVER1 else WINS_SERVER1 end & 0xFF as VARCHAR) as WINS_SERVER1_TEXT, CAST((case when WINS_SERVER2 < 0 then 0xFFFFFFFF + WINS_SERVER2 else WINS_SERVER2 end / 256 / 256 / 256) & 0xFF as VARCHAR) + '.' + CAST((case when WINS_SERVER2 < 0 then 0xFFFFFFFF + WINS_SERVER2 else WINS_SERVER2 end / 256 / 256) & 0xFF as VARCHAR) + '.' + CAST((case when WINS_SERVER2 < 0 then 0xFFFFFFFF + WINS_SERVER2 else WINS_SERVER2 end / 256) & 0xFF as VARCHAR) + '.' + CAST( case when WINS_SERVER2 < 0 then 0xFFFFFFFF + WINS_SERVER2 else WINS_SERVER2 end & 0xFF as VARCHAR) as WINS_SERVER2_TEXT, CAST((case when DHCP_SERVER < 0 then 0xFFFFFFFF + DHCP_SERVER else DHCP_SERVER end / 256 / 256 / 256) & 0xFF as VARCHAR) + '.' + CAST((case when DHCP_SERVER < 0 then 0xFFFFFFFF + DHCP_SERVER else DHCP_SERVER end / 256 / 256) & 0xFF as VARCHAR) + '.' + CAST((case when DHCP_SERVER < 0 then 0xFFFFFFFF + DHCP_SERVER else DHCP_SERVER end / 256) & 0xFF as VARCHAR) + '.' + CAST( case when DHCP_SERVER < 0 then 0xFFFFFFFF + DHCP_SERVER else DHCP_SERVER end & 0xFF as VARCHAR) as DHCP_SERVER_TEXT, CAST((case when IP_ADDR1 < 0 then 0xFFFFFFFF + IP_ADDR1 else IP_ADDR1 end / 256 / 256 / 256) & 0xFF as VARCHAR) + '.' + CAST((case when IP_ADDR1 < 0 then 0xFFFFFFFF + IP_ADDR1 else IP_ADDR1 end / 256 / 256) & 0xFF as VARCHAR) + '.' + CAST((case when IP_ADDR1 < 0 then 0xFFFFFFFF + IP_ADDR1 else IP_ADDR1 end / 256) & 0xFF as VARCHAR) + '.' + CAST( case when IP_ADDR1 < 0 then 0xFFFFFFFF + IP_ADDR1 else IP_ADDR1 end & 0xFF as VARCHAR) as IP_ADDR1_TEXT, CAST((case when GATEWAY1 < 0 then 0xFFFFFFFF + GATEWAY1 else GATEWAY1 end / 256 / 256 / 256) & 0xFF as VARCHAR) + '.' + CAST((case when GATEWAY1 < 0 then 0xFFFFFFFF + GATEWAY1 else GATEWAY1 end / 256 / 256) & 0xFF as VARCHAR) + '.' + CAST((case when GATEWAY1 < 0 then 0xFFFFFFFF + GATEWAY1 else GATEWAY1 end / 256) & 0xFF as VARCHAR) + '.' + CAST( case when GATEWAY1 < 0 then 0xFFFFFFFF + GATEWAY1 else GATEWAY1 end & 0xFF as VARCHAR) as GATEWAY1_TEXT, CAST((case when SUBNET_MASK1 < 0 then 0xFFFFFFFF + SUBNET_MASK1 else SUBNET_MASK1 end / 256 / 256 / 256) & 0xFF as VARCHAR) + '.' + CAST((case when SUBNET_MASK1 < 0 then 0xFFFFFFFF + SUBNET_MASK1 else SUBNET_MASK1 end / 256 / 256) & 0xFF as VARCHAR) + '.' + CAST((case when SUBNET_MASK1 < 0 then 0xFFFFFFFF + SUBNET_MASK1 else SUBNET_MASK1 end / 256) & 0xFF as VARCHAR) + '.' + CAST( case when SUBNET_MASK1 < 0 then 0xFFFFFFFF + SUBNET_MASK1 else SUBNET_MASK1 end & 0xFF as VARCHAR) as SUBNET_MASK1_TEXT, CAST((case when IP_ADDR2 < 0 then 0xFFFFFFFF + IP_ADDR2 else IP_ADDR2 end / 256 / 256 / 256) & 0xFF as VARCHAR) + '.' + CAST((case when IP_ADDR2 < 0 then 0xFFFFFFFF + IP_ADDR2 else IP_ADDR2 end / 256 / 256) & 0xFF as VARCHAR) + '.' + CAST((case when IP_ADDR2 < 0 then 0xFFFFFFFF + IP_ADDR2 else IP_ADDR2 end / 256) & 0xFF as VARCHAR) + '.' + CAST( case when IP_ADDR2 < 0 then 0xFFFFFFFF + IP_ADDR2 else IP_ADDR2 end & 0xFF as VARCHAR) as IP_ADDR2_TEXT, CAST((case when GATEWAY2 < 0 then 0xFFFFFFFF + GATEWAY2 else GATEWAY2 end / 256 / 256 / 256) & 0xFF as VARCHAR) + '.' + CAST((case when GATEWAY2 < 0 then 0xFFFFFFFF + GATEWAY2 else GATEWAY2 end / 256 / 256) & 0xFF as VARCHAR) + '.' + CAST((case when GATEWAY2 < 0 then 0xFFFFFFFF + GATEWAY2 else GATEWAY2 end / 256) & 0xFF as VARCHAR) + '.' + CAST( case when GATEWAY2 < 0 then 0xFFFFFFFF + GATEWAY2 else GATEWAY2 end & 0xFF as VARCHAR) as GATEWAY2_TEXT, CAST((case when SUBNET_MASK2 < 0 then 0xFFFFFFFF + SUBNET_MASK2 else SUBNET_MASK2 end / 256 / 256 / 256) & 0xFF as VARCHAR) + '.' + CAST((case when SUBNET_MASK2 < 0 then 0xFFFFFFFF + SUBNET_MASK2 else SUBNET_MASK2 end / 256 / 256) & 0xFF as VARCHAR) + '.' + CAST((case when SUBNET_MASK2 < 0 then 0xFFFFFFFF + SUBNET_MASK2 else SUBNET_MASK2 end / 256) & 0xFF as VARCHAR) + '.' + CAST( case when SUBNET_MASK2 < 0 then 0xFFFFFFFF + SUBNET_MASK2 else SUBNET_MASK2 end & 0xFF as VARCHAR) as SUBNET_MASK2_TEXT, CAST((case when IP_ADDR3 < 0 then 0xFFFFFFFF + IP_ADDR3 else IP_ADDR3 end / 256 / 256 / 256) & 0xFF as VARCHAR) + '.' + CAST((case when IP_ADDR3 < 0 then 0xFFFFFFFF + IP_ADDR3 else IP_ADDR3 end / 256 / 256) & 0xFF as VARCHAR) + '.' + CAST((case when IP_ADDR3 < 0 then 0xFFFFFFFF + IP_ADDR3 else IP_ADDR3 end / 256) & 0xFF as VARCHAR) + '.' + CAST( case when IP_ADDR3 < 0 then 0xFFFFFFFF + IP_ADDR3 else IP_ADDR3 end & 0xFF as VARCHAR) as IP_ADDR3_TEXT, CAST((case when GATEWAY3 < 0 then 0xFFFFFFFF + GATEWAY3 else GATEWAY3 end / 256 / 256 / 256) & 0xFF as VARCHAR) + '.' + CAST((case when GATEWAY3 < 0 then 0xFFFFFFFF + GATEWAY3 else GATEWAY3 end / 256 / 256) & 0xFF as VARCHAR) + '.' + CAST((case when GATEWAY3 < 0 then 0xFFFFFFFF + GATEWAY3 else GATEWAY3 end / 256) & 0xFF as VARCHAR) + '.' + CAST( case when GATEWAY3 < 0 then 0xFFFFFFFF + GATEWAY3 else GATEWAY3 end & 0xFF as VARCHAR) as GATEWAY3_TEXT, CAST((case when SUBNET_MASK3 < 0 then 0xFFFFFFFF + SUBNET_MASK3 else SUBNET_MASK3 end / 256 / 256 / 256) & 0xFF as VARCHAR) + '.' + CAST((case when SUBNET_MASK3 < 0 then 0xFFFFFFFF + SUBNET_MASK3 else SUBNET_MASK3 end / 256 / 256) & 0xFF as VARCHAR) + '.' + CAST((case when SUBNET_MASK3 < 0 then 0xFFFFFFFF + SUBNET_MASK3 else SUBNET_MASK3 end / 256) & 0xFF as VARCHAR) + '.' + CAST( case when SUBNET_MASK3 < 0 then 0xFFFFFFFF + SUBNET_MASK3 else SUBNET_MASK3 end & 0xFF as VARCHAR) as SUBNET_MASK3_TEXT, CAST((case when IP_ADDR4 < 0 then 0xFFFFFFFF + IP_ADDR4 else IP_ADDR4 end / 256 / 256 / 256) & 0xFF as VARCHAR) + '.' + CAST((case when IP_ADDR4 < 0 then 0xFFFFFFFF + IP_ADDR4 else IP_ADDR4 end / 256 / 256) & 0xFF as VARCHAR) + '.' + CAST((case when IP_ADDR4 < 0 then 0xFFFFFFFF + IP_ADDR4 else IP_ADDR4 end / 256) & 0xFF as VARCHAR) + '.' + CAST( case when IP_ADDR4 < 0 then 0xFFFFFFFF + IP_ADDR4 else IP_ADDR4 end & 0xFF as VARCHAR) as IP_ADDR4_TEXT, CAST((case when GATEWAY4 < 0 then 0xFFFFFFFF + GATEWAY4 else GATEWAY4 end / 256 / 256 / 256) & 0xFF as VARCHAR) + '.' + CAST((case when GATEWAY4 < 0 then 0xFFFFFFFF + GATEWAY4 else GATEWAY4 end / 256 / 256) & 0xFF as VARCHAR) + '.' + CAST((case when GATEWAY4 < 0 then 0xFFFFFFFF + GATEWAY4 else GATEWAY4 end / 256) & 0xFF as VARCHAR) + '.' + CAST( case when GATEWAY4 < 0 then 0xFFFFFFFF + GATEWAY4 else GATEWAY4 end & 0xFF as VARCHAR) as GATEWAY4_TEXT, CAST((case when SUBNET_MASK4 < 0 then 0xFFFFFFFF + SUBNET_MASK4 else SUBNET_MASK4 end / 256 / 256 / 256) & 0xFF as VARCHAR) + '.' + CAST((case when SUBNET_MASK4 < 0 then 0xFFFFFFFF + SUBNET_MASK4 else SUBNET_MASK4 end / 256 / 256) & 0xFF as VARCHAR) + '.' + CAST((case when SUBNET_MASK4 < 0 then 0xFFFFFFFF + SUBNET_MASK4 else SUBNET_MASK4 end / 256) & 0xFF as VARCHAR) + '.' + CAST( case when SUBNET_MASK4 < 0 then 0xFFFFFFFF + SUBNET_MASK4 else SUBNET_MASK4 end & 0xFF as VARCHAR) as SUBNET_MASK4_TEXT FROM SEM_SVA_COMPUTER WHERE DELETED=0 2015-02-09 14:29:30.400 THREAD 27 INFO: IF NOT EXISTS (SELECT 1 FROM SEM_OS_INFO WHERE OPERATING_SYSTEM = 'OS X 10.9') INSERT INTO SEM_OS_INFO (OPERATING_SYSTEM, OS_NAME, OS_TYPE, SPC_OS_NAME, SPC_OS_TYPE, OS_MAJOR, OS_MINOR, SPC_OS_VERSION, OS_FAMILY, DELETED, USN, TIME_STAMP, I18N_KEY) VALUES ('OS X 10.9', 'OS X', '10.9', 'OS X', '', 10, 9, '10.9', 2,0,1,0, 'MACOS_10_9') 2015-02-09 14:29:30.403 THREAD 27 INFO: IF NOT EXISTS (SELECT 1 FROM SEM_OS_INFO WHERE OPERATING_SYSTEM = 'OS X 10.9.0') INSERT INTO SEM_OS_INFO (OPERATING_SYSTEM, OS_NAME, OS_TYPE, SPC_OS_NAME, SPC_OS_TYPE, OS_MAJOR, OS_MINOR, SPC_OS_VERSION, OS_FAMILY, DELETED, USN, TIME_STAMP, I18N_KEY) VALUES ('OS X 10.9.0', 'OS X', '10.9.0', 'OS X', '', 10, 9, '10.9.0', 2,0,1,0, 'MACOS_10_9_0') 2015-02-09 14:29:30.404 THREAD 27 INFO: IF NOT EXISTS (SELECT 1 FROM SEM_OS_INFO WHERE OPERATING_SYSTEM = 'OS X 10.9.1') INSERT INTO SEM_OS_INFO (OPERATING_SYSTEM, OS_NAME, OS_TYPE, SPC_OS_NAME, SPC_OS_TYPE, OS_MAJOR, OS_MINOR, SPC_OS_VERSION, OS_FAMILY, DELETED, USN, TIME_STAMP, I18N_KEY) VALUES ('OS X 10.9.1', 'OS X', '10.9.1', 'OS X', '', 10, 9, '10.9.1', 2,0,1,0, 'MACOS_10_9_1') 2015-02-09 14:29:30.405 THREAD 27 INFO: IF NOT EXISTS (SELECT 1 FROM SEM_OS_INFO WHERE OPERATING_SYSTEM = 'OS X 10.9.2') INSERT INTO SEM_OS_INFO (OPERATING_SYSTEM, OS_NAME, OS_TYPE, SPC_OS_NAME, SPC_OS_TYPE, OS_MAJOR, OS_MINOR, SPC_OS_VERSION, OS_FAMILY, DELETED, USN, TIME_STAMP, I18N_KEY) VALUES ('OS X 10.9.2', 'OS X', '10.9.2', 'OS X', '', 10, 9, '10.9.2', 2,0,1,0, 'MACOS_10_9_2') 2015-02-09 14:29:30.406 THREAD 27 INFO: IF NOT EXISTS (SELECT 1 FROM SEM_OS_INFO WHERE OPERATING_SYSTEM = 'OS X 10.9.3') INSERT INTO SEM_OS_INFO (OPERATING_SYSTEM, OS_NAME, OS_TYPE, SPC_OS_NAME, SPC_OS_TYPE, OS_MAJOR, OS_MINOR, SPC_OS_VERSION, OS_FAMILY, DELETED, USN, TIME_STAMP, I18N_KEY) VALUES ('OS X 10.9.3', 'OS X', '10.9.3', 'OS X', '', 10, 9, '10.9.3', 2,0,1,0, 'MACOS_10_9_3') 2015-02-09 14:29:30.407 THREAD 27 INFO: IF NOT EXISTS (SELECT 1 FROM SEM_OS_INFO WHERE OPERATING_SYSTEM = 'OS X 10.9.4') INSERT INTO SEM_OS_INFO (OPERATING_SYSTEM, OS_NAME, OS_TYPE, SPC_OS_NAME, SPC_OS_TYPE, OS_MAJOR, OS_MINOR, SPC_OS_VERSION, OS_FAMILY, DELETED, USN, TIME_STAMP, I18N_KEY) VALUES ('OS X 10.9.4', 'OS X', '10.9.4', 'OS X', '', 10, 9, '10.9.4', 2,0,1,0, 'MACOS_10_9_4') 2015-02-09 14:29:30.408 THREAD 27 INFO: IF NOT EXISTS (SELECT 1 FROM SEM_OS_INFO WHERE OPERATING_SYSTEM = 'OS X 10.9.5') INSERT INTO SEM_OS_INFO (OPERATING_SYSTEM, OS_NAME, OS_TYPE, SPC_OS_NAME, SPC_OS_TYPE, OS_MAJOR, OS_MINOR, SPC_OS_VERSION, OS_FAMILY, DELETED, USN, TIME_STAMP, I18N_KEY) VALUES ('OS X 10.9.5', 'OS X', '10.9.5', 'OS X', '', 10, 9, '10.9.5', 2,0,1,0, 'MACOS_10_9_5') 2015-02-09 14:29:30.409 THREAD 27 INFO: IF NOT EXISTS (SELECT 1 FROM SEM_OS_INFO WHERE OPERATING_SYSTEM = 'OS X 10.9.6') INSERT INTO SEM_OS_INFO (OPERATING_SYSTEM, OS_NAME, OS_TYPE, SPC_OS_NAME, SPC_OS_TYPE, OS_MAJOR, OS_MINOR, SPC_OS_VERSION, OS_FAMILY, DELETED, USN, TIME_STAMP, I18N_KEY) VALUES ('OS X 10.9.6', 'OS X', '10.9.6', 'OS X', '', 10, 9, '10.9.6', 2,0,1,0, 'MACOS_10_9_6') 2015-02-09 14:29:30.409 THREAD 27 INFO: IF NOT EXISTS (SELECT 1 FROM SEM_OS_INFO WHERE OPERATING_SYSTEM = 'OS X 10.9.7') INSERT INTO SEM_OS_INFO (OPERATING_SYSTEM, OS_NAME, OS_TYPE, SPC_OS_NAME, SPC_OS_TYPE, OS_MAJOR, OS_MINOR, SPC_OS_VERSION, OS_FAMILY, DELETED, USN, TIME_STAMP, I18N_KEY) VALUES ('OS X 10.9.7', 'OS X', '10.9.7', 'OS X', '', 10, 9, '10.9.7', 2,0,1,0, 'MACOS_10_9_7') 2015-02-09 14:29:30.410 THREAD 27 INFO: IF NOT EXISTS (SELECT 1 FROM SEM_OS_INFO WHERE OPERATING_SYSTEM = 'OS X 10.9.8') INSERT INTO SEM_OS_INFO (OPERATING_SYSTEM, OS_NAME, OS_TYPE, SPC_OS_NAME, SPC_OS_TYPE, OS_MAJOR, OS_MINOR, SPC_OS_VERSION, OS_FAMILY, DELETED, USN, TIME_STAMP, I18N_KEY) VALUES ('OS X 10.9.8', 'OS X', '10.9.8', 'OS X', '', 10, 9, '10.9.8', 2,0,1,0, 'MACOS_10_9_8') 2015-02-09 14:29:30.411 THREAD 27 INFO: IF NOT EXISTS (SELECT 1 FROM SEM_OS_INFO WHERE OPERATING_SYSTEM = 'OS X 10.9.9') INSERT INTO SEM_OS_INFO (OPERATING_SYSTEM, OS_NAME, OS_TYPE, SPC_OS_NAME, SPC_OS_TYPE, OS_MAJOR, OS_MINOR, SPC_OS_VERSION, OS_FAMILY, DELETED, USN, TIME_STAMP, I18N_KEY) VALUES ('OS X 10.9.9', 'OS X', '10.9.9', 'OS X', '', 10, 9, '10.9.9', 2,0,1,0, 'MACOS_10_9_9') 2015-02-09 14:29:30.412 THREAD 27 INFO: IF NOT EXISTS (SELECT 1 FROM SEM_OS_INFO WHERE OPERATING_SYSTEM = 'OS X 10.9.10') INSERT INTO SEM_OS_INFO (OPERATING_SYSTEM, OS_NAME, OS_TYPE, SPC_OS_NAME, SPC_OS_TYPE, OS_MAJOR, OS_MINOR, SPC_OS_VERSION, OS_FAMILY, DELETED, USN, TIME_STAMP, I18N_KEY) VALUES ('OS X 10.9.10', 'OS X', '10.9.10', 'OS X', '', 10, 9, '10.9.10', 2,0,1,0, 'MACOS_10_9_10') 2015-02-09 14:29:30.413 THREAD 27 INFO: Process SQL script file:EmbeddedTeslaToLightCycle.sql 2015-02-09 14:29:30.413 THREAD 27 INFO: Process SQL InputStream sqlis:sun.net.www.protocol.jar.JarURLConnection$JarURLInputStream@87abd8 2015-02-09 14:29:30.414 THREAD 27 INFO: DatabaseUtilities> execCommandFromScript>> cmdSeperator : ;; , sqlStr : DROP VIEW V_AGENT_INCL_GROUP_ID 2015-02-09 14:29:30.414 THREAD 27 INFO: DROP VIEW V_AGENT_INCL_GROUP_ID 2015-02-09 14:29:30.468 THREAD 27 INFO: CREATE VIEW V_AGENT_INCL_GROUP_ID as SELECT AGENT_ID, AGENT_TYPE, R_OS_TYPE, COMPUTER_ID, DOMAIN_ID, GROUP_ID, AGENT_VERSION, PROFILE_VERSION, PROFILE_SERIAL_NO, PROFILE_CHECKSUM, IDS_VERSION, IDS_SERIAL_NO, IDS_CHECKSUM, HI_STATUS, HI_REASONCODE, HI_REASONDESC, CREATION_TIME, STATUS, LAST_UPDATE_TIME, LAST_SERVER_ID, LAST_SITE_ID, ATTRIBUTE_EXTENSION, FULL_NAME, EMAIL, JOB_TITLE, DEPARTMENT, EMPLOYEE_NUMBER, EMPLOYMENT_STATUS, OFFICE_PHONE, MOBILE_PHONE, HOME_PHONE, USN, TIME_STAMP, DELETED, PATTERN_IDX, AP_ONOFF, INFECTED, WORSTINFECTION_IDX, LAST_SCAN_TIME, LAST_VIRUS_TIME, CONTENT_UPDATE, AVENGINE_ONOFF, TAMPER_ONOFF, MAJOR_VERSION, MINOR_VERSION, REBOOT_REQUIRED, REBOOT_REASON, LICENSE_STATUS, LICENSE_EXPIRY, TIMEZONE, FIREWALL_ONOFF, FREE_MEM, FREE_DISK, LAST_DOWNLOAD_TIME, CURRENT_CLIENT_ID, LICENSE_ID, IS_GRACE, SNAC_LICENSE_ID, PTP_ONOFF, LAST_HEURISTIC_THREAT_TIME, BASH_STATUS, DA_ONOFF, CIDS_DRV_ONOFF, CIDS_SILENT_MODE, CIDS_DRV_MULF_CODE, CIDS_BROWSER_IE_ONOFF, CIDS_BROWSER_FF_ONOFF, CIDS_ENGINE_VERSION, CIDS_DEFSET_VERSION, DEPLOY_STATUS, DEPLOY_MSG, DEPLOY_PRE_VER, DEPLOY_TARGET_VER, DEPLOY_RUNNING_VER, DEPLOY_TIMESTAMP, OS_BIT_TYPE, ELAM_ONOFF, OSELAM_STATUS, VSIC_STATUS, IS_NPVDI_CLIENT, SVA_ID, LAST_CONNECTED_IP_ADDR FROM SEM_AGENT with (NOLOCK) 2015-02-09 14:29:30.500 THREAD 27 INFO: Process SQL script file:Embedded12RU4MP1ToFerrariPCC.sql 2015-02-09 14:29:30.501 THREAD 27 INFO: Process SQL InputStream sqlis:sun.net.www.protocol.jar.JarURLConnection$JarURLInputStream@c2947e 2015-02-09 14:29:30.501 THREAD 27 INFO: DatabaseUtilities> execCommandFromScript>> cmdSeperator : ;; , sqlStr : DROP TABLE TASKSTATE 2015-02-09 14:29:30.501 THREAD 27 INFO: DROP TABLE TASKSTATE 2015-02-09 14:29:30.518 THREAD 27 INFO: CREATE TABLE TASKSTATE ( IDX CHAR(32) NOT NULL, SERVER_ID CHAR(32) NOT NULL, TASKTYPE NVARCHAR(255) NOT NULL, STATE INT NOT NULL, STARTTIME BIGINT NOT NULL, LASTUPDATETIME BIGINT NOT NULL, LASTRUNGMT BIGINT NOT NULL, DETAIL NVARCHAR(255) NULL ) 2015-02-09 14:29:30.525 THREAD 27 INFO: DROP TABLE ENUM_MAP 2015-02-09 14:29:30.534 THREAD 27 INFO: CREATE TABLE ENUM_MAP ( NAMESPACE NVARCHAR(255) NULL, VALUE INT NULL, NAME NVARCHAR(255) NULL ) 2015-02-09 14:29:30.542 THREAD 27 INFO: DROP VIEW V_TASKSTATE 2015-02-09 14:29:30.559 THREAD 27 INFO: CREATE VIEW V_TASKSTATE as select TS.SERVER_ID, TS.TASKTYPE, TS.STARTTIME, TS.LASTUPDATETIME, TS.LASTRUNGMT, TS.DETAIL, TV.NAME FROM TASKSTATE as TS, ENUM_MAP as TV where TS.TASKTYPE=TV.NAMESPACE and TS.STATE=TV.VALUE 2015-02-09 14:29:30.583 THREAD 27 INFO: DROP VIEW V_SCANS 2015-02-09 14:29:30.601 THREAD 27 INFO: CREATE VIEW V_SCANS as select * from SCANS where DELETED=0 2015-02-09 14:29:30.625 THREAD 27 INFO: INSERT INTO ENUM_MAP (NAMESPACE, VALUE, NAME) VALUES ('LiveUpdate', 0, 'LIVEUPDATE_SUCCEEDED') 2015-02-09 14:29:30.626 THREAD 27 INFO: INSERT INTO ENUM_MAP (NAMESPACE, VALUE, NAME) VALUES ('LiveUpdate', 1, 'LIVEUPDATE_FAILED') 2015-02-09 14:29:30.627 THREAD 27 INFO: INSERT INTO ENUM_MAP (NAMESPACE, VALUE, NAME) VALUES ('LiveUpdate', 2, 'LIVEUPDATE_STARTED') 2015-02-09 14:29:30.627 THREAD 27 INFO: INSERT INTO ENUM_MAP (NAMESPACE, VALUE, NAME) VALUES ('PolicyChange', 0, 'POLICYCHANGE_SUCCEEDED') 2015-02-09 14:29:30.628 THREAD 27 INFO: INSERT INTO ENUM_MAP (NAMESPACE, VALUE, NAME) VALUES ('PolicyChange', 1, 'POLICYCHANGE_FAILED') 2015-02-09 14:29:30.629 THREAD 27 INFO: INSERT INTO ENUM_MAP (NAMESPACE, VALUE, NAME) VALUES ('PolicyChange', 2, 'POLICYCHANGE_REQUESTRECEIVED') 2015-02-09 14:29:30.630 THREAD 27 INFO: INSERT INTO ENUM_MAP (NAMESPACE, VALUE, NAME) VALUES ('PolicyChange', 3, 'POLICYCHANGE_PUBLISHBEGIN') 2015-02-09 14:29:30.630 THREAD 27 INFO: INSERT INTO ENUM_MAP (NAMESPACE, VALUE, NAME) VALUES ('PolicyChange', 4, 'POLICYCHANGE_PUBLISHINPROGRESS') 2015-02-09 14:29:30.631 THREAD 27 INFO: INSERT INTO ENUM_MAP (NAMESPACE, VALUE, NAME) VALUES ('Replication', 0, 'REPLICATION_SUCCESS') 2015-02-09 14:29:30.632 THREAD 27 INFO: INSERT INTO ENUM_MAP (NAMESPACE, VALUE, NAME) VALUES ('Replication', 1, 'REPLICATION_FAILED') 2015-02-09 14:29:30.632 THREAD 27 INFO: INSERT INTO ENUM_MAP (NAMESPACE, VALUE, NAME) VALUES ('Replication', 2, 'REPLICATION_CHANGE_RECEIVED') 2015-02-09 14:29:30.633 THREAD 27 INFO: INSERT INTO ENUM_MAP (NAMESPACE, VALUE, NAME) VALUES ('Replication', 3, 'REPLICATION_REMOTEREPLICATE') 2015-02-09 14:29:30.633 THREAD 27 INFO: INSERT INTO ENUM_MAP (NAMESPACE, VALUE, NAME) VALUES ('Replication', 4, 'REPLICATION_NEEDTO_SYNC_SERVERTIME') 2015-02-09 14:29:30.634 THREAD 27 INFO: INSERT INTO ENUM_MAP (NAMESPACE, VALUE, NAME) VALUES ('Replication', 5, 'REPLICATION_RESOLVING_NAME_CHANGE') 2015-02-09 14:29:30.635 THREAD 27 INFO: INSERT INTO ENUM_MAP (NAMESPACE, VALUE, NAME) VALUES ('Replication', 6, 'REPLICATION_SKIP') 2015-02-09 14:29:30.635 THREAD 27 INFO: INSERT INTO ENUM_MAP (NAMESPACE, VALUE, NAME) VALUES ('Replication', 7, 'REPLICATION_START') 2015-02-09 14:29:30.636 THREAD 27 INFO: INSERT INTO ENUM_MAP (NAMESPACE, VALUE, NAME) VALUES ('Replication', 8, 'REPLICATION_CHANGE_RECEIVING') 2015-02-09 14:29:30.637 THREAD 27 INFO: INSERT INTO ENUM_MAP (NAMESPACE, VALUE, NAME) VALUES ('Replication', 9, 'REPLICATION_DELTAMERGE') 2015-02-09 14:29:30.637 THREAD 27 INFO: ALTER TABLE HYPERVISOR_VENDOR DROP PRIMARY KEY 2015-02-09 14:29:31.251 THREAD 27 INFO: ALTER TABLE HYPERVISOR_VENDOR ADD CONSTRAINT PK_HYPERVISOR_VENDOR PRIMARY KEY (HYPERVISOR_VENDOR_ID) 2015-02-09 14:29:31.559 THREAD 27 INFO: IF EXISTS (SELECT INDEX_NAME FROM SYSINDEX WHERE INDEX_NAME = 'I_SEM_CONTENT_DELETED_PLUS' ) DROP INDEX SEM_CONTENT.I_SEM_CONTENT_DELETED_PLUS 2015-02-09 14:29:31.562 THREAD 27 INFO: IF EXISTS (SELECT INDEX_NAME FROM SYSINDEX WHERE INDEX_NAME = 'I_SCANS_DELETED_PLUS' ) DROP INDEX SCANS.I_SCANS_DELETED_PLUS 2015-02-09 14:29:31.564 THREAD 27 INFO: ALTER TABLE SEM_COMPUTER MODIFY OPERATION_SYSTEM nvarchar(512) 2015-02-09 14:29:31.967 THREAD 27 INFO: ALTER TABLE SEM_SVA_COMPUTER MODIFY OPERATION_SYSTEM nvarchar(512) 2015-02-09 14:29:32.375 THREAD 27 INFO: DROP VIEW V_AGENT_INCL_GROUP_ID 2015-02-09 14:29:32.425 THREAD 27 INFO: CREATE VIEW V_AGENT_INCL_GROUP_ID as SELECT AGENT_ID, AGENT_TYPE, R_OS_TYPE, COMPUTER_ID, DOMAIN_ID, GROUP_ID, AGENT_VERSION, PROFILE_VERSION, PROFILE_SERIAL_NO, PROFILE_CHECKSUM, IDS_VERSION, IDS_SERIAL_NO, IDS_CHECKSUM, HI_STATUS, HI_REASONCODE, HI_REASONDESC, CREATION_TIME, STATUS, LAST_UPDATE_TIME, LAST_SERVER_ID, LAST_SITE_ID, ATTRIBUTE_EXTENSION, FULL_NAME, EMAIL, JOB_TITLE, DEPARTMENT, EMPLOYEE_NUMBER, EMPLOYMENT_STATUS, OFFICE_PHONE, MOBILE_PHONE, HOME_PHONE, USN, TIME_STAMP, DELETED, PATTERN_IDX, AP_ONOFF, INFECTED, WORSTINFECTION_IDX, LAST_SCAN_TIME, LAST_VIRUS_TIME, CONTENT_UPDATE, AVENGINE_ONOFF, TAMPER_ONOFF, MAJOR_VERSION, MINOR_VERSION, REBOOT_REQUIRED, REBOOT_REASON, LICENSE_STATUS, LICENSE_EXPIRY, TIMEZONE, FIREWALL_ONOFF, FREE_MEM, FREE_DISK, LAST_DOWNLOAD_TIME, CURRENT_CLIENT_ID, LICENSE_ID, IS_GRACE, SNAC_LICENSE_ID, PTP_ONOFF, LAST_HEURISTIC_THREAT_TIME, BASH_STATUS, DA_ONOFF, CIDS_DRV_ONOFF, CIDS_SILENT_MODE, CIDS_DRV_MULF_CODE, CIDS_BROWSER_IE_ONOFF, CIDS_BROWSER_FF_ONOFF, CIDS_ENGINE_VERSION, CIDS_DEFSET_VERSION, DEPLOY_STATUS, DEPLOY_MSG, DEPLOY_PRE_VER, DEPLOY_TARGET_VER, DEPLOY_RUNNING_VER, DEPLOY_TIMESTAMP, OS_BIT_TYPE, ELAM_ONOFF, OSELAM_STATUS, VSIC_STATUS, IS_NPVDI_CLIENT, SVA_ID, LAST_CONNECTED_IP_ADDR FROM SEM_AGENT with (NOLOCK) 2015-02-09 14:29:32.458 THREAD 27 INFO: DROP PROCEDURE SEM_AV_SUMMARY_ATTACKER 2015-02-09 14:29:32.466 THREAD 27 INFO: CREATE PROCEDURE SEM_AV_SUMMARY_ATTACKER(in filter_5150 ntext) BEGIN DECLARE Command ntext; SET Command = 'SELECT A.SOURCE_COMPUTER_NAME as Computer, A.SOURCE_COMPUTER_IP as IP_Address, SUM(A.NOOFVIRUSES) as anzahl FROM ALERTS as A with (NOLOCK) INNER JOIN V_AGENT_INCL_GROUP_ID as SA with (NOLOCK) ON SA.COMPUTER_ID = A.COMPUTER_IDX INNER JOIN V_DOMAINS S on S.ID=SA.DOMAIN_ID INNER JOIN V_SERVERS P on P.ID=SA.LAST_SERVER_ID INNER JOIN V_GROUPS G on G.ID=SA.GROUP_ID WHERE (A.SOURCE_COMPUTER_IP != 0 or A.SOURCE_COMPUTER_NAME != '''') AND A.ALERT_IDX IN (1,2,10) and ' || filter_5150 || ' GROUP BY A.SOURCE_COMPUTER_NAME, A.SOURCE_COMPUTER_IP ORDER BY anzahl DESC '; EXECUTE IMMEDIATE WITH RESULT SET ON Command; END 2015-02-09 14:29:32.483 THREAD 27 INFO: DROP PROCEDURE SEM_AV_SUMMARY_SONAR 2015-02-09 14:29:32.491 THREAD 27 INFO: CREATE PROCEDURE SEM_AV_SUMMARY_SONAR(in filter_5150 ntext) BEGIN DECLARE Command ntext; SET Command = 'SELECT SUM(A.NOOFVIRUSES) as SUM, H.APP_NAME FROM ALERTS A with (NOLOCK), V_AGENT_INCL_GROUP_ID as SA, SEM_COMPUTER as I, HPP_APPLICATION H, HPP_ALERTS HA with (NOLOCK), V_GROUPS as G, V_SERVERS as P, V_DOMAINS as S where A.HPP_APP_IDX=H.APP_IDX AND HA.IDX = A.IDX and A.SOURCE=''Heuristic Scan'' and A.ALERT_IDX != 9 and I.COMPUTER_ID=SA.COMPUTER_ID and I.COMPUTER_ID=A.COMPUTER_IDX and G.ID=SA.GROUP_ID and P.ID=SA.LAST_SERVER_ID and S.ID=SA.DOMAIN_ID and ' || filter_5150 || ' GROUP BY H.APP_NAME order by SUM desc '; EXECUTE IMMEDIATE WITH RESULT SET ON Command; END 2015-02-09 14:29:32.508 THREAD 27 INFO: DROP PROCEDURE SEM_AV_SUMMARY_GROUP 2015-02-09 14:29:32.516 THREAD 27 INFO: CREATE PROCEDURE SEM_AV_SUMMARY_GROUP(in filter_5150 ntext) BEGIN DECLARE Command ntext; SET Command = 'SELECT G.NAME as Clientgroup, SUM(A.NOOFVIRUSES) as anzahl from ALERTS as A with (NOLOCK) INNER JOIN V_AGENT_INCL_GROUP_ID as SA with (NOLOCK) ON SA.COMPUTER_ID = A.COMPUTER_IDX INNER JOIN V_DOMAINS S on S.ID=SA.DOMAIN_ID INNER JOIN V_SERVERS P on P.ID=SA.LAST_SERVER_ID INNER JOIN V_GROUPS G with (NOLOCK) on G.ID=SA.GROUP_ID where A.ALERT_IDX IN (1,2,10) AND ' || filter_5150 || ' GROUP BY G.NAME ORDER BY anzahl DESC, G.NAME ASC'; EXECUTE IMMEDIATE WITH RESULT SET ON Command; END 2015-02-09 14:29:32.533 THREAD 27 INFO: DROP PROCEDURE SEM_AV_SUMMARY_SOURCE 2015-02-09 14:29:32.541 THREAD 27 INFO: CREATE PROCEDURE SEM_AV_SUMMARY_SOURCE(in filter_5150 ntext) BEGIN DECLARE Command ntext; SET Command = 'SELECT A.SOURCE as Source, SUM(A.NOOFVIRUSES) as anzahl from ALERTS as A with (NOLOCK) INNER JOIN V_AGENT_INCL_GROUP_ID as SA with (NOLOCK) ON SA.COMPUTER_ID = A.COMPUTER_IDX INNER JOIN V_GROUPS G on G.ID=SA.GROUP_ID INNER JOIN V_DOMAINS S on S.ID=SA.DOMAIN_ID INNER JOIN V_SERVERS P on P.ID=SA.LAST_SERVER_ID where A.ALERT_IDX IN (1,2,10) AND ' || filter_5150 || ' GROUP BY A.SOURCE ORDER BY anzahl DESC, A.SOURCE ASC '; EXECUTE IMMEDIATE WITH RESULT SET ON Command; END 2015-02-09 14:29:32.558 THREAD 27 INFO: DROP PROCEDURE SEM_AV_SUMMARY_RISK_DIST 2015-02-09 14:29:32.567 THREAD 27 INFO: CREATE PROCEDURE SEM_AV_SUMMARY_RISK_DIST(in filter_5150 ntext) BEGIN DECLARE Command ntext; SET Command = 'SELECT (CASE WHEN V.VIRUSNAME!='''' THEN V.VIRUSNAME ELSE HP.APP_NAME END) AS Virusname, COUNT(DISTINCT A.COMPUTER_IDX) as NumUniqueInfectedMachines FROM ALERTS as A with (NOLOCK) INNER JOIN V_AGENT_INCL_GROUP_ID as SA with (NOLOCK) ON SA.COMPUTER_ID = A.COMPUTER_IDX INNER JOIN V_GROUPS G on G.ID=SA.GROUP_ID INNER JOIN V_DOMAINS S on S.ID=SA.DOMAIN_ID INNER JOIN V_SERVERS P on P.ID=SA.LAST_SERVER_ID , V_VIRUS as V with (NOLOCK), V_HPP_APPLICATION_RISK as HP with (NOLOCK) WHERE A.VIRUSNAME_IDX = V.VIRUSNAME_IDX and A.ALERT_IDX IN (1,2,10) AND A.HPP_APP_IDX = HP.APP_IDX AND ' || filter_5150 || ' GROUP BY (CASE WHEN V.VIRUSNAME!='''' THEN V.VIRUSNAME ELSE HP.APP_NAME END) ORDER BY COUNT(DISTINCT A.COMPUTER_IDX) DESC, Virusname ASC '; EXECUTE IMMEDIATE WITH RESULT SET ON Command; END 2015-02-09 14:29:32.583 THREAD 27 INFO: DROP PROCEDURE SEM_HOMEPAGE_UNMANAGED_MACHINES 2015-02-09 14:29:32.592 THREAD 27 INFO: CREATE PROCEDURE SEM_HOMEPAGE_UNMANAGED_MACHINES(in filter_5150 ntext) BEGIN DECLARE Command ntext; SET Command = ' SELECT COUNT(*) as anzahl from (SELECT DISTINCT L.MAC_ADDRESS, L.IP_ADDRESS, COM.COMPUTER_NAME FROM LAN_DEVICE_DETECTED L with (NOLOCK), SEM_COMPUTER COM with (NOLOCK), V_AGENT_INCL_GROUP_ID SA with (NOLOCK) WHERE L.COMPUTER_ID = COM.COMPUTER_ID AND L.DELETED = 0 AND COM.DELETED = 0 AND COM.COMPUTER_ID = SA.COMPUTER_ID AND SA.DELETED = 0 AND L.MAC_ADDRESS NOT IN (SELECT MAC_ADDR1 FROM SEM_COMPUTER with (NOLOCK) WHERE MAC_ADDR1 IS NOT NULL) AND L.MAC_ADDRESS NOT IN (SELECT MAC_ADDR2 FROM SEM_COMPUTER with (NOLOCK) WHERE MAC_ADDR2 IS NOT NULL) AND L.MAC_ADDRESS NOT IN (SELECT MAC_ADDR3 FROM SEM_COMPUTER with (NOLOCK) WHERE MAC_ADDR3 IS NOT NULL) AND L.MAC_ADDRESS NOT IN (SELECT MAC_ADDR4 FROM SEM_COMPUTER with (NOLOCK) WHERE MAC_ADDR4 IS NOT NULL) AND NOT EXISTS (SELECT * FROM LAN_DEVICE_EXCLUDED E with (NOLOCK) WHERE L.HASH = E.HASH AND E.DELETED = 0 AND ( (E.EXCLUDE_MODE = 0 AND E.MAC_ADDRESS = L.MAC_ADDRESS) OR (E.EXCLUDE_MODE = 1 AND E.IP_ADDRESS = L.IP_ADDRESS) OR (E.EXCLUDE_MODE = 2 AND L.IP_ADDRESS >= E.IP_RANGE_START AND L.IP_ADDRESS <= E.IP_RANGE_END) ) ) ' || filter_5150 || ' ) as UNMANAGED_MACHINES '; EXECUTE IMMEDIATE WITH RESULT SET ON Command; END 2015-02-09 14:29:32.608 THREAD 27 INFO: DROP PROCEDURE SEM_HOMEPAGE_TWEXPIRING_LICENSES 2015-02-09 14:29:32.625 THREAD 27 INFO: CREATE PROCEDURE SEM_HOMEPAGE_TWEXPIRING_LICENSES( in @timestart BIGINT, in @timeend BIGINT) as BEGIN select sum(ls.meter_count) as count from license ls with (NOLOCK) where ls.expire_date in (select max(expire_date) from license group by license.chainid) and ls.expire_date > @timestart and ls.expire_date <= @timeend and ls.deleted = 0 and ls.type = 'A' END 2015-02-09 14:29:32.642 THREAD 27 INFO: DROP PROCEDURE SEM_HOMEPAGE_SONAR_REDANDYELLOW 2015-02-09 14:29:32.667 THREAD 27 INFO: CREATE PROCEDURE SEM_HOMEPAGE_SONAR_REDANDYELLOW( in yesterday ntext, in tooolddef ntext, in sqlwhere ntext) BEGIN DECLARE Command ntext; SET Command = 'SELECT COUNT(A.color) as anzahl, A.color FROM ( SELECT COUNT(DISTINCT(SA.AGENT_ID)) as anzahl, ''color'' = (CASE WHEN ' || yesterday || '> SA.CREATION_TIME THEN ''RED'' ELSE ''YELLOW'' END ), SA.AGENT_ID FROM V_AGENT_INCL_GROUP_ID SA with (NOLOCK) INNER JOIN V_GROUPS G ON G.ID=SA.GROUP_ID INNER JOIN V_DOMAINS S ON S.ID=SA.DOMAIN_ID LEFT OUTER JOIN SEM_CONTENT SC with (NOLOCK) on SC.AGENT_ID=SA.AGENT_ID LEFT OUTER JOIN V_SONAR ON SC.PATTERN_IDX=V_SONAR.PATTERN_IDX WHERE SA.AGENT_TYPE=''105'' AND SA.DELETED=0 and (V_SONAR.DELETED=0 OR V_SONAR.DELETED IS NULL) AND SA.STATUS=1 AND SA.MAJOR_VERSION>10 AND SA.PTP_ONOFF not in (2, 127) and SC.DELETED=0 and (SA.R_OS_TYPE) NOT IN (269091840,269092096,269092352,269092608,269092864,269093120) ' || sqlwhere || ' group by (CASE WHEN ' || yesterday || '> SA.CREATION_TIME THEN ''RED'' ELSE ''YELLOW'' END), SA.AGENT_ID HAVING ( MAX(V_SONAR.VERSION) IS NULL OR MAX(V_SONAR.VERSION) <=''' || tooolddef || ''')) AS A GROUP BY A.color'; EXECUTE IMMEDIATE WITH RESULT SET ON Command; END 2015-02-09 14:29:32.741 THREAD 27 INFO: DROP PROCEDURE SEM_HOMEPAGE_IPS_REDANDYELLOW 2015-02-09 14:29:32.775 THREAD 27 INFO: CREATE PROCEDURE SEM_HOMEPAGE_IPS_REDANDYELLOW( in yesterday ntext, in tooolddef ntext, in sqlwhere ntext) BEGIN DECLARE Command ntext; SET Command = 'SELECT COUNT(DISTINCT(SA.AGENT_ID)) as anzahl, ''color'' = (CASE WHEN ' || yesterday || '> SA.CREATION_TIME THEN ''RED'' ELSE ''YELLOW'' END ) FROM V_AGENT_INCL_GROUP_ID SA with (NOLOCK) INNER JOIN V_GROUPS G ON G.ID=SA.GROUP_ID INNER JOIN V_DOMAINS S ON S.ID=SA.DOMAIN_ID LEFT OUTER JOIN SEM_CONTENT SC with (NOLOCK) on SC.AGENT_ID=SA.AGENT_ID LEFT OUTER JOIN V_IPS ON SC.PATTERN_IDX=V_IPS.PATTERN_IDX WHERE SA.AGENT_TYPE=''105'' AND SA.DELETED=0 and (V_IPS.DELETED=0 OR V_IPS.DELETED IS NULL) AND SA.STATUS=1 AND SA.MAJOR_VERSION>10 AND (( SA.MAJOR_VERSION = 11 AND SA.FIREWALL_ONOFF not in (2, 127)) OR ( SA.MAJOR_VERSION = 12 AND SA.MINOR_VERSION = 0 AND SA.FIREWALL_ONOFF not in (2, 127)) OR ( MAJOR_VERSION = 12 AND SA.MINOR_VERSION > 0 AND SA.CIDS_DRV_ONOFF not in (2, 127)) OR ( MAJOR_VERSION > 12 AND SA.CIDS_DRV_ONOFF not in (2, 127))) and SC.DELETED=0 ' || sqlwhere || ' GROUP BY (CASE WHEN ' || yesterday || '> SA.CREATION_TIME THEN ''RED'' ELSE ''YELLOW'' END) HAVING ( MAX(V_IPS.VERSION) IS NULL OR MAX(V_IPS.VERSION) <=''' || tooolddef || ''')'; EXECUTE IMMEDIATE WITH RESULT SET ON Command; END 2015-02-09 14:29:32.833 THREAD 27 INFO: DROP PROCEDURE SEM_HOMEPAGE_MRCLEAN_REDANDYELLOW 2015-02-09 14:29:32.842 THREAD 27 INFO: CREATE PROCEDURE SEM_HOMEPAGE_MRCLEAN_REDANDYELLOW( in yesterday ntext, in tooolddef ntext, in sqlwhere ntext) BEGIN DECLARE Command ntext; SET Command = 'SELECT COUNT(DISTINCT(SA.AGENT_ID)) as anzahl, ''color'' = (CASE WHEN ' || yesterday || ' > SA.CREATION_TIME THEN ''RED'' ELSE ''YELLOW'' END ) FROM V_AGENT_INCL_GROUP_ID SA with (NOLOCK) INNER JOIN V_GROUPS G ON G.ID=SA.GROUP_ID INNER JOIN V_DOMAINS S ON S.ID=SA.DOMAIN_ID LEFT OUTER JOIN SEM_CONTENT SC with (NOLOCK) on SC.AGENT_ID=SA.AGENT_ID LEFT OUTER JOIN V_MR_CLEAN ON SC.PATTERN_IDX=V_MR_CLEAN.PATTERN_IDX WHERE SA.AGENT_TYPE=''105'' AND SA.DELETED=0 and (V_MR_CLEAN.DELETED=0 OR V_MR_CLEAN.DELETED IS NULL) AND SA.STATUS=1 AND SA.MAJOR_VERSION>10 AND SA.DA_ONOFF not in (2, 127) AND SC.DELETED=0 ' || sqlwhere || ' GROUP BY (CASE WHEN ' || yesterday || ' > SA.CREATION_TIME THEN ''RED'' ELSE ''YELLOW'' END) HAVING ( MAX(V_MR_CLEAN.VERSION) IS NULL OR MAX(V_MR_CLEAN.VERSION) <=''' || tooolddef || ''')'; EXECUTE IMMEDIATE WITH RESULT SET ON Command; END 2015-02-09 14:29:32.900 THREAD 27 INFO: DROP PROCEDURE SEM_HOMEPAGE_DISABLED_COUNTS 2015-02-09 14:29:32.933 THREAD 27 INFO: CREATE PROCEDURE SEM_HOMEPAGE_DISABLED_COUNTS(in sqlfrom ntext, in sqlwhere ntext) BEGIN DECLARE Command ntext; SET Command = 'SELECT COUNT(*) as anzahl, (CAST(SA.AP_ONOFF as VARCHAR) + ''-'' + CAST(SA.DA_ONOFF as VARCHAR) + ''-'' + CAST(SA.FIREWALL_ONOFF as VARCHAR) + ''-'' + CAST(SA.PTP_ONOFF as VARCHAR) + ''-'' + CAST(case when SA.MAJOR_VERSION = 11 OR ( SA.MAJOR_VERSION = 12 AND SA.MINOR_VERSION = 0) then SA.FIREWALL_ONOFF else SA.CIDS_DRV_ONOFF end as VARCHAR)) as TECH_STATE FROM V_AGENT_INCL_GROUP_ID SA with (NOLOCK) ' || sqlfrom || ' WHERE (SA.AP_ONOFF in (0,4) or SA.DA_ONOFF in (0,4) or SA.PTP_ONOFF in (0,4) or SA.FIREWALL_ONOFF in (0,4) or SA.CIDS_DRV_ONOFF in (0,4)) and SA.DELETED=''0'' AND SA.STATUS=1 and SA.AGENT_TYPE=''105'' ' || sqlwhere || ' GROUP BY (CAST(SA.AP_ONOFF as VARCHAR) + ''-'' + CAST(SA.DA_ONOFF as VARCHAR) + ''-'' + CAST(SA.FIREWALL_ONOFF as VARCHAR) + ''-'' + CAST(SA.PTP_ONOFF as VARCHAR) + ''-'' + CAST(CASE when SA.MAJOR_VERSION = 11 OR ( SA.MAJOR_VERSION = 12 AND SA.MINOR_VERSION = 0) then SA.FIREWALL_ONOFF else SA.CIDS_DRV_ONOFF end as VARCHAR)) '; EXECUTE IMMEDIATE WITH RESULT SET ON Command; END 2015-02-09 14:29:32.958 THREAD 27 INFO: DROP PROCEDURE SEM_HOMEPAGE_TOTAL_TECH 2015-02-09 14:29:32.966 THREAD 27 INFO: CREATE PROCEDURE SEM_HOMEPAGE_TOTAL_TECH(in sqlfrom ntext, in sqlwhere ntext) BEGIN DECLARE Command ntext; SET Command = 'select count(*) as anzahl, (CAST(SA.AP_ONOFF as VARCHAR) + ''-'' + CAST(SA.DA_ONOFF as VARCHAR) + ''-'' + CAST(SA.FIREWALL_ONOFF as VARCHAR) + ''-'' + CAST(SA.PTP_ONOFF as VARCHAR) + ''-'' + CAST(case when SA.MAJOR_VERSION = 11 OR ( SA.MAJOR_VERSION = 12 AND SA.MINOR_VERSION = 0) then SA.FIREWALL_ONOFF else SA.CIDS_DRV_ONOFF end as VARCHAR)) as TECH_STATE from SEM_AGENT SA with (NOLOCK) ' || sqlfrom || ' where (SA.AP_ONOFF in (0,1,3,4) or SA.DA_ONOFF in (0,1,3,4) or SA.PTP_ONOFF in (0,1,3,4) or SA.FIREWALL_ONOFF in (0,1,3,4) or SA.CIDS_DRV_ONOFF in (0,1,3,4)) and SA.DELETED=''0'' and SA.AGENT_TYPE=''105'' ' || sqlwhere || ' GROUP BY (CAST(SA.AP_ONOFF as VARCHAR) + ''-'' + CAST(SA.DA_ONOFF as VARCHAR) + ''-'' + CAST(SA.FIREWALL_ONOFF as VARCHAR) + ''-'' + CAST(SA.PTP_ONOFF as VARCHAR) + ''-'' + CAST(CASE when SA.MAJOR_VERSION = 11 OR ( SA.MAJOR_VERSION = 12 AND SA.MINOR_VERSION = 0) then SA.FIREWALL_ONOFF else SA.CIDS_DRV_ONOFF end as VARCHAR)) '; EXECUTE IMMEDIATE WITH RESULT SET ON Command; END 2015-02-09 14:29:32.983 THREAD 27 INFO: drop view V_CLIENT_CHANGE_LOG 2015-02-09 14:29:33.009 THREAD 27 INFO: CREATE VIEW V_CLIENT_CHANGE_LOG as SELECT ATL.CLIENT_ID, ATL.COMPUTER_ID, ATL.DOMAIN_ID, ATL.GROUP_ID, V.SERVER_ID, V.TIME_STAMP, ATL.POLICY_MODE, ATL.DELETED, ATL.COMPUTER_NAME, ATL.COMPUTER_DOMAIN_NAME, ATL.USER_NAME, ATL.USER_DOMAIN_NAME, V.EVENT_ID FROM SEM_CLIENT ATL with (NOLOCK) INNER JOIN V_SERVER_ADMIN_LOG V with (NOLOCK) on ATL.CLIENT_ID=V.CLIENT_ID where V.EVENT_ID in (0x2006, 0x2007, 0x2008, 0x2009, 0x200A, 0x200C, 0x200D, 0x200E, 0x200F, 0x2010, 0x2014, 0x2015, 0x2016) UNION SELECT ATL.CLIENT_ID, ATL.COMPUTER_ID, ATL.DOMAIN_ID, ATL.GROUP_ID, V.SERVER_ID, V.TIME_STAMP, ATL.POLICY_MODE, ATL.DELETED, ATL.COMPUTER_NAME, ATL.COMPUTER_DOMAIN_NAME, ATL.USER_NAME, ATL.USER_DOMAIN_NAME, V.EVENT_ID FROM SEM_CLIENT ATL with (NOLOCK) INNER JOIN V_SERVER_CLIENT_LOG V with (NOLOCK) on ATL.CLIENT_ID=V.CLIENT_ID where V.EVENT_ID in (0x0E, 0x19, 0x1A) UNION SELECT DISTINCT ATL.CLIENT_ID, ATL.COMPUTER_ID,ATL.DOMAIN_ID, ATL.GROUP_ID, V.SERVER_ID, ATL.CREATION_TIME as TIME_STAMP, ATL.POLICY_MODE, ATL.DELETED, ATL.COMPUTER_NAME, ATL.COMPUTER_DOMAIN_NAME, ATL.USER_NAME, ATL.USER_DOMAIN_NAME, EVENT_ID = 12287 FROM SEM_CLIENT ATL with (NOLOCK) LEFT OUTER JOIN V_SERVER_ADMIN_LOG V with (NOLOCK) on ATL.CLIENT_ID=V.CLIENT_ID where ((ATL.CLIENT_ID NOT IN (SELECT SC.CLIENT_ID FROM SEM_CLIENT SC with (NOLOCK) INNER JOIN V_SERVER_CLIENT_LOG VSCL ON SC.CLIENT_ID=VSCL.CLIENT_ID where VSCL.EVENT_ID is not null and VSCL.EVENT_ID IN (0x1A))) AND (V.EVENT_ID is null)) 2015-02-09 14:29:33.050 THREAD 27 INFO: IF NOT EXISTS (SELECT C.NAME FROM SYSOBJECTS S, SYSCOLUMNS C WHERE C.ID = S.ID AND S.NAME = 'SEM_COMPUTER' AND C.NAME='KERNEL') BEGIN ALTER TABLE SEM_COMPUTER ADD KERNEL NVARCHAR(256) NULL END 2015-02-09 14:29:33.079 THREAD 27 INFO: IF NOT EXISTS (SELECT OS_NAME FROM SEM_OS_INFO WHERE OPERATING_SYSTEM = 'Red Hat Enterprise Linux Server') INSERT INTO SEM_OS_INFO (OPERATING_SYSTEM, OS_NAME, OS_TYPE, SPC_OS_NAME, SPC_OS_TYPE, OS_MAJOR, OS_MINOR, SPC_OS_VERSION, OS_FAMILY, DELETED, USN, TIME_STAMP, I18N_KEY) VALUES ('Red Hat Enterprise Linux Server', 'Red Hat', 'Server', 'Red Hat', 'Server', 6, 3, '6.3', 3,0,1,0, 'LINUX_REDHAT_SERVER') 2015-02-09 14:29:33.080 THREAD 27 INFO: IF NOT EXISTS (SELECT OS_NAME FROM SEM_OS_INFO WHERE OPERATING_SYSTEM = 'Fedora') INSERT INTO SEM_OS_INFO (OPERATING_SYSTEM, OS_NAME, OS_TYPE, SPC_OS_NAME, SPC_OS_TYPE, OS_MAJOR, OS_MINOR, SPC_OS_VERSION, OS_FAMILY, DELETED, USN, TIME_STAMP, I18N_KEY) VALUES ('Fedora', 'Fedora', '', 'Fedora', '', 17, 0, '17.0', 3,0,1,0, 'LINUX_FEDORA') 2015-02-09 14:29:33.081 THREAD 27 INFO: IF NOT EXISTS (SELECT OS_NAME FROM SEM_OS_INFO WHERE OPERATING_SYSTEM = 'SUSE Linux Enterprise Server') INSERT INTO SEM_OS_INFO (OPERATING_SYSTEM, OS_NAME, OS_TYPE, SPC_OS_NAME, SPC_OS_TYPE, OS_MAJOR, OS_MINOR, SPC_OS_VERSION, OS_FAMILY, DELETED, USN, TIME_STAMP, I18N_KEY) VALUES ('SUSE Linux Enterprise Server', 'SUSE', 'Server', 'SUSE', 'Server', 11, 2, '11.2', 3,0,1,0, 'LINUX_SUSE_SERVER') 2015-02-09 14:29:33.082 THREAD 27 INFO: IF NOT EXISTS (SELECT OS_NAME FROM SEM_OS_INFO WHERE OPERATING_SYSTEM = 'SUSE Linux Enterprise Desktop') INSERT INTO SEM_OS_INFO (OPERATING_SYSTEM, OS_NAME, OS_TYPE, SPC_OS_NAME, SPC_OS_TYPE, OS_MAJOR, OS_MINOR, SPC_OS_VERSION, OS_FAMILY, DELETED, USN, TIME_STAMP, I18N_KEY) VALUES ('SUSE Linux Enterprise Desktop', 'SUSE', 'Desktop', 'SUSE', 'Desktop', 11, 2, '11.2', 3,0,1,0, 'LINUX_SUSE_DESKTOP') 2015-02-09 14:29:33.082 THREAD 27 INFO: IF NOT EXISTS (SELECT OS_NAME FROM SEM_OS_INFO WHERE OPERATING_SYSTEM = 'Ubuntu Server') INSERT INTO SEM_OS_INFO (OPERATING_SYSTEM, OS_NAME, OS_TYPE, SPC_OS_NAME, SPC_OS_TYPE, OS_MAJOR, OS_MINOR, SPC_OS_VERSION, OS_FAMILY, DELETED, USN, TIME_STAMP, I18N_KEY) VALUES ('Ubuntu Server', 'Ubuntu', 'Server', 'Ubuntu', 'Server', 12, 4, '12.4', 3,0,1,0, 'LINUX_UBUNTU_SERVER') 2015-02-09 14:29:33.083 THREAD 27 INFO: IF NOT EXISTS (SELECT OS_NAME FROM SEM_OS_INFO WHERE OPERATING_SYSTEM = 'Ubuntu Desktop') INSERT INTO SEM_OS_INFO (OPERATING_SYSTEM, OS_NAME, OS_TYPE, SPC_OS_NAME, SPC_OS_TYPE, OS_MAJOR, OS_MINOR, SPC_OS_VERSION, OS_FAMILY, DELETED, USN, TIME_STAMP, I18N_KEY) VALUES ('Ubuntu Desktop', 'Ubuntu', 'Desktop', 'Ubuntu', 'Desktop', 12, 4, '12.4', 3,0,1,0, 'LINUX_UBUNTU_DESKTOP') 2015-02-09 14:29:33.084 THREAD 27 INFO: IF NOT EXISTS (SELECT OS_NAME FROM SEM_OS_INFO WHERE OPERATING_SYSTEM = 'Debian') INSERT INTO SEM_OS_INFO (OPERATING_SYSTEM, OS_NAME, OS_TYPE, SPC_OS_NAME, SPC_OS_TYPE, OS_MAJOR, OS_MINOR, SPC_OS_VERSION, OS_FAMILY, DELETED, USN, TIME_STAMP, I18N_KEY) VALUES ('Debian', 'Debian', '', 'Debian', '', 6, 0, '6.0', 3,0,1,0, 'LINUX_DEBIAN') 2015-02-09 14:29:33.085 THREAD 27 INFO: IF NOT EXISTS (SELECT OS_NAME FROM SEM_OS_INFO WHERE OPERATING_SYSTEM = 'Oracle Linux Server') INSERT INTO SEM_OS_INFO (OPERATING_SYSTEM, OS_NAME, OS_TYPE, SPC_OS_NAME, SPC_OS_TYPE, OS_MAJOR, OS_MINOR, SPC_OS_VERSION, OS_FAMILY, DELETED, USN, TIME_STAMP, I18N_KEY) VALUES ('Oracle Linux Server', 'Oracle', 'Server', 'Oracle', 'Server', 5, 8, '5.8', 3,0,1,0, 'LINUX_ORACLE_SERVER') 2015-02-09 14:29:33.086 THREAD 27 INFO: IF NOT EXISTS (SELECT OS_NAME FROM SEM_OS_INFO WHERE OPERATING_SYSTEM = 'CentOS') INSERT INTO SEM_OS_INFO (OPERATING_SYSTEM, OS_NAME, OS_TYPE, SPC_OS_NAME, SPC_OS_TYPE, OS_MAJOR, OS_MINOR, SPC_OS_VERSION, OS_FAMILY, DELETED, USN, TIME_STAMP, I18N_KEY) VALUES ('CentOS', 'CentOS', '', 'CentOS', '', 2, 6, '2.6', 3,0,1,0, 'LINUX_CENTOS') 2015-02-09 14:29:33.086 THREAD 27 INFO: ALTER TABLE COMPUTER_APPLICATION MODIFY DELETED DEFAULT 0 2015-02-09 14:29:33.526 THREAD 27 INFO: ALTER TABLE SEM_APPLICATION MODIFY DELETED DEFAULT 0 2015-02-09 14:29:33.834 THREAD 27 INFO: ALTER TABLE SCANS MODIFY VSIC_SCAN DEFAULT 0 2015-02-09 14:29:34.117 THREAD 27 INFO: DROP VIEW V_SEM_COMPUTER 2015-02-09 14:29:34.167 THREAD 27 INFO: CREATE VIEW V_SEM_COMPUTER AS SELECT *, CAST((case when DNS_SERVER1 < 0 then 0xFFFFFFFF + DNS_SERVER1 else DNS_SERVER1 end / 256 / 256 / 256) & 0xFF as VARCHAR) + '.' + CAST((case when DNS_SERVER1 < 0 then 0xFFFFFFFF + DNS_SERVER1 else DNS_SERVER1 end / 256 / 256) & 0xFF as VARCHAR) + '.' + CAST((case when DNS_SERVER1 < 0 then 0xFFFFFFFF + DNS_SERVER1 else DNS_SERVER1 end / 256) & 0xFF as VARCHAR) + '.' + CAST( case when DNS_SERVER1 < 0 then 0xFFFFFFFF + DNS_SERVER1 else DNS_SERVER1 end & 0xFF as VARCHAR) as DNS_SERVER1_TEXT, CAST((case when DNS_SERVER2 < 0 then 0xFFFFFFFF + DNS_SERVER2 else DNS_SERVER2 end / 256 / 256 / 256) & 0xFF as VARCHAR) + '.' + CAST((case when DNS_SERVER2 < 0 then 0xFFFFFFFF + DNS_SERVER2 else DNS_SERVER2 end / 256 / 256) & 0xFF as VARCHAR) + '.' + CAST((case when DNS_SERVER2 < 0 then 0xFFFFFFFF + DNS_SERVER2 else DNS_SERVER2 end / 256) & 0xFF as VARCHAR) + '.' + CAST( case when DNS_SERVER2 < 0 then 0xFFFFFFFF + DNS_SERVER2 else DNS_SERVER2 end & 0xFF as VARCHAR) as DNS_SERVER2_TEXT, CAST((case when WINS_SERVER1 < 0 then 0xFFFFFFFF + WINS_SERVER1 else WINS_SERVER1 end / 256 / 256 / 256) & 0xFF as VARCHAR) + '.' + CAST((case when WINS_SERVER1 < 0 then 0xFFFFFFFF + WINS_SERVER1 else WINS_SERVER1 end / 256 / 256) & 0xFF as VARCHAR) + '.' + CAST((case when WINS_SERVER1 < 0 then 0xFFFFFFFF + WINS_SERVER1 else WINS_SERVER1 end / 256) & 0xFF as VARCHAR) + '.' + CAST( case when WINS_SERVER1 < 0 then 0xFFFFFFFF + WINS_SERVER1 else WINS_SERVER1 end & 0xFF as VARCHAR) as WINS_SERVER1_TEXT, CAST((case when WINS_SERVER2 < 0 then 0xFFFFFFFF + WINS_SERVER2 else WINS_SERVER2 end / 256 / 256 / 256) & 0xFF as VARCHAR) + '.' + CAST((case when WINS_SERVER2 < 0 then 0xFFFFFFFF + WINS_SERVER2 else WINS_SERVER2 end / 256 / 256) & 0xFF as VARCHAR) + '.' + CAST((case when WINS_SERVER2 < 0 then 0xFFFFFFFF + WINS_SERVER2 else WINS_SERVER2 end / 256) & 0xFF as VARCHAR) + '.' + CAST( case when WINS_SERVER2 < 0 then 0xFFFFFFFF + WINS_SERVER2 else WINS_SERVER2 end & 0xFF as VARCHAR) as WINS_SERVER2_TEXT, CAST((case when DHCP_SERVER < 0 then 0xFFFFFFFF + DHCP_SERVER else DHCP_SERVER end / 256 / 256 / 256) & 0xFF as VARCHAR) + '.' + CAST((case when DHCP_SERVER < 0 then 0xFFFFFFFF + DHCP_SERVER else DHCP_SERVER end / 256 / 256) & 0xFF as VARCHAR) + '.' + CAST((case when DHCP_SERVER < 0 then 0xFFFFFFFF + DHCP_SERVER else DHCP_SERVER end / 256) & 0xFF as VARCHAR) + '.' + CAST( case when DHCP_SERVER < 0 then 0xFFFFFFFF + DHCP_SERVER else DHCP_SERVER end & 0xFF as VARCHAR) as DHCP_SERVER_TEXT, CAST((case when IP_ADDR1 < 0 then 0xFFFFFFFF + IP_ADDR1 else IP_ADDR1 end / 256 / 256 / 256) & 0xFF as VARCHAR) + '.' + CAST((case when IP_ADDR1 < 0 then 0xFFFFFFFF + IP_ADDR1 else IP_ADDR1 end / 256 / 256) & 0xFF as VARCHAR) + '.' + CAST((case when IP_ADDR1 < 0 then 0xFFFFFFFF + IP_ADDR1 else IP_ADDR1 end / 256) & 0xFF as VARCHAR) + '.' + CAST( case when IP_ADDR1 < 0 then 0xFFFFFFFF + IP_ADDR1 else IP_ADDR1 end & 0xFF as VARCHAR) as IP_ADDR1_TEXT, CAST((case when GATEWAY1 < 0 then 0xFFFFFFFF + GATEWAY1 else GATEWAY1 end / 256 / 256 / 256) & 0xFF as VARCHAR) + '.' + CAST((case when GATEWAY1 < 0 then 0xFFFFFFFF + GATEWAY1 else GATEWAY1 end / 256 / 256) & 0xFF as VARCHAR) + '.' + CAST((case when GATEWAY1 < 0 then 0xFFFFFFFF + GATEWAY1 else GATEWAY1 end / 256) & 0xFF as VARCHAR) + '.' + CAST( case when GATEWAY1 < 0 then 0xFFFFFFFF + GATEWAY1 else GATEWAY1 end & 0xFF as VARCHAR) as GATEWAY1_TEXT, CAST((case when SUBNET_MASK1 < 0 then 0xFFFFFFFF + SUBNET_MASK1 else SUBNET_MASK1 end / 256 / 256 / 256) & 0xFF as VARCHAR) + '.' + CAST((case when SUBNET_MASK1 < 0 then 0xFFFFFFFF + SUBNET_MASK1 else SUBNET_MASK1 end / 256 / 256) & 0xFF as VARCHAR) + '.' + CAST((case when SUBNET_MASK1 < 0 then 0xFFFFFFFF + SUBNET_MASK1 else SUBNET_MASK1 end / 256) & 0xFF as VARCHAR) + '.' + CAST( case when SUBNET_MASK1 < 0 then 0xFFFFFFFF + SUBNET_MASK1 else SUBNET_MASK1 end & 0xFF as VARCHAR) as SUBNET_MASK1_TEXT, CAST((case when IP_ADDR2 < 0 then 0xFFFFFFFF + IP_ADDR2 else IP_ADDR2 end / 256 / 256 / 256) & 0xFF as VARCHAR) + '.' + CAST((case when IP_ADDR2 < 0 then 0xFFFFFFFF + IP_ADDR2 else IP_ADDR2 end / 256 / 256) & 0xFF as VARCHAR) + '.' + CAST((case when IP_ADDR2 < 0 then 0xFFFFFFFF + IP_ADDR2 else IP_ADDR2 end / 256) & 0xFF as VARCHAR) + '.' + CAST( case when IP_ADDR2 < 0 then 0xFFFFFFFF + IP_ADDR2 else IP_ADDR2 end & 0xFF as VARCHAR) as IP_ADDR2_TEXT, CAST((case when GATEWAY2 < 0 then 0xFFFFFFFF + GATEWAY2 else GATEWAY2 end / 256 / 256 / 256) & 0xFF as VARCHAR) + '.' + CAST((case when GATEWAY2 < 0 then 0xFFFFFFFF + GATEWAY2 else GATEWAY2 end / 256 / 256) & 0xFF as VARCHAR) + '.' + CAST((case when GATEWAY2 < 0 then 0xFFFFFFFF + GATEWAY2 else GATEWAY2 end / 256) & 0xFF as VARCHAR) + '.' + CAST( case when GATEWAY2 < 0 then 0xFFFFFFFF + GATEWAY2 else GATEWAY2 end & 0xFF as VARCHAR) as GATEWAY2_TEXT, CAST((case when SUBNET_MASK2 < 0 then 0xFFFFFFFF + SUBNET_MASK2 else SUBNET_MASK2 end / 256 / 256 / 256) & 0xFF as VARCHAR) + '.' + CAST((case when SUBNET_MASK2 < 0 then 0xFFFFFFFF + SUBNET_MASK2 else SUBNET_MASK2 end / 256 / 256) & 0xFF as VARCHAR) + '.' + CAST((case when SUBNET_MASK2 < 0 then 0xFFFFFFFF + SUBNET_MASK2 else SUBNET_MASK2 end / 256) & 0xFF as VARCHAR) + '.' + CAST( case when SUBNET_MASK2 < 0 then 0xFFFFFFFF + SUBNET_MASK2 else SUBNET_MASK2 end & 0xFF as VARCHAR) as SUBNET_MASK2_TEXT, CAST((case when IP_ADDR3 < 0 then 0xFFFFFFFF + IP_ADDR3 else IP_ADDR3 end / 256 / 256 / 256) & 0xFF as VARCHAR) + '.' + CAST((case when IP_ADDR3 < 0 then 0xFFFFFFFF + IP_ADDR3 else IP_ADDR3 end / 256 / 256) & 0xFF as VARCHAR) + '.' + CAST((case when IP_ADDR3 < 0 then 0xFFFFFFFF + IP_ADDR3 else IP_ADDR3 end / 256) & 0xFF as VARCHAR) + '.' + CAST( case when IP_ADDR3 < 0 then 0xFFFFFFFF + IP_ADDR3 else IP_ADDR3 end & 0xFF as VARCHAR) as IP_ADDR3_TEXT, CAST((case when GATEWAY3 < 0 then 0xFFFFFFFF + GATEWAY3 else GATEWAY3 end / 256 / 256 / 256) & 0xFF as VARCHAR) + '.' + CAST((case when GATEWAY3 < 0 then 0xFFFFFFFF + GATEWAY3 else GATEWAY3 end / 256 / 256) & 0xFF as VARCHAR) + '.' + CAST((case when GATEWAY3 < 0 then 0xFFFFFFFF + GATEWAY3 else GATEWAY3 end / 256) & 0xFF as VARCHAR) + '.' + CAST( case when GATEWAY3 < 0 then 0xFFFFFFFF + GATEWAY3 else GATEWAY3 end & 0xFF as VARCHAR) as GATEWAY3_TEXT, CAST((case when SUBNET_MASK3 < 0 then 0xFFFFFFFF + SUBNET_MASK3 else SUBNET_MASK3 end / 256 / 256 / 256) & 0xFF as VARCHAR) + '.' + CAST((case when SUBNET_MASK3 < 0 then 0xFFFFFFFF + SUBNET_MASK3 else SUBNET_MASK3 end / 256 / 256) & 0xFF as VARCHAR) + '.' + CAST((case when SUBNET_MASK3 < 0 then 0xFFFFFFFF + SUBNET_MASK3 else SUBNET_MASK3 end / 256) & 0xFF as VARCHAR) + '.' + CAST( case when SUBNET_MASK3 < 0 then 0xFFFFFFFF + SUBNET_MASK3 else SUBNET_MASK3 end & 0xFF as VARCHAR) as SUBNET_MASK3_TEXT, CAST((case when IP_ADDR4 < 0 then 0xFFFFFFFF + IP_ADDR4 else IP_ADDR4 end / 256 / 256 / 256) & 0xFF as VARCHAR) + '.' + CAST((case when IP_ADDR4 < 0 then 0xFFFFFFFF + IP_ADDR4 else IP_ADDR4 end / 256 / 256) & 0xFF as VARCHAR) + '.' + CAST((case when IP_ADDR4 < 0 then 0xFFFFFFFF + IP_ADDR4 else IP_ADDR4 end / 256) & 0xFF as VARCHAR) + '.' + CAST( case when IP_ADDR4 < 0 then 0xFFFFFFFF + IP_ADDR4 else IP_ADDR4 end & 0xFF as VARCHAR) as IP_ADDR4_TEXT, CAST((case when GATEWAY4 < 0 then 0xFFFFFFFF + GATEWAY4 else GATEWAY4 end / 256 / 256 / 256) & 0xFF as VARCHAR) + '.' + CAST((case when GATEWAY4 < 0 then 0xFFFFFFFF + GATEWAY4 else GATEWAY4 end / 256 / 256) & 0xFF as VARCHAR) + '.' + CAST((case when GATEWAY4 < 0 then 0xFFFFFFFF + GATEWAY4 else GATEWAY4 end / 256) & 0xFF as VARCHAR) + '.' + CAST( case when GATEWAY4 < 0 then 0xFFFFFFFF + GATEWAY4 else GATEWAY4 end & 0xFF as VARCHAR) as GATEWAY4_TEXT, CAST((case when SUBNET_MASK4 < 0 then 0xFFFFFFFF + SUBNET_MASK4 else SUBNET_MASK4 end / 256 / 256 / 256) & 0xFF as VARCHAR) + '.' + CAST((case when SUBNET_MASK4 < 0 then 0xFFFFFFFF + SUBNET_MASK4 else SUBNET_MASK4 end / 256 / 256) & 0xFF as VARCHAR) + '.' + CAST((case when SUBNET_MASK4 < 0 then 0xFFFFFFFF + SUBNET_MASK4 else SUBNET_MASK4 end / 256) & 0xFF as VARCHAR) + '.' + CAST( case when SUBNET_MASK4 < 0 then 0xFFFFFFFF + SUBNET_MASK4 else SUBNET_MASK4 end & 0xFF as VARCHAR) as SUBNET_MASK4_TEXT FROM SEM_COMPUTER WHERE DELETED=0 2015-02-09 14:29:34.225 THREAD 27 INFO: DROP VIEW V_SEM_SVA_COMPUTER_NAME 2015-02-09 14:29:34.234 THREAD 27 INFO: CREATE VIEW V_SEM_SVA_COMPUTER_NAME as SELECT S.SVA_ID, S.STATUS, C.COMPUTER_NAME, C.IP_ADDR1_TEXT FROM SEM_SVA as S with (nolock) LEFT OUTER JOIN V_SEM_SVA_COMPUTER as C WITH (NOLOCK) ON S.COMPUTER_ID = C.COMPUTER_ID WHERE S.DELETED=0 2015-02-09 14:29:34.258 THREAD 27 INFO: IF NOT EXISTS (SELECT COLUMN_NAME FROM SYSTABLE T, SYSCOLUMN C WHERE T.TABLE_ID=C.TABLE_ID AND T.TABLE_NAME='SEM_COMPUTER' AND COLUMN_NAME = 'UUID' ) ALTER TABLE SEM_COMPUTER ADD UUID varchar(128) NULL 2015-02-09 14:29:34.261 THREAD 27 INFO: /* defect 3508795, adjusting datatype and length of the column to match definition of fresh install*/ IF NOT EXISTS (SELECT COLUMN_NAME FROM SYSTABLE T, SYSCOLUMN C WHERE T.TABLE_ID=C.TABLE_ID AND T.TABLE_NAME='ALERTS' AND COLUMN_NAME = 'SCAN_GUID_IDX' ) ALTER TABLE ALERTS ADD SCAN_GUID_IDX varchar(32) NULL 2015-02-09 14:29:34.262 THREAD 27 INFO: IF NOT EXISTS (SELECT COLUMN_NAME FROM SYSTABLE T, SYSCOLUMN C WHERE T.TABLE_ID=C.TABLE_ID AND T.TABLE_NAME='HPP_ALERTS' AND COLUMN_NAME = 'SHOULD_REMEDIATE' ) ALTER TABLE HPP_ALERTS ADD SHOULD_REMEDIATE tinyint NULL 2015-02-09 14:29:34.264 THREAD 27 INFO: IF NOT EXISTS (SELECT PARAMETER FROM GUIPARMS WHERE PARAMETER = 'latest_smr_defs' ) INSERT INTO GUIPARMS (GUIPARMS_IDX, PARAMETER, VALUE) VALUES (75, 'latest_smr_defs', '') 2015-02-09 14:29:34.267 THREAD 27 INFO: IF NOT EXISTS (SELECT COLUMN_NAME FROM SYSTABLE T, SYSCOLUMN C WHERE T.TABLE_ID=C.TABLE_ID AND T.TABLE_NAME='SCANREPORT' AND COLUMN_NAME = 'SCAN_TYPE' ) ALTER TABLE SCANREPORT ADD SCAN_TYPE VARCHAR(64) NULL 2015-02-09 14:29:34.269 THREAD 27 INFO: IF NOT EXISTS (SELECT COLUMN_NAME FROM SYSTABLE T, SYSCOLUMN C WHERE T.TABLE_ID=C.TABLE_ID AND T.TABLE_NAME='AGENT_TRAFFIC_LOG_1' AND COLUMN_NAME = 'NESTED_PROTOCOL_TYPE' ) ALTER TABLE AGENT_TRAFFIC_LOG_1 ADD NESTED_PROTOCOL_TYPE CHAR(32) NULL 2015-02-09 14:29:34.271 THREAD 27 INFO: IF NOT EXISTS (SELECT COLUMN_NAME FROM SYSTABLE T, SYSCOLUMN C WHERE T.TABLE_ID=C.TABLE_ID AND T.TABLE_NAME='AGENT_TRAFFIC_LOG_1' AND COLUMN_NAME = 'NESTED_PROTOCOL_SUB_TYPE' ) ALTER TABLE AGENT_TRAFFIC_LOG_1 ADD NESTED_PROTOCOL_SUB_TYPE CHAR(32) NULL 2015-02-09 14:29:34.273 THREAD 27 INFO: IF NOT EXISTS (SELECT COLUMN_NAME FROM SYSTABLE T, SYSCOLUMN C WHERE T.TABLE_ID=C.TABLE_ID AND T.TABLE_NAME='AGENT_TRAFFIC_LOG_2' AND COLUMN_NAME = 'NESTED_PROTOCOL_TYPE' ) ALTER TABLE AGENT_TRAFFIC_LOG_2 ADD NESTED_PROTOCOL_TYPE CHAR(32) NULL 2015-02-09 14:29:34.274 THREAD 27 INFO: IF NOT EXISTS (SELECT COLUMN_NAME FROM SYSTABLE T, SYSCOLUMN C WHERE T.TABLE_ID=C.TABLE_ID AND T.TABLE_NAME='AGENT_TRAFFIC_LOG_2' AND COLUMN_NAME = 'NESTED_PROTOCOL_SUB_TYPE' ) ALTER TABLE AGENT_TRAFFIC_LOG_2 ADD NESTED_PROTOCOL_SUB_TYPE CHAR(32) NULL 2015-02-09 14:29:34.277 THREAD 27 INFO: DROP VIEW V_AGENT_INCL_RISK_INFO 2015-02-09 14:29:34.342 THREAD 27 INFO: CREATE VIEW V_AGENT_INCL_RISK_INFO AS SELECT *, POWERERASER_PENDING.ALERTS_COUNT AS POWERERASER_PENDING_ALERTS FROM SEM_AGENT SA with (NOLOCK) LEFT JOIN (SELECT COUNT(A.ALERT_IDX) AS ALERTS_COUNT,A.COMPUTER_IDX FROM ALERTS A with (NOLOCK) WHERE A.SOURCE='PowerEraser' AND A.ACTUALACTION_IDX=14 AND A.DELETED=0 AND A.Mother_Idx = '' AND (DATEDIFF(day,A.ALERTDATETIME, GETDATE()) < 30) GROUP BY A.COMPUTER_IDX) AS POWERERASER_PENDING ON POWERERASER_PENDING.COMPUTER_IDX = SA.COMPUTER_ID 2015-02-09 14:29:34.383 THREAD 27 INFO: drop view V_AGENT_TRAFFIC_LOG 2015-02-09 14:29:34.417 THREAD 27 INFO: CREATE VIEW V_AGENT_TRAFFIC_LOG as SELECT *, CASE WHEN LOCAL_HOST_IPV6 IS NOT NULL AND LEN(TRIM(LOCAL_HOST_IPV6)) > 0 THEN substring(LOCAL_HOST_IPV6, 1, 4 ) + ':' + substring(LOCAL_HOST_IPV6, 5, 4 ) + ':' + substring(LOCAL_HOST_IPV6, 9, 4 ) + ':' + substring(LOCAL_HOST_IPV6, 13, 4 ) + ':' + substring(LOCAL_HOST_IPV6, 17, 4 ) + ':' + substring(LOCAL_HOST_IPV6, 21, 4 ) + ':' + substring(LOCAL_HOST_IPV6, 25,4 ) + ':' + substring(LOCAL_HOST_IPV6, 29, 4 ) ELSE CAST((case when LOCAL_HOST_IP < 0 then 0xFFFFFFFF + LOCAL_HOST_IP else LOCAL_HOST_IP end / 256 / 256 / 256) & 0xFF as VARCHAR) + '.' + CAST((case when LOCAL_HOST_IP < 0 then 0xFFFFFFFF + LOCAL_HOST_IP else LOCAL_HOST_IP end / 256 / 256) & 0xFF as VARCHAR) + '.' + CAST((case when LOCAL_HOST_IP < 0 then 0xFFFFFFFF + LOCAL_HOST_IP else LOCAL_HOST_IP end / 256) & 0xFF as VARCHAR) + '.' + CAST( case when LOCAL_HOST_IP < 0 then 0xFFFFFFFF + LOCAL_HOST_IP else LOCAL_HOST_IP end & 0xFF as VARCHAR) END as LOCAL_HOST_IP_TEXT , CASE WHEN REMOTE_HOST_IPV6 IS NOT NULL AND LEN(TRIM(REMOTE_HOST_IPV6)) > 0 THEN substring(REMOTE_HOST_IPV6, 1, 4 ) + ':' + substring(REMOTE_HOST_IPV6, 5, 4 ) + ':' + substring(REMOTE_HOST_IPV6, 9, 4 ) + ':' + substring(REMOTE_HOST_IPV6, 13, 4 ) + ':' + substring(REMOTE_HOST_IPV6, 17, 4 ) + ':' + substring(REMOTE_HOST_IPV6, 21, 4 ) + ':' + substring(REMOTE_HOST_IPV6, 25,4 ) + ':' + substring(REMOTE_HOST_IPV6, 29, 4 ) ELSE CAST((case when REMOTE_HOST_IP < 0 then 0xFFFFFFFF + REMOTE_HOST_IP else REMOTE_HOST_IP end / 256 / 256 / 256) & 0xFF as VARCHAR) + '.' + CAST((case when REMOTE_HOST_IP < 0 then 0xFFFFFFFF + REMOTE_HOST_IP else REMOTE_HOST_IP end / 256 / 256) & 0xFF as VARCHAR) + '.' + CAST((case when REMOTE_HOST_IP < 0 then 0xFFFFFFFF + REMOTE_HOST_IP else REMOTE_HOST_IP end / 256) & 0xFF as VARCHAR) + '.' + CAST( case when REMOTE_HOST_IP < 0 then 0xFFFFFFFF + REMOTE_HOST_IP else REMOTE_HOST_IP end & 0xFF as VARCHAR) END as REMOTE_HOST_IP_TEXT FROM AGENT_TRAFFIC_LOG_1 UNION ALL SELECT *, CASE WHEN LOCAL_HOST_IPV6 IS NOT NULL AND LEN(TRIM(LOCAL_HOST_IPV6)) > 0 THEN substring(LOCAL_HOST_IPV6, 1, 4 ) + ':' + substring(LOCAL_HOST_IPV6, 5, 4 ) + ':' + substring(LOCAL_HOST_IPV6, 9, 4 ) + ':' + substring(LOCAL_HOST_IPV6, 13, 4 ) + ':' + substring(LOCAL_HOST_IPV6, 17, 4 ) + ':' + substring(LOCAL_HOST_IPV6, 21, 4 ) + ':' + substring(LOCAL_HOST_IPV6, 25,4 ) + ':' + substring(LOCAL_HOST_IPV6, 29, 4 ) ELSE CAST((case when LOCAL_HOST_IP < 0 then 0xFFFFFFFF + LOCAL_HOST_IP else LOCAL_HOST_IP end / 256 / 256 / 256) & 0xFF as VARCHAR) + '.' + CAST((case when LOCAL_HOST_IP < 0 then 0xFFFFFFFF + LOCAL_HOST_IP else LOCAL_HOST_IP end / 256 / 256) & 0xFF as VARCHAR) + '.' + CAST((case when LOCAL_HOST_IP < 0 then 0xFFFFFFFF + LOCAL_HOST_IP else LOCAL_HOST_IP end / 256) & 0xFF as VARCHAR) + '.' + CAST( case when LOCAL_HOST_IP < 0 then 0xFFFFFFFF + LOCAL_HOST_IP else LOCAL_HOST_IP end & 0xFF as VARCHAR) END as LOCAL_HOST_IP_TEXT , CASE WHEN REMOTE_HOST_IPV6 IS NOT NULL AND LEN(TRIM(REMOTE_HOST_IPV6)) > 0 THEN substring(REMOTE_HOST_IPV6, 1, 4 ) + ':' + substring(REMOTE_HOST_IPV6, 5, 4 ) + ':' + substring(REMOTE_HOST_IPV6, 9, 4 ) + ':' + substring(REMOTE_HOST_IPV6, 13, 4 ) + ':' + substring(REMOTE_HOST_IPV6, 17, 4 ) + ':' + substring(REMOTE_HOST_IPV6, 21, 4 ) + ':' + substring(REMOTE_HOST_IPV6, 25,4 ) + ':' + substring(REMOTE_HOST_IPV6, 29, 4 ) ELSE CAST((case when REMOTE_HOST_IP < 0 then 0xFFFFFFFF + REMOTE_HOST_IP else REMOTE_HOST_IP end / 256 / 256 / 256) & 0xFF as VARCHAR) + '.' + CAST((case when REMOTE_HOST_IP < 0 then 0xFFFFFFFF + REMOTE_HOST_IP else REMOTE_HOST_IP end / 256 / 256) & 0xFF as VARCHAR) + '.' + CAST((case when REMOTE_HOST_IP < 0 then 0xFFFFFFFF + REMOTE_HOST_IP else REMOTE_HOST_IP end / 256) & 0xFF as VARCHAR) + '.' + CAST( case when REMOTE_HOST_IP < 0 then 0xFFFFFFFF + REMOTE_HOST_IP else REMOTE_HOST_IP end & 0xFF as VARCHAR) END as REMOTE_HOST_IP_TEXT FROM AGENT_TRAFFIC_LOG_2 2015-02-09 14:29:34.458 THREAD 27 INFO: IF NOT EXISTS (SELECT COLUMN_NAME FROM SYSTABLE T, SYSCOLUMN C WHERE T.TABLE_ID=C.TABLE_ID AND T.TABLE_NAME='COMPLIANCE_REPORT' AND COLUMN_NAME = 'LOCAL_IP_ADDRESS' ) ALTER TABLE COMPLIANCE_REPORT ADD LOCAL_IP_ADDRESS NVARCHAR(255) NULL 2015-02-09 14:29:34.460 THREAD 27 INFO: IF NOT EXISTS (SELECT COLUMN_NAME FROM SYSTABLE T, SYSCOLUMN C WHERE T.TABLE_ID=C.TABLE_ID AND T.TABLE_NAME='FIREWALL_REPORT' AND COLUMN_NAME = 'LOCAL_IP_ADDRESS' ) ALTER TABLE FIREWALL_REPORT ADD LOCAL_IP_ADDRESS NVARCHAR(255) NULL 2015-02-09 14:29:34.463 THREAD 27 INFO: IF NOT EXISTS (SELECT ACTUALACTION FROM ACTUALACTION WHERE ACTUALACTION_IDX = 25 ) INSERT INTO ACTUALACTION (ACTUALACTION_IDX, ACTUALACTION) VALUES (25, 'RepairFailedPowerEraser2') 2015-02-09 14:29:34.465 THREAD 27 INFO: IF NOT EXISTS (SELECT COLUMN_NAME FROM SYSTABLE T, SYSCOLUMN C WHERE T.TABLE_ID=C.TABLE_ID AND T.TABLE_NAME='COMMAND' AND COLUMN_NAME = 'RESULT') BEGIN ALTER TABLE COMMAND ADD RESULT NTEXT NULL END 2015-02-09 14:29:34.467 THREAD 27 INFO: Process SQL script file:Embedded12RU4MP1ToFerrariPCCIndexes.sql 2015-02-09 14:29:34.467 THREAD 27 INFO: Process SQL InputStream sqlis:sun.net.www.protocol.jar.JarURLConnection$JarURLInputStream@12d0266 2015-02-09 14:29:34.468 THREAD 27 INFO: DatabaseUtilities> execCommandFromScript>> cmdSeperator : ;; , sqlStr : IF EXISTS (SELECT NAME FROM SYSINDEXES WHERE NAME = 'I_AGENT_PACKET_LOG_1_ALERT' ) BEGIN DROP INDEX AGENT_PACKET_LOG_1.I_AGENT_PACKET_LOG_1_ALERT END 2015-02-09 14:29:34.468 THREAD 27 INFO: IF EXISTS (SELECT NAME FROM SYSINDEXES WHERE NAME = 'I_AGENT_PACKET_LOG_1_ALERT' ) BEGIN DROP INDEX AGENT_PACKET_LOG_1.I_AGENT_PACKET_LOG_1_ALERT END 2015-02-09 14:29:34.479 THREAD 27 INFO: IF EXISTS (SELECT NAME FROM SYSINDEXES WHERE NAME = 'I_AGENT_PACKET_LOG_2_ALERT' ) BEGIN DROP INDEX AGENT_PACKET_LOG_2.I_AGENT_PACKET_LOG_2_ALERT END 2015-02-09 14:29:34.483 THREAD 27 INFO: IF EXISTS (SELECT NAME FROM SYSINDEXES WHERE NAME = 'I_AGENT_TRAFFIC_LOG_1_ALERT' ) BEGIN DROP INDEX AGENT_TRAFFIC_LOG_1.I_AGENT_TRAFFIC_LOG_1_ALERT END 2015-02-09 14:29:34.488 THREAD 27 INFO: IF EXISTS (SELECT NAME FROM SYSINDEXES WHERE NAME = 'I_AGENT_TRAFFIC_LOG_2_ALERT' ) BEGIN DROP INDEX AGENT_TRAFFIC_LOG_2.I_AGENT_TRAFFIC_LOG_2_ALERT END 2015-02-09 14:29:34.493 THREAD 27 INFO: IF EXISTS (SELECT NAME FROM SYSINDEXES WHERE NAME = 'I_SERVER_SYSTEM_LOG_1_ID' ) BEGIN DROP INDEX SERVER_SYSTEM_LOG_1.I_SERVER_SYSTEM_LOG_1_ID END 2015-02-09 14:29:34.497 THREAD 27 INFO: IF EXISTS (SELECT NAME FROM SYSINDEXES WHERE NAME = 'I_SERVER_SYSTEM_LOG_2_ID' ) BEGIN DROP INDEX SERVER_SYSTEM_LOG_2.I_SERVER_SYSTEM_LOG_2_ID END 2015-02-09 14:29:34.501 THREAD 27 INFO: IF EXISTS (SELECT NAME FROM SYSINDEXES WHERE NAME = 'I_SERVER_ADMIN_LOG_1_ID' ) BEGIN DROP INDEX SERVER_ADMIN_LOG_1.I_SERVER_ADMIN_LOG_1_ID END 2015-02-09 14:29:34.506 THREAD 27 INFO: IF EXISTS (SELECT NAME FROM SYSINDEXES WHERE NAME = 'I_SERVER_ADMIN_LOG_2_ID' ) BEGIN DROP INDEX SERVER_ADMIN_LOG_2.I_SERVER_ADMIN_LOG_2_ID END 2015-02-09 14:29:34.510 THREAD 27 INFO: IF EXISTS (SELECT NAME FROM SYSINDEXES WHERE NAME = 'I_SERVER_CLIENT_LOG_1_ID' ) BEGIN DROP INDEX SERVER_CLIENT_LOG_1.I_SERVER_CLIENT_LOG_1_ID END 2015-02-09 14:29:34.514 THREAD 27 INFO: IF EXISTS (SELECT NAME FROM SYSINDEXES WHERE NAME = 'I_SERVER_CLIENT_LOG_2_ID' ) BEGIN DROP INDEX SERVER_CLIENT_LOG_2.I_SERVER_CLIENT_LOG_2_ID END 2015-02-09 14:29:34.518 THREAD 27 INFO: IF EXISTS (SELECT NAME FROM SYSINDEXES WHERE NAME = 'I_SERVER_ENFORCER_LOG_1_ID' ) BEGIN DROP INDEX SERVER_ENFORCER_LOG_1.I_SERVER_ENFORCER_LOG_1_ID END 2015-02-09 14:29:34.523 THREAD 27 INFO: IF EXISTS (SELECT NAME FROM SYSINDEXES WHERE NAME = 'I_SERVER_ENFORCER_LOG_2_ID' ) BEGIN DROP INDEX SERVER_ENFORCER_LOG_2.I_SERVER_ENFORCER_LOG_2_ID END 2015-02-09 14:29:34.527 THREAD 27 INFO: IF EXISTS (SELECT NAME FROM SYSINDEXES WHERE NAME = 'I_SERVER_POLICY_LOG_1_ID' ) BEGIN DROP INDEX SERVER_POLICY_LOG_1.I_SERVER_POLICY_LOG_1_ID END 2015-02-09 14:29:34.531 THREAD 27 INFO: IF EXISTS (SELECT NAME FROM SYSINDEXES WHERE NAME = 'I_SERVER_POLICY_LOG_2_ID' ) BEGIN DROP INDEX SERVER_POLICY_LOG_2.I_SERVER_POLICY_LOG_2_ID END 2015-02-09 14:29:34.535 THREAD 27 INFO: IF EXISTS (SELECT NAME FROM SYSINDEXES WHERE NAME = 'I_AGENT_SECURITY_LOG_1_ID' ) BEGIN DROP INDEX AGENT_SECURITY_LOG_1.I_AGENT_SECURITY_LOG_1_ID END 2015-02-09 14:29:34.540 THREAD 27 INFO: IF EXISTS (SELECT NAME FROM SYSINDEXES WHERE NAME = 'I_AGENT_SECURITY_LOG_2_ID' ) BEGIN DROP INDEX AGENT_SECURITY_LOG_2.I_AGENT_SECURITY_LOG_2_ID END 2015-02-09 14:29:34.544 THREAD 27 INFO: IF EXISTS (SELECT NAME FROM SYSINDEXES WHERE NAME = 'I_AGENT_SYSTEM_LOG_1_ID' ) BEGIN DROP INDEX AGENT_SYSTEM_LOG_1.I_AGENT_SYSTEM_LOG_1_ID END 2015-02-09 14:29:34.550 THREAD 27 INFO: IF EXISTS (SELECT NAME FROM SYSINDEXES WHERE NAME = 'I_AGENT_SYSTEM_LOG_2_ID' ) BEGIN DROP INDEX AGENT_SYSTEM_LOG_2.I_AGENT_SYSTEM_LOG_2_ID END 2015-02-09 14:29:34.554 THREAD 27 INFO: IF EXISTS (SELECT NAME FROM SYSINDEXES WHERE NAME = 'I_AGENT_TRAFFIC_LOG_1_ID' ) BEGIN DROP INDEX AGENT_TRAFFIC_LOG_1.I_AGENT_TRAFFIC_LOG_1_ID END 2015-02-09 14:29:34.559 THREAD 27 INFO: IF EXISTS (SELECT NAME FROM SYSINDEXES WHERE NAME = 'I_AGENT_TRAFFIC_LOG_2_ID' ) BEGIN DROP INDEX AGENT_TRAFFIC_LOG_2.I_AGENT_TRAFFIC_LOG_2_ID END 2015-02-09 14:29:34.563 THREAD 27 INFO: IF EXISTS (SELECT NAME FROM SYSINDEXES WHERE NAME = 'I_AGENT_PACKET_LOG_1_ID' ) BEGIN DROP INDEX AGENT_PACKET_LOG_1.I_AGENT_PACKET_LOG_1_ID END 2015-02-09 14:29:34.568 THREAD 27 INFO: IF EXISTS (SELECT NAME FROM SYSINDEXES WHERE NAME = 'I_AGENT_PACKET_LOG_2_ID' ) BEGIN DROP INDEX AGENT_PACKET_LOG_2.I_AGENT_PACKET_LOG_2_ID END 2015-02-09 14:29:34.573 THREAD 27 INFO: IF EXISTS (SELECT NAME FROM SYSINDEXES WHERE NAME = 'I_AGENT_BEHAVIOR_LOG_1_ID' ) BEGIN DROP INDEX AGENT_BEHAVIOR_LOG_1.I_AGENT_BEHAVIOR_LOG_1_ID END 2015-02-09 14:29:34.578 THREAD 27 INFO: IF EXISTS (SELECT NAME FROM SYSINDEXES WHERE NAME = 'I_AGENT_BEHAVIOR_LOG_2_ID' ) BEGIN DROP INDEX AGENT_BEHAVIOR_LOG_2.I_AGENT_BEHAVIOR_LOG_2_ID END 2015-02-09 14:29:34.582 THREAD 27 INFO: IF EXISTS (SELECT NAME FROM SYSINDEXES WHERE NAME = 'I_ENFORCER_CLIENT_LOG_1_ID' ) DROP INDEX ENFORCER_CLIENT_LOG_1.I_ENFORCER_CLIENT_LOG_1_ID 2015-02-09 14:29:34.586 THREAD 27 INFO: IF EXISTS (SELECT NAME FROM SYSINDEXES WHERE NAME = 'I_ENFORCER_CLIENT_LOG_2_ID' ) DROP INDEX ENFORCER_CLIENT_LOG_2.I_ENFORCER_CLIENT_LOG_2_ID 2015-02-09 14:29:34.590 THREAD 27 INFO: IF EXISTS (SELECT NAME FROM SYSINDEXES WHERE NAME = 'I_ENFORCER_SYSTEM_LOG_1_ID' ) DROP INDEX ENFORCER_SYSTEM_LOG_1.I_ENFORCER_SYSTEM_LOG_1_ID 2015-02-09 14:29:34.595 THREAD 27 INFO: IF EXISTS (SELECT NAME FROM SYSINDEXES WHERE NAME = 'I_ENFORCER_SYSTEM_LOG_2_ID' ) DROP INDEX ENFORCER_SYSTEM_LOG_2.I_ENFORCER_SYSTEM_LOG_2_ID 2015-02-09 14:29:34.599 THREAD 27 INFO: IF EXISTS (SELECT NAME FROM SYSINDEXES WHERE NAME = 'A_ALERTS_MOTHER_IDX_PLUS' ) DROP INDEX ALERTS.A_ALERTS_MOTHER_IDX_PLUS 2015-02-09 14:29:34.604 THREAD 27 INFO: IF EXISTS (SELECT NAME FROM SYSINDEXES WHERE NAME = 'I_ALERTS_ACTUALACTION_IDX' ) DROP INDEX ALERTS.I_ALERTS_ACTUALACTION_IDX 2015-02-09 14:29:34.609 THREAD 27 INFO: IF EXISTS (SELECT NAME FROM SYSINDEXES WHERE NAME = 'I_ALERTS_ACTUALACTION_IDX_PLUS' ) DROP INDEX ALERTS.I_ALERTS_ACTUALACTION_IDX_PLUS 2015-02-09 14:29:34.613 THREAD 27 INFO: IF EXISTS (SELECT NAME FROM SYSINDEXES WHERE NAME = 'I_ALERTS_ALERT_IDX' ) DROP INDEX ALERTS.I_ALERTS_ALERT_IDX 2015-02-09 14:29:34.618 THREAD 27 INFO: IF EXISTS (SELECT NAME FROM SYSINDEXES WHERE NAME = 'I_ALERTS_ALERTDATETIME_DEL' ) DROP INDEX ALERTS.I_ALERTS_ALERTDATETIME_DEL 2015-02-09 14:29:34.622 THREAD 27 INFO: IF EXISTS (SELECT NAME FROM SYSINDEXES WHERE NAME = 'I_ALERTS_ALERTDATETIME_PLUS' ) DROP INDEX ALERTS.I_ALERTS_ALERTDATETIME_PLUS 2015-02-09 14:29:34.626 THREAD 27 INFO: IF EXISTS (SELECT NAME FROM SYSINDEXES WHERE NAME = 'I_ALERTS_COMPUTER_IDX' ) DROP INDEX ALERTS.I_ALERTS_COMPUTER_IDX 2015-02-09 14:29:34.631 THREAD 27 INFO: IF EXISTS (SELECT NAME FROM SYSINDEXES WHERE NAME = 'I_ALERTS_HPP_APP_IDX' ) DROP INDEX ALERTS.I_ALERTS_HPP_APP_IDX 2015-02-09 14:29:34.635 THREAD 27 INFO: IF EXISTS (SELECT NAME FROM SYSINDEXES WHERE NAME = 'I_ALERTS_HPP_APP_IDX_PLUS' ) DROP INDEX ALERTS.I_ALERTS_HPP_APP_IDX_PLUS 2015-02-09 14:29:34.639 THREAD 27 INFO: IF EXISTS (SELECT NAME FROM SYSINDEXES WHERE NAME = 'I_ALERTS_MOTHER_IDX' ) DROP INDEX ALERTS.I_ALERTS_MOTHER_IDX 2015-02-09 14:29:34.643 THREAD 27 INFO: IF EXISTS (SELECT NAME FROM SYSINDEXES WHERE NAME = 'I_ALERTS_SOURCE' ) DROP INDEX ALERTS.I_ALERTS_SOURCE 2015-02-09 14:29:34.648 THREAD 27 INFO: IF EXISTS (SELECT NAME FROM SYSINDEXES WHERE NAME = 'I_ALERTS_SOURCE_PLUS' ) DROP INDEX ALERTS.I_ALERTS_SOURCE_PLUS 2015-02-09 14:29:34.663 THREAD 27 INFO: IF EXISTS (SELECT NAME FROM SYSINDEXES WHERE NAME = 'I_ALERTS_SOURCE_ALERT_IDX' ) DROP INDEX ALERTS.I_ALERTS_SOURCE_ALERT_IDX 2015-02-09 14:29:34.683 THREAD 27 INFO: CREATE INDEX I_ALERTS_SOURCE_ALERT_IDX ON ALERTS(ALERTDATETIME, COMPUTER_IDX, MOTHER_IDX, SOURCE, ALERT_IDX, DELETED) 2015-02-09 14:29:34.700 THREAD 27 INFO: IF EXISTS (SELECT NAME FROM SYSINDEXES WHERE NAME = 'I_SEM_COMPUTER_DELETED' ) DROP INDEX SEM_COMPUTER.I_SEM_COMPUTER_DELETED 2015-02-09 14:29:34.708 THREAD 27 INFO: CREATE INDEX I_SEM_COMPUTER_DELETED ON SEM_COMPUTER(DELETED, COMPUTER_ID, COMPUTER_NAME, IP_ADDR1) 2015-02-09 14:29:34.717 THREAD 27 INFO: Process SQL script file:EmbeddedFerrariPCCToFerrariAlpha.sql 2015-02-09 14:29:34.717 THREAD 27 INFO: Process SQL InputStream sqlis:sun.net.www.protocol.jar.JarURLConnection$JarURLInputStream@119d8e4 2015-02-09 14:29:34.717 THREAD 27 INFO: DatabaseUtilities> execCommandFromScript>> cmdSeperator : ;; , sqlStr : IF NOT EXISTS (SELECT COLUMN_NAME FROM SYSTABLE T, SYSCOLUMN C WHERE T.TABLE_ID=C.TABLE_ID AND T.TABLE_NAME='OAUTH_CLIENT_DETAILS' AND COLUMN_NAME = 'ACTIVATION_CODE') BEGIN ALTER TABLE OAUTH_CLIENT_DETAILS ADD ACTIVATION_CODE VARCHAR(256) END 2015-02-09 14:29:34.717 THREAD 27 INFO: IF NOT EXISTS (SELECT COLUMN_NAME FROM SYSTABLE T, SYSCOLUMN C WHERE T.TABLE_ID=C.TABLE_ID AND T.TABLE_NAME='OAUTH_CLIENT_DETAILS' AND COLUMN_NAME = 'ACTIVATION_CODE') BEGIN ALTER TABLE OAUTH_CLIENT_DETAILS ADD ACTIVATION_CODE VARCHAR(256) END 2015-02-09 14:29:34.720 THREAD 27 INFO: IF NOT EXISTS (SELECT COLUMN_NAME FROM SYSTABLE T, SYSCOLUMN C WHERE T.TABLE_ID=C.TABLE_ID AND T.TABLE_NAME='OAUTH_CLIENT_DETAILS' AND COLUMN_NAME = 'ACTIVATION_CODE_EXPIRE_DATE') BEGIN ALTER TABLE OAUTH_CLIENT_DETAILS ADD ACTIVATION_CODE_EXPIRE_DATE DATETIME END 2015-02-09 14:29:34.722 THREAD 27 INFO: IF NOT EXISTS (SELECT COLUMN_NAME FROM SYSTABLE T, SYSCOLUMN C WHERE T.TABLE_ID=C.TABLE_ID AND T.TABLE_NAME='OAUTH_CLIENT_DETAILS' AND COLUMN_NAME = 'PARTNER_ID') BEGIN ALTER TABLE OAUTH_CLIENT_DETAILS ADD PARTNER_ID CHAR(32) END 2015-02-09 14:29:34.723 THREAD 27 INFO: /* New table for maintaining trusted partner records */ DROP TABLE OAUTH_TRUSTED_PARTNER 2015-02-09 14:29:34.734 THREAD 27 INFO: CREATE TABLE OAUTH_TRUSTED_PARTNER ( PARTNER_ID CHAR(32) NOT NULL, PARTNER_NAME VARCHAR(64) NOT NULL, PARTNER_CODE VARCHAR(256) NOT NULL, CONSTRAINT PK_OAUTH_TRUSTED_PARTNER PRIMARY KEY (PARTNER_ID), CONSTRAINT UK_OAUTH_TRUSTED_PARTNER_PARTNER_NAME UNIQUE (PARTNER_NAME) ) 2015-02-09 14:29:34.741 THREAD 27 INFO: DROP TABLE PROCESSING_MARKER 2015-02-09 14:29:34.759 THREAD 27 INFO: CREATE TABLE PROCESSING_MARKER ( TABLE_NAME NVARCHAR(256) NOT NULL, BATCH_SIZE BIGINT NOT NULL, LAST_STATUS TINYINT NULL,/* -1 FAILED, 0 SUCCEEDED, 1 RUNNING */ LAST_SERVER_ID CHAR(32) NOT NULL, LAST_START_VALUE BIGINT NOT NULL, LAST_END_VALUE BIGINT NULL, LAST_START_TIME BIGINT NOT NULL, LAST_DURATION_IN_SECONDS BIGINT NULL, LAST_ERROR_MSG NVARCHAR(2000) NULL, NEXT_START_VALUE BIGINT NULL, CONSTRAINT PK_PROCESSING_MARKER PRIMARY KEY (TABLE_NAME) ) 2015-02-09 14:29:34.766 THREAD 27 INFO: IF NOT EXISTS(SELECT 1 FROM OAUTH_TRUSTED_PARTNER WHERE PARTNER_NAME = 'Symantec Managed Security Services') INSERT INTO OAUTH_TRUSTED_PARTNER(PARTNER_ID, PARTNER_NAME, PARTNER_CODE) SELECT REPLACE(CAST(NEWID() AS VARCHAR(36)), '-', ''), 'Symantec Managed Security Services' , CAST(NEWID() AS VARCHAR(36)) 2015-02-09 14:29:34.770 THREAD 27 INFO: IF NOT EXISTS (SELECT COLUMN_NAME FROM SYSTABLE T, SYSCOLUMN C WHERE T.TABLE_ID=C.TABLE_ID AND T.TABLE_NAME='AGENT_SECURITY_LOG_1' AND COLUMN_NAME = 'SEQ_ID') BEGIN ALTER TABLE AGENT_SECURITY_LOG_1 ADD SEQ_ID BIGINT not NULL IDENTITY END 2015-02-09 14:29:34.772 THREAD 27 INFO: IF NOT EXISTS (SELECT COLUMN_NAME FROM SYSTABLE T, SYSCOLUMN C WHERE T.TABLE_ID=C.TABLE_ID AND T.TABLE_NAME='AGENT_SECURITY_LOG_2' AND COLUMN_NAME = 'SEQ_ID') BEGIN ALTER TABLE AGENT_SECURITY_LOG_2 ADD SEQ_ID BIGINT not NULL IDENTITY END 2015-02-09 14:29:34.773 THREAD 27 INFO: /* Create non clustered index to avoid performance side effect during upgrade, test result is unstable*/ IF NOT EXISTS (SELECT NAME FROM SYSINDEXES WHERE NAME = 'I_AGENT_SECURITY_LOG_1_SEQ_ID' ) CREATE INDEX I_AGENT_SECURITY_LOG_1_SEQ_ID ON AGENT_SECURITY_LOG_1(SEQ_ID) 2015-02-09 14:29:34.778 THREAD 27 INFO: IF NOT EXISTS (SELECT NAME FROM SYSINDEXES WHERE NAME = 'I_AGENT_SECURITY_LOG_2_SEQ_ID' ) CREATE INDEX I_AGENT_SECURITY_LOG_2_SEQ_ID ON AGENT_SECURITY_LOG_2(SEQ_ID) 2015-02-09 14:29:34.782 THREAD 27 INFO: drop view V_AGENT_SECURITY_LOG 2015-02-09 14:29:34.825 THREAD 27 INFO: CREATE VIEW V_AGENT_SECURITY_LOG as SELECT *, CASE WHEN LOCAL_HOST_IPV6 IS NOT NULL AND LEN(TRIM(LOCAL_HOST_IPV6)) > 0 THEN substring(LOCAL_HOST_IPV6, 1, 4 ) + ':' + substring(LOCAL_HOST_IPV6, 5, 4 ) + ':' + substring(LOCAL_HOST_IPV6, 9, 4 ) + ':' + substring(LOCAL_HOST_IPV6, 13, 4 ) + ':' + substring(LOCAL_HOST_IPV6, 17, 4 ) + ':' + substring(LOCAL_HOST_IPV6, 21, 4 ) + ':' + substring(LOCAL_HOST_IPV6, 25,4 ) + ':' + substring(LOCAL_HOST_IPV6, 29, 4 ) ELSE CAST((case when LOCAL_HOST_IP < 0 then 0xFFFFFFFF + LOCAL_HOST_IP else LOCAL_HOST_IP end / 256 / 256 / 256) & 0xFF as VARCHAR) + '.' + CAST((case when LOCAL_HOST_IP < 0 then 0xFFFFFFFF + LOCAL_HOST_IP else LOCAL_HOST_IP end / 256 / 256) & 0xFF as VARCHAR) + '.' + CAST((case when LOCAL_HOST_IP < 0 then 0xFFFFFFFF + LOCAL_HOST_IP else LOCAL_HOST_IP end / 256) & 0xFF as VARCHAR) + '.' + CAST( case when LOCAL_HOST_IP < 0 then 0xFFFFFFFF + LOCAL_HOST_IP else LOCAL_HOST_IP end & 0xFF as VARCHAR) END as LOCAL_HOST_IP_TEXT , CASE WHEN REMOTE_HOST_IPV6 IS NOT NULL AND LEN(TRIM(REMOTE_HOST_IPV6)) > 0 THEN substring(REMOTE_HOST_IPV6, 1, 4 ) + ':' + substring(REMOTE_HOST_IPV6, 5, 4 ) + ':' + substring(REMOTE_HOST_IPV6, 9, 4 ) + ':' + substring(REMOTE_HOST_IPV6, 13, 4 ) + ':' + substring(REMOTE_HOST_IPV6, 17, 4 ) + ':' + substring(REMOTE_HOST_IPV6, 21, 4 ) + ':' + substring(REMOTE_HOST_IPV6, 25,4 ) + ':' + substring(REMOTE_HOST_IPV6, 29, 4 ) ELSE CAST((case when REMOTE_HOST_IP < 0 then 0xFFFFFFFF + REMOTE_HOST_IP else REMOTE_HOST_IP end / 256 / 256 / 256) & 0xFF as VARCHAR) + '.' + CAST((case when REMOTE_HOST_IP < 0 then 0xFFFFFFFF + REMOTE_HOST_IP else REMOTE_HOST_IP end / 256 / 256) & 0xFF as VARCHAR) + '.' + CAST((case when REMOTE_HOST_IP < 0 then 0xFFFFFFFF + REMOTE_HOST_IP else REMOTE_HOST_IP end / 256) & 0xFF as VARCHAR) + '.' + CAST( case when REMOTE_HOST_IP < 0 then 0xFFFFFFFF + REMOTE_HOST_IP else REMOTE_HOST_IP end & 0xFF as VARCHAR) END as REMOTE_HOST_IP_TEXT FROM AGENT_SECURITY_LOG_1 UNION ALL SELECT *, CASE WHEN LOCAL_HOST_IPV6 IS NOT NULL AND LEN(TRIM(LOCAL_HOST_IPV6)) > 0 THEN substring(LOCAL_HOST_IPV6, 1, 4 ) + ':' + substring(LOCAL_HOST_IPV6, 5, 4 ) + ':' + substring(LOCAL_HOST_IPV6, 9, 4 ) + ':' + substring(LOCAL_HOST_IPV6, 13, 4 ) + ':' + substring(LOCAL_HOST_IPV6, 17, 4 ) + ':' + substring(LOCAL_HOST_IPV6, 21, 4 ) + ':' + substring(LOCAL_HOST_IPV6, 25,4 ) + ':' + substring(LOCAL_HOST_IPV6, 29, 4 ) ELSE CAST((case when LOCAL_HOST_IP < 0 then 0xFFFFFFFF + LOCAL_HOST_IP else LOCAL_HOST_IP end / 256 / 256 / 256) & 0xFF as VARCHAR) + '.' + CAST((case when LOCAL_HOST_IP < 0 then 0xFFFFFFFF + LOCAL_HOST_IP else LOCAL_HOST_IP end / 256 / 256) & 0xFF as VARCHAR) + '.' + CAST((case when LOCAL_HOST_IP < 0 then 0xFFFFFFFF + LOCAL_HOST_IP else LOCAL_HOST_IP end / 256) & 0xFF as VARCHAR) + '.' + CAST( case when LOCAL_HOST_IP < 0 then 0xFFFFFFFF + LOCAL_HOST_IP else LOCAL_HOST_IP end & 0xFF as VARCHAR) END as LOCAL_HOST_IP_TEXT , CASE WHEN REMOTE_HOST_IPV6 IS NOT NULL AND LEN(TRIM(REMOTE_HOST_IPV6)) > 0 THEN substring(REMOTE_HOST_IPV6, 1, 4 ) + ':' + substring(REMOTE_HOST_IPV6, 5, 4 ) + ':' + substring(REMOTE_HOST_IPV6, 9, 4 ) + ':' + substring(REMOTE_HOST_IPV6, 13, 4 ) + ':' + substring(REMOTE_HOST_IPV6, 17, 4 ) + ':' + substring(REMOTE_HOST_IPV6, 21, 4 ) + ':' + substring(REMOTE_HOST_IPV6, 25,4 ) + ':' + substring(REMOTE_HOST_IPV6, 29, 4 ) ELSE CAST((case when REMOTE_HOST_IP < 0 then 0xFFFFFFFF + REMOTE_HOST_IP else REMOTE_HOST_IP end / 256 / 256 / 256) & 0xFF as VARCHAR) + '.' + CAST((case when REMOTE_HOST_IP < 0 then 0xFFFFFFFF + REMOTE_HOST_IP else REMOTE_HOST_IP end / 256 / 256) & 0xFF as VARCHAR) + '.' + CAST((case when REMOTE_HOST_IP < 0 then 0xFFFFFFFF + REMOTE_HOST_IP else REMOTE_HOST_IP end / 256) & 0xFF as VARCHAR) + '.' + CAST( case when REMOTE_HOST_IP < 0 then 0xFFFFFFFF + REMOTE_HOST_IP else REMOTE_HOST_IP end & 0xFF as VARCHAR) END as REMOTE_HOST_IP_TEXT FROM AGENT_SECURITY_LOG_2 2015-02-09 14:29:34.867 THREAD 27 INFO: Process SQL script file:EmbeddedFerrariAlphaToFerrariBeta.sql 2015-02-09 14:29:34.867 THREAD 27 INFO: Process SQL InputStream sqlis:sun.net.www.protocol.jar.JarURLConnection$JarURLInputStream@1f7049c 2015-02-09 14:29:34.867 THREAD 27 INFO: DatabaseUtilities> execCommandFromScript>> cmdSeperator : ;; , sqlStr : DROP TABLE AUDIT_LOG 2015-02-09 14:29:34.867 THREAD 27 INFO: DROP TABLE AUDIT_LOG 2015-02-09 14:29:34.884 THREAD 27 INFO: CREATE TABLE AUDIT_LOG( SEQ_ID BIGINT NOT NULL IDENTITY CONSTRAINT PK_AUDITLOG PRIMARY KEY CLUSTERED, TIMESTAMP BIGINT NOT NULL, METHOD varchar(256) NOT NULL, ARGUMENTS nvarchar(32767) NOT NULL, ADMIN_ID binary(16) NOT NULL, IP_ADDR varchar(128) NOT NULL ) 2015-02-09 14:29:34.891 THREAD 27 INFO: CREATE INDEX I_AUDIT_TIMESTAMP ON AUDIT_LOG (TIMESTAMP) 2015-02-09 14:29:34.900 THREAD 27 INFO: DROP VIEW V_AUDIT_SYS_ADMIN 2015-02-09 14:29:34.909 THREAD 27 INFO: CREATE VIEW V_AUDIT_SYS_ADMIN AS SELECT strtobin(x.Ids) AS Id, x.IdS, x.Name, x.EmailAddress FROM ( SELECT CAST(m.CONTENT AS XML) AS XmlData FROM BASIC_METADATA m, WHERE TYPE = 'SysAdministratorArray' ) AS t, openxml( t.XmlData, '/SysAdministratorArray/SemAdministrator') WITH ( IdS VARCHAR(32) './@Id', Name NVARCHAR(128) './@Name', EmailAddress NVARCHAR(256) './@EmailAddress' ) AS x 2015-02-09 14:29:34.925 THREAD 27 INFO: DROP VIEW V_AUDIT_LIMITED_ADMIN 2015-02-09 14:29:34.934 THREAD 27 INFO: CREATE VIEW V_AUDIT_LIMITED_ADMIN AS SELECT strtobin(x.Ids) AS Id, x.IdS, x.Name, x.EmailAddress FROM ( SELECT CAST(m.CONTENT AS XML) AS XmlData FROM BASIC_METADATA m, WHERE TYPE = 'AdminContext' ) AS t, openxml( t.XmlData, '/AdminContext/SemAdministrator') WITH ( IdS VARCHAR(32) './@Id', Name NVARCHAR(128) './@Name', EmailAddress NVARCHAR(256) './@EmailAddress' ) AS x 2015-02-09 14:29:34.950 THREAD 27 INFO: DROP VIEW V_AUDIT_LOG 2015-02-09 14:29:34.959 THREAD 27 INFO: CREATE VIEW V_AUDIT_LOG as select A.TIMESTAMP, A.METHOD, A.ARGUMENTS, A.IP_ADDR, X.NAME, X.EMAILADDRESS FROM AUDIT_LOG A LEFT JOIN (select * from V_AUDIT_SYS_ADMIN UNION ALL select * from V_AUDIT_LIMITED_ADMIN) as X ON A.ADMIN_ID=X.ID 2015-02-09 14:29:34.983 THREAD 27 INFO: ALTER PROCEDURE S_UPDATE_VIRUS_CATEGORY (@InputXml TEXT) AS BEGIN CREATE TABLE #VirusTable (n NVARCHAR(255), c INT, d DATETIME) DECLARE @DefaultDate DATETIME, @DefaultCategory INT SELECT @DefaultDate = '1970-01-01', @DefaultCategory=1 INSERT INTO #VirusTable (n, c, d) SELECT n, (case when c = null or c = 0 then @DefaultCategory else c end) , ISNULL(d,@DefaultDate) FROM OPENXML(@InputXml, '/savfeed/r') WITH (n NVARCHAR(256) 'n', c INT 'c', d DATETIME 'd') IF NOT EXISTS(SELECT 1 FROM #VirusTable) raiserror 17001 "Invalid input data" UPDATE VIRUS SET CATEGORY = t.c, DISCOVERED = t.d FROM VIRUS v INNER JOIN #VirusTable t ON v.VIRUSNAME = t.n WHERE (TYPE in( 0,2,3) OR TYPE is null) UPDATE VIRUS SET CATEGORY = @DefaultCategory, DISCOVERED = @DefaultDate FROM VIRUS v with (UPDLOCK) LEFT OUTER JOIN #VirusTable t ON v.VIRUSNAME = t.n WHERE t.n IS NULL AND (TYPE in( 0,2,3) OR TYPE is null) UPDATE VIRUS SET MAXCATEGORY = CATEGORY FROM VIRUS v WHERE CATEGORY > MAXCATEGORY AND (TYPE in( 0,2,3) OR TYPE is null) DROP TABLE #VirusTable END 2015-02-09 14:29:35.000 THREAD 27 INFO: /* defect 3508795, adjusting datatype and length of the column to match definition of fresh install*/ ALTER TABLE SEM_COMPUTER MODIFY OPERATION_SYSTEM nvarchar(512) NULL 2015-02-09 14:29:35.509 THREAD 27 INFO: ALTER TABLE SEM_SVA_COMPUTER MODIFY OPERATION_SYSTEM nvarchar(512) NULL 2015-02-09 14:29:35.942 THREAD 27 INFO: /* re-create the view after alterning table*/ DROP VIEW V_SEM_COMPUTER 2015-02-09 14:29:35.992 THREAD 27 INFO: CREATE VIEW V_SEM_COMPUTER AS SELECT *, CAST((case when DNS_SERVER1 < 0 then 0xFFFFFFFF + DNS_SERVER1 else DNS_SERVER1 end / 256 / 256 / 256) & 0xFF as VARCHAR) + '.' + CAST((case when DNS_SERVER1 < 0 then 0xFFFFFFFF + DNS_SERVER1 else DNS_SERVER1 end / 256 / 256) & 0xFF as VARCHAR) + '.' + CAST((case when DNS_SERVER1 < 0 then 0xFFFFFFFF + DNS_SERVER1 else DNS_SERVER1 end / 256) & 0xFF as VARCHAR) + '.' + CAST( case when DNS_SERVER1 < 0 then 0xFFFFFFFF + DNS_SERVER1 else DNS_SERVER1 end & 0xFF as VARCHAR) as DNS_SERVER1_TEXT, CAST((case when DNS_SERVER2 < 0 then 0xFFFFFFFF + DNS_SERVER2 else DNS_SERVER2 end / 256 / 256 / 256) & 0xFF as VARCHAR) + '.' + CAST((case when DNS_SERVER2 < 0 then 0xFFFFFFFF + DNS_SERVER2 else DNS_SERVER2 end / 256 / 256) & 0xFF as VARCHAR) + '.' + CAST((case when DNS_SERVER2 < 0 then 0xFFFFFFFF + DNS_SERVER2 else DNS_SERVER2 end / 256) & 0xFF as VARCHAR) + '.' + CAST( case when DNS_SERVER2 < 0 then 0xFFFFFFFF + DNS_SERVER2 else DNS_SERVER2 end & 0xFF as VARCHAR) as DNS_SERVER2_TEXT, CAST((case when WINS_SERVER1 < 0 then 0xFFFFFFFF + WINS_SERVER1 else WINS_SERVER1 end / 256 / 256 / 256) & 0xFF as VARCHAR) + '.' + CAST((case when WINS_SERVER1 < 0 then 0xFFFFFFFF + WINS_SERVER1 else WINS_SERVER1 end / 256 / 256) & 0xFF as VARCHAR) + '.' + CAST((case when WINS_SERVER1 < 0 then 0xFFFFFFFF + WINS_SERVER1 else WINS_SERVER1 end / 256) & 0xFF as VARCHAR) + '.' + CAST( case when WINS_SERVER1 < 0 then 0xFFFFFFFF + WINS_SERVER1 else WINS_SERVER1 end & 0xFF as VARCHAR) as WINS_SERVER1_TEXT, CAST((case when WINS_SERVER2 < 0 then 0xFFFFFFFF + WINS_SERVER2 else WINS_SERVER2 end / 256 / 256 / 256) & 0xFF as VARCHAR) + '.' + CAST((case when WINS_SERVER2 < 0 then 0xFFFFFFFF + WINS_SERVER2 else WINS_SERVER2 end / 256 / 256) & 0xFF as VARCHAR) + '.' + CAST((case when WINS_SERVER2 < 0 then 0xFFFFFFFF + WINS_SERVER2 else WINS_SERVER2 end / 256) & 0xFF as VARCHAR) + '.' + CAST( case when WINS_SERVER2 < 0 then 0xFFFFFFFF + WINS_SERVER2 else WINS_SERVER2 end & 0xFF as VARCHAR) as WINS_SERVER2_TEXT, CAST((case when DHCP_SERVER < 0 then 0xFFFFFFFF + DHCP_SERVER else DHCP_SERVER end / 256 / 256 / 256) & 0xFF as VARCHAR) + '.' + CAST((case when DHCP_SERVER < 0 then 0xFFFFFFFF + DHCP_SERVER else DHCP_SERVER end / 256 / 256) & 0xFF as VARCHAR) + '.' + CAST((case when DHCP_SERVER < 0 then 0xFFFFFFFF + DHCP_SERVER else DHCP_SERVER end / 256) & 0xFF as VARCHAR) + '.' + CAST( case when DHCP_SERVER < 0 then 0xFFFFFFFF + DHCP_SERVER else DHCP_SERVER end & 0xFF as VARCHAR) as DHCP_SERVER_TEXT, CAST((case when IP_ADDR1 < 0 then 0xFFFFFFFF + IP_ADDR1 else IP_ADDR1 end / 256 / 256 / 256) & 0xFF as VARCHAR) + '.' + CAST((case when IP_ADDR1 < 0 then 0xFFFFFFFF + IP_ADDR1 else IP_ADDR1 end / 256 / 256) & 0xFF as VARCHAR) + '.' + CAST((case when IP_ADDR1 < 0 then 0xFFFFFFFF + IP_ADDR1 else IP_ADDR1 end / 256) & 0xFF as VARCHAR) + '.' + CAST( case when IP_ADDR1 < 0 then 0xFFFFFFFF + IP_ADDR1 else IP_ADDR1 end & 0xFF as VARCHAR) as IP_ADDR1_TEXT, CAST((case when GATEWAY1 < 0 then 0xFFFFFFFF + GATEWAY1 else GATEWAY1 end / 256 / 256 / 256) & 0xFF as VARCHAR) + '.' + CAST((case when GATEWAY1 < 0 then 0xFFFFFFFF + GATEWAY1 else GATEWAY1 end / 256 / 256) & 0xFF as VARCHAR) + '.' + CAST((case when GATEWAY1 < 0 then 0xFFFFFFFF + GATEWAY1 else GATEWAY1 end / 256) & 0xFF as VARCHAR) + '.' + CAST( case when GATEWAY1 < 0 then 0xFFFFFFFF + GATEWAY1 else GATEWAY1 end & 0xFF as VARCHAR) as GATEWAY1_TEXT, CAST((case when SUBNET_MASK1 < 0 then 0xFFFFFFFF + SUBNET_MASK1 else SUBNET_MASK1 end / 256 / 256 / 256) & 0xFF as VARCHAR) + '.' + CAST((case when SUBNET_MASK1 < 0 then 0xFFFFFFFF + SUBNET_MASK1 else SUBNET_MASK1 end / 256 / 256) & 0xFF as VARCHAR) + '.' + CAST((case when SUBNET_MASK1 < 0 then 0xFFFFFFFF + SUBNET_MASK1 else SUBNET_MASK1 end / 256) & 0xFF as VARCHAR) + '.' + CAST( case when SUBNET_MASK1 < 0 then 0xFFFFFFFF + SUBNET_MASK1 else SUBNET_MASK1 end & 0xFF as VARCHAR) as SUBNET_MASK1_TEXT, CAST((case when IP_ADDR2 < 0 then 0xFFFFFFFF + IP_ADDR2 else IP_ADDR2 end / 256 / 256 / 256) & 0xFF as VARCHAR) + '.' + CAST((case when IP_ADDR2 < 0 then 0xFFFFFFFF + IP_ADDR2 else IP_ADDR2 end / 256 / 256) & 0xFF as VARCHAR) + '.' + CAST((case when IP_ADDR2 < 0 then 0xFFFFFFFF + IP_ADDR2 else IP_ADDR2 end / 256) & 0xFF as VARCHAR) + '.' + CAST( case when IP_ADDR2 < 0 then 0xFFFFFFFF + IP_ADDR2 else IP_ADDR2 end & 0xFF as VARCHAR) as IP_ADDR2_TEXT, CAST((case when GATEWAY2 < 0 then 0xFFFFFFFF + GATEWAY2 else GATEWAY2 end / 256 / 256 / 256) & 0xFF as VARCHAR) + '.' + CAST((case when GATEWAY2 < 0 then 0xFFFFFFFF + GATEWAY2 else GATEWAY2 end / 256 / 256) & 0xFF as VARCHAR) + '.' + CAST((case when GATEWAY2 < 0 then 0xFFFFFFFF + GATEWAY2 else GATEWAY2 end / 256) & 0xFF as VARCHAR) + '.' + CAST( case when GATEWAY2 < 0 then 0xFFFFFFFF + GATEWAY2 else GATEWAY2 end & 0xFF as VARCHAR) as GATEWAY2_TEXT, CAST((case when SUBNET_MASK2 < 0 then 0xFFFFFFFF + SUBNET_MASK2 else SUBNET_MASK2 end / 256 / 256 / 256) & 0xFF as VARCHAR) + '.' + CAST((case when SUBNET_MASK2 < 0 then 0xFFFFFFFF + SUBNET_MASK2 else SUBNET_MASK2 end / 256 / 256) & 0xFF as VARCHAR) + '.' + CAST((case when SUBNET_MASK2 < 0 then 0xFFFFFFFF + SUBNET_MASK2 else SUBNET_MASK2 end / 256) & 0xFF as VARCHAR) + '.' + CAST( case when SUBNET_MASK2 < 0 then 0xFFFFFFFF + SUBNET_MASK2 else SUBNET_MASK2 end & 0xFF as VARCHAR) as SUBNET_MASK2_TEXT, CAST((case when IP_ADDR3 < 0 then 0xFFFFFFFF + IP_ADDR3 else IP_ADDR3 end / 256 / 256 / 256) & 0xFF as VARCHAR) + '.' + CAST((case when IP_ADDR3 < 0 then 0xFFFFFFFF + IP_ADDR3 else IP_ADDR3 end / 256 / 256) & 0xFF as VARCHAR) + '.' + CAST((case when IP_ADDR3 < 0 then 0xFFFFFFFF + IP_ADDR3 else IP_ADDR3 end / 256) & 0xFF as VARCHAR) + '.' + CAST( case when IP_ADDR3 < 0 then 0xFFFFFFFF + IP_ADDR3 else IP_ADDR3 end & 0xFF as VARCHAR) as IP_ADDR3_TEXT, CAST((case when GATEWAY3 < 0 then 0xFFFFFFFF + GATEWAY3 else GATEWAY3 end / 256 / 256 / 256) & 0xFF as VARCHAR) + '.' + CAST((case when GATEWAY3 < 0 then 0xFFFFFFFF + GATEWAY3 else GATEWAY3 end / 256 / 256) & 0xFF as VARCHAR) + '.' + CAST((case when GATEWAY3 < 0 then 0xFFFFFFFF + GATEWAY3 else GATEWAY3 end / 256) & 0xFF as VARCHAR) + '.' + CAST( case when GATEWAY3 < 0 then 0xFFFFFFFF + GATEWAY3 else GATEWAY3 end & 0xFF as VARCHAR) as GATEWAY3_TEXT, CAST((case when SUBNET_MASK3 < 0 then 0xFFFFFFFF + SUBNET_MASK3 else SUBNET_MASK3 end / 256 / 256 / 256) & 0xFF as VARCHAR) + '.' + CAST((case when SUBNET_MASK3 < 0 then 0xFFFFFFFF + SUBNET_MASK3 else SUBNET_MASK3 end / 256 / 256) & 0xFF as VARCHAR) + '.' + CAST((case when SUBNET_MASK3 < 0 then 0xFFFFFFFF + SUBNET_MASK3 else SUBNET_MASK3 end / 256) & 0xFF as VARCHAR) + '.' + CAST( case when SUBNET_MASK3 < 0 then 0xFFFFFFFF + SUBNET_MASK3 else SUBNET_MASK3 end & 0xFF as VARCHAR) as SUBNET_MASK3_TEXT, CAST((case when IP_ADDR4 < 0 then 0xFFFFFFFF + IP_ADDR4 else IP_ADDR4 end / 256 / 256 / 256) & 0xFF as VARCHAR) + '.' + CAST((case when IP_ADDR4 < 0 then 0xFFFFFFFF + IP_ADDR4 else IP_ADDR4 end / 256 / 256) & 0xFF as VARCHAR) + '.' + CAST((case when IP_ADDR4 < 0 then 0xFFFFFFFF + IP_ADDR4 else IP_ADDR4 end / 256) & 0xFF as VARCHAR) + '.' + CAST( case when IP_ADDR4 < 0 then 0xFFFFFFFF + IP_ADDR4 else IP_ADDR4 end & 0xFF as VARCHAR) as IP_ADDR4_TEXT, CAST((case when GATEWAY4 < 0 then 0xFFFFFFFF + GATEWAY4 else GATEWAY4 end / 256 / 256 / 256) & 0xFF as VARCHAR) + '.' + CAST((case when GATEWAY4 < 0 then 0xFFFFFFFF + GATEWAY4 else GATEWAY4 end / 256 / 256) & 0xFF as VARCHAR) + '.' + CAST((case when GATEWAY4 < 0 then 0xFFFFFFFF + GATEWAY4 else GATEWAY4 end / 256) & 0xFF as VARCHAR) + '.' + CAST( case when GATEWAY4 < 0 then 0xFFFFFFFF + GATEWAY4 else GATEWAY4 end & 0xFF as VARCHAR) as GATEWAY4_TEXT, CAST((case when SUBNET_MASK4 < 0 then 0xFFFFFFFF + SUBNET_MASK4 else SUBNET_MASK4 end / 256 / 256 / 256) & 0xFF as VARCHAR) + '.' + CAST((case when SUBNET_MASK4 < 0 then 0xFFFFFFFF + SUBNET_MASK4 else SUBNET_MASK4 end / 256 / 256) & 0xFF as VARCHAR) + '.' + CAST((case when SUBNET_MASK4 < 0 then 0xFFFFFFFF + SUBNET_MASK4 else SUBNET_MASK4 end / 256) & 0xFF as VARCHAR) + '.' + CAST( case when SUBNET_MASK4 < 0 then 0xFFFFFFFF + SUBNET_MASK4 else SUBNET_MASK4 end & 0xFF as VARCHAR) as SUBNET_MASK4_TEXT FROM SEM_COMPUTER WHERE DELETED=0 2015-02-09 14:29:36.058 THREAD 27 INFO: DROP VIEW V_SEM_SVA_COMPUTER 2015-02-09 14:29:36.109 THREAD 27 INFO: CREATE VIEW V_SEM_SVA_COMPUTER as SELECT *, CAST((case when DNS_SERVER1 < 0 then 0xFFFFFFFF + DNS_SERVER1 else DNS_SERVER1 end / 256 / 256 / 256) & 0xFF as VARCHAR) + '.' + CAST((case when DNS_SERVER1 < 0 then 0xFFFFFFFF + DNS_SERVER1 else DNS_SERVER1 end / 256 / 256) & 0xFF as VARCHAR) + '.' + CAST((case when DNS_SERVER1 < 0 then 0xFFFFFFFF + DNS_SERVER1 else DNS_SERVER1 end / 256) & 0xFF as VARCHAR) + '.' + CAST( case when DNS_SERVER1 < 0 then 0xFFFFFFFF + DNS_SERVER1 else DNS_SERVER1 end & 0xFF as VARCHAR) as DNS_SERVER1_TEXT, CAST((case when DNS_SERVER2 < 0 then 0xFFFFFFFF + DNS_SERVER2 else DNS_SERVER2 end / 256 / 256 / 256) & 0xFF as VARCHAR) + '.' + CAST((case when DNS_SERVER2 < 0 then 0xFFFFFFFF + DNS_SERVER2 else DNS_SERVER2 end / 256 / 256) & 0xFF as VARCHAR) + '.' + CAST((case when DNS_SERVER2 < 0 then 0xFFFFFFFF + DNS_SERVER2 else DNS_SERVER2 end / 256) & 0xFF as VARCHAR) + '.' + CAST( case when DNS_SERVER2 < 0 then 0xFFFFFFFF + DNS_SERVER2 else DNS_SERVER2 end & 0xFF as VARCHAR) as DNS_SERVER2_TEXT, CAST((case when WINS_SERVER1 < 0 then 0xFFFFFFFF + WINS_SERVER1 else WINS_SERVER1 end / 256 / 256 / 256) & 0xFF as VARCHAR) + '.' + CAST((case when WINS_SERVER1 < 0 then 0xFFFFFFFF + WINS_SERVER1 else WINS_SERVER1 end / 256 / 256) & 0xFF as VARCHAR) + '.' + CAST((case when WINS_SERVER1 < 0 then 0xFFFFFFFF + WINS_SERVER1 else WINS_SERVER1 end / 256) & 0xFF as VARCHAR) + '.' + CAST( case when WINS_SERVER1 < 0 then 0xFFFFFFFF + WINS_SERVER1 else WINS_SERVER1 end & 0xFF as VARCHAR) as WINS_SERVER1_TEXT, CAST((case when WINS_SERVER2 < 0 then 0xFFFFFFFF + WINS_SERVER2 else WINS_SERVER2 end / 256 / 256 / 256) & 0xFF as VARCHAR) + '.' + CAST((case when WINS_SERVER2 < 0 then 0xFFFFFFFF + WINS_SERVER2 else WINS_SERVER2 end / 256 / 256) & 0xFF as VARCHAR) + '.' + CAST((case when WINS_SERVER2 < 0 then 0xFFFFFFFF + WINS_SERVER2 else WINS_SERVER2 end / 256) & 0xFF as VARCHAR) + '.' + CAST( case when WINS_SERVER2 < 0 then 0xFFFFFFFF + WINS_SERVER2 else WINS_SERVER2 end & 0xFF as VARCHAR) as WINS_SERVER2_TEXT, CAST((case when DHCP_SERVER < 0 then 0xFFFFFFFF + DHCP_SERVER else DHCP_SERVER end / 256 / 256 / 256) & 0xFF as VARCHAR) + '.' + CAST((case when DHCP_SERVER < 0 then 0xFFFFFFFF + DHCP_SERVER else DHCP_SERVER end / 256 / 256) & 0xFF as VARCHAR) + '.' + CAST((case when DHCP_SERVER < 0 then 0xFFFFFFFF + DHCP_SERVER else DHCP_SERVER end / 256) & 0xFF as VARCHAR) + '.' + CAST( case when DHCP_SERVER < 0 then 0xFFFFFFFF + DHCP_SERVER else DHCP_SERVER end & 0xFF as VARCHAR) as DHCP_SERVER_TEXT, CAST((case when IP_ADDR1 < 0 then 0xFFFFFFFF + IP_ADDR1 else IP_ADDR1 end / 256 / 256 / 256) & 0xFF as VARCHAR) + '.' + CAST((case when IP_ADDR1 < 0 then 0xFFFFFFFF + IP_ADDR1 else IP_ADDR1 end / 256 / 256) & 0xFF as VARCHAR) + '.' + CAST((case when IP_ADDR1 < 0 then 0xFFFFFFFF + IP_ADDR1 else IP_ADDR1 end / 256) & 0xFF as VARCHAR) + '.' + CAST( case when IP_ADDR1 < 0 then 0xFFFFFFFF + IP_ADDR1 else IP_ADDR1 end & 0xFF as VARCHAR) as IP_ADDR1_TEXT, CAST((case when GATEWAY1 < 0 then 0xFFFFFFFF + GATEWAY1 else GATEWAY1 end / 256 / 256 / 256) & 0xFF as VARCHAR) + '.' + CAST((case when GATEWAY1 < 0 then 0xFFFFFFFF + GATEWAY1 else GATEWAY1 end / 256 / 256) & 0xFF as VARCHAR) + '.' + CAST((case when GATEWAY1 < 0 then 0xFFFFFFFF + GATEWAY1 else GATEWAY1 end / 256) & 0xFF as VARCHAR) + '.' + CAST( case when GATEWAY1 < 0 then 0xFFFFFFFF + GATEWAY1 else GATEWAY1 end & 0xFF as VARCHAR) as GATEWAY1_TEXT, CAST((case when SUBNET_MASK1 < 0 then 0xFFFFFFFF + SUBNET_MASK1 else SUBNET_MASK1 end / 256 / 256 / 256) & 0xFF as VARCHAR) + '.' + CAST((case when SUBNET_MASK1 < 0 then 0xFFFFFFFF + SUBNET_MASK1 else SUBNET_MASK1 end / 256 / 256) & 0xFF as VARCHAR) + '.' + CAST((case when SUBNET_MASK1 < 0 then 0xFFFFFFFF + SUBNET_MASK1 else SUBNET_MASK1 end / 256) & 0xFF as VARCHAR) + '.' + CAST( case when SUBNET_MASK1 < 0 then 0xFFFFFFFF + SUBNET_MASK1 else SUBNET_MASK1 end & 0xFF as VARCHAR) as SUBNET_MASK1_TEXT, CAST((case when IP_ADDR2 < 0 then 0xFFFFFFFF + IP_ADDR2 else IP_ADDR2 end / 256 / 256 / 256) & 0xFF as VARCHAR) + '.' + CAST((case when IP_ADDR2 < 0 then 0xFFFFFFFF + IP_ADDR2 else IP_ADDR2 end / 256 / 256) & 0xFF as VARCHAR) + '.' + CAST((case when IP_ADDR2 < 0 then 0xFFFFFFFF + IP_ADDR2 else IP_ADDR2 end / 256) & 0xFF as VARCHAR) + '.' + CAST( case when IP_ADDR2 < 0 then 0xFFFFFFFF + IP_ADDR2 else IP_ADDR2 end & 0xFF as VARCHAR) as IP_ADDR2_TEXT, CAST((case when GATEWAY2 < 0 then 0xFFFFFFFF + GATEWAY2 else GATEWAY2 end / 256 / 256 / 256) & 0xFF as VARCHAR) + '.' + CAST((case when GATEWAY2 < 0 then 0xFFFFFFFF + GATEWAY2 else GATEWAY2 end / 256 / 256) & 0xFF as VARCHAR) + '.' + CAST((case when GATEWAY2 < 0 then 0xFFFFFFFF + GATEWAY2 else GATEWAY2 end / 256) & 0xFF as VARCHAR) + '.' + CAST( case when GATEWAY2 < 0 then 0xFFFFFFFF + GATEWAY2 else GATEWAY2 end & 0xFF as VARCHAR) as GATEWAY2_TEXT, CAST((case when SUBNET_MASK2 < 0 then 0xFFFFFFFF + SUBNET_MASK2 else SUBNET_MASK2 end / 256 / 256 / 256) & 0xFF as VARCHAR) + '.' + CAST((case when SUBNET_MASK2 < 0 then 0xFFFFFFFF + SUBNET_MASK2 else SUBNET_MASK2 end / 256 / 256) & 0xFF as VARCHAR) + '.' + CAST((case when SUBNET_MASK2 < 0 then 0xFFFFFFFF + SUBNET_MASK2 else SUBNET_MASK2 end / 256) & 0xFF as VARCHAR) + '.' + CAST( case when SUBNET_MASK2 < 0 then 0xFFFFFFFF + SUBNET_MASK2 else SUBNET_MASK2 end & 0xFF as VARCHAR) as SUBNET_MASK2_TEXT, CAST((case when IP_ADDR3 < 0 then 0xFFFFFFFF + IP_ADDR3 else IP_ADDR3 end / 256 / 256 / 256) & 0xFF as VARCHAR) + '.' + CAST((case when IP_ADDR3 < 0 then 0xFFFFFFFF + IP_ADDR3 else IP_ADDR3 end / 256 / 256) & 0xFF as VARCHAR) + '.' + CAST((case when IP_ADDR3 < 0 then 0xFFFFFFFF + IP_ADDR3 else IP_ADDR3 end / 256) & 0xFF as VARCHAR) + '.' + CAST( case when IP_ADDR3 < 0 then 0xFFFFFFFF + IP_ADDR3 else IP_ADDR3 end & 0xFF as VARCHAR) as IP_ADDR3_TEXT, CAST((case when GATEWAY3 < 0 then 0xFFFFFFFF + GATEWAY3 else GATEWAY3 end / 256 / 256 / 256) & 0xFF as VARCHAR) + '.' + CAST((case when GATEWAY3 < 0 then 0xFFFFFFFF + GATEWAY3 else GATEWAY3 end / 256 / 256) & 0xFF as VARCHAR) + '.' + CAST((case when GATEWAY3 < 0 then 0xFFFFFFFF + GATEWAY3 else GATEWAY3 end / 256) & 0xFF as VARCHAR) + '.' + CAST( case when GATEWAY3 < 0 then 0xFFFFFFFF + GATEWAY3 else GATEWAY3 end & 0xFF as VARCHAR) as GATEWAY3_TEXT, CAST((case when SUBNET_MASK3 < 0 then 0xFFFFFFFF + SUBNET_MASK3 else SUBNET_MASK3 end / 256 / 256 / 256) & 0xFF as VARCHAR) + '.' + CAST((case when SUBNET_MASK3 < 0 then 0xFFFFFFFF + SUBNET_MASK3 else SUBNET_MASK3 end / 256 / 256) & 0xFF as VARCHAR) + '.' + CAST((case when SUBNET_MASK3 < 0 then 0xFFFFFFFF + SUBNET_MASK3 else SUBNET_MASK3 end / 256) & 0xFF as VARCHAR) + '.' + CAST( case when SUBNET_MASK3 < 0 then 0xFFFFFFFF + SUBNET_MASK3 else SUBNET_MASK3 end & 0xFF as VARCHAR) as SUBNET_MASK3_TEXT, CAST((case when IP_ADDR4 < 0 then 0xFFFFFFFF + IP_ADDR4 else IP_ADDR4 end / 256 / 256 / 256) & 0xFF as VARCHAR) + '.' + CAST((case when IP_ADDR4 < 0 then 0xFFFFFFFF + IP_ADDR4 else IP_ADDR4 end / 256 / 256) & 0xFF as VARCHAR) + '.' + CAST((case when IP_ADDR4 < 0 then 0xFFFFFFFF + IP_ADDR4 else IP_ADDR4 end / 256) & 0xFF as VARCHAR) + '.' + CAST( case when IP_ADDR4 < 0 then 0xFFFFFFFF + IP_ADDR4 else IP_ADDR4 end & 0xFF as VARCHAR) as IP_ADDR4_TEXT, CAST((case when GATEWAY4 < 0 then 0xFFFFFFFF + GATEWAY4 else GATEWAY4 end / 256 / 256 / 256) & 0xFF as VARCHAR) + '.' + CAST((case when GATEWAY4 < 0 then 0xFFFFFFFF + GATEWAY4 else GATEWAY4 end / 256 / 256) & 0xFF as VARCHAR) + '.' + CAST((case when GATEWAY4 < 0 then 0xFFFFFFFF + GATEWAY4 else GATEWAY4 end / 256) & 0xFF as VARCHAR) + '.' + CAST( case when GATEWAY4 < 0 then 0xFFFFFFFF + GATEWAY4 else GATEWAY4 end & 0xFF as VARCHAR) as GATEWAY4_TEXT, CAST((case when SUBNET_MASK4 < 0 then 0xFFFFFFFF + SUBNET_MASK4 else SUBNET_MASK4 end / 256 / 256 / 256) & 0xFF as VARCHAR) + '.' + CAST((case when SUBNET_MASK4 < 0 then 0xFFFFFFFF + SUBNET_MASK4 else SUBNET_MASK4 end / 256 / 256) & 0xFF as VARCHAR) + '.' + CAST((case when SUBNET_MASK4 < 0 then 0xFFFFFFFF + SUBNET_MASK4 else SUBNET_MASK4 end / 256) & 0xFF as VARCHAR) + '.' + CAST( case when SUBNET_MASK4 < 0 then 0xFFFFFFFF + SUBNET_MASK4 else SUBNET_MASK4 end & 0xFF as VARCHAR) as SUBNET_MASK4_TEXT FROM SEM_SVA_COMPUTER WHERE DELETED=0 2015-02-09 14:29:36.158 THREAD 27 INFO: DROP VIEW V_ALERTS 2015-02-09 14:29:36.192 THREAD 27 INFO: CREATE VIEW V_ALERTS as SELECT *, CAST((case when SOURCE_COMPUTER_IP < 0 then 0xFFFFFFFF + SOURCE_COMPUTER_IP else SOURCE_COMPUTER_IP end / 256 / 256 / 256) & 0xFF as VARCHAR) + '.' + CAST((case when SOURCE_COMPUTER_IP < 0 then 0xFFFFFFFF + SOURCE_COMPUTER_IP else SOURCE_COMPUTER_IP end / 256 / 256) & 0xFF as VARCHAR) + '.' + CAST((case when SOURCE_COMPUTER_IP < 0 then 0xFFFFFFFF + SOURCE_COMPUTER_IP else SOURCE_COMPUTER_IP end / 256) & 0xFF as VARCHAR) + '.' + CAST( case when SOURCE_COMPUTER_IP < 0 then 0xFFFFFFFF + SOURCE_COMPUTER_IP else SOURCE_COMPUTER_IP end & 0xFF as VARCHAR) as SOURCE_COMPUTER_IP_TEXT FROM ALERTS 2015-02-09 14:29:36.233 THREAD 27 INFO: Process SQL script file:EmbeddedFerrariBeta1ToFerrariBeta2.sql 2015-02-09 14:29:36.234 THREAD 27 INFO: Process SQL InputStream sqlis:sun.net.www.protocol.jar.JarURLConnection$JarURLInputStream@9e3de9 2015-02-09 14:29:36.234 THREAD 27 INFO: DatabaseUtilities> execCommandFromScript>> cmdSeperator : ;; , sqlStr : /* Defect 3522262 */ DROP VIEW V_HPP_APPLICATION_RISK 2015-02-09 14:29:36.234 THREAD 27 INFO: /* Defect 3522262 */ DROP VIEW V_HPP_APPLICATION_RISK 2015-02-09 14:29:36.251 THREAD 27 INFO: CREATE VIEW V_HPP_APPLICATION_RISK AS SELECT HPP_APPLICATION.APP_IDX, HPP_APPLICATION.APP_HASH, HPP_APPLICATION.HASH_TYPE, HPP_APPLICATION.COMPANY_NAME, (CASE WHEN (VIRUS.VIRUSNAME != '') then VIRUS.VIRUSNAME else HPP_APPLICATION.APP_NAME end) as APP_NAME, HPP_APPLICATION.APP_VERSION, HPP_APPLICATION.APP_TYPE, HPP_APPLICATION.FILE_SIZE, HPP_APPLICATION.DETECTION_TYPE, HPP_APPLICATION.USN, HPP_APPLICATION.TIME_STAMP, HPP_APPLICATION.DELETED, HPP_APPLICATION.HELP_VIRUS_IDX, HPP_APPLICATION.FIRST_SEEN FROM HPP_APPLICATION LEFT JOIN VIRUS with (NOLOCK) ON VIRUS.VIRUSNAME_IDX=HPP_APPLICATION.HELP_VIRUS_IDX 2015-02-09 14:29:36.283 THREAD 27 INFO: /* Defect 3529291 */ IF NOT EXISTS (SELECT 1 FROM SEM_OS_INFO WHERE OPERATING_SYSTEM = 'OS X 10.10') INSERT INTO SEM_OS_INFO (OPERATING_SYSTEM, OS_NAME, OS_TYPE, SPC_OS_NAME, SPC_OS_TYPE, OS_MAJOR, OS_MINOR, SPC_OS_VERSION, OS_FAMILY, DELETED, USN, TIME_STAMP, I18N_KEY) VALUES ('OS X 10.10', 'OS X', '10.10', 'OS X', '', 10, 10, '10.10', 2,0,1,0, 'MACOS_10_10') 2015-02-09 14:29:36.284 THREAD 27 INFO: IF NOT EXISTS (SELECT 1 FROM SEM_OS_INFO WHERE OPERATING_SYSTEM = 'OS X 10.10.0') INSERT INTO SEM_OS_INFO (OPERATING_SYSTEM, OS_NAME, OS_TYPE, SPC_OS_NAME, SPC_OS_TYPE, OS_MAJOR, OS_MINOR, SPC_OS_VERSION, OS_FAMILY, DELETED, USN, TIME_STAMP, I18N_KEY) VALUES ('OS X 10.10.0', 'OS X', '10.10.0', 'OS X', '', 10, 10, '10.10.0', 2,0,1,0, 'MACOS_10_10_0') 2015-02-09 14:29:36.285 THREAD 27 INFO: IF NOT EXISTS (SELECT 1 FROM SEM_OS_INFO WHERE OPERATING_SYSTEM = 'OS X 10.10.1') INSERT INTO SEM_OS_INFO (OPERATING_SYSTEM, OS_NAME, OS_TYPE, SPC_OS_NAME, SPC_OS_TYPE, OS_MAJOR, OS_MINOR, SPC_OS_VERSION, OS_FAMILY, DELETED, USN, TIME_STAMP, I18N_KEY) VALUES ('OS X 10.10.1', 'OS X', '10.10.1', 'OS X', '', 10, 10, '10.10.1', 2,0,1,0, 'MACOS_10_10_1') 2015-02-09 14:29:36.286 THREAD 27 INFO: IF NOT EXISTS (SELECT 1 FROM SEM_OS_INFO WHERE OPERATING_SYSTEM = 'OS X 10.10.2') INSERT INTO SEM_OS_INFO (OPERATING_SYSTEM, OS_NAME, OS_TYPE, SPC_OS_NAME, SPC_OS_TYPE, OS_MAJOR, OS_MINOR, SPC_OS_VERSION, OS_FAMILY, DELETED, USN, TIME_STAMP, I18N_KEY) VALUES ('OS X 10.10.2', 'OS X', '10.10.2', 'OS X', '', 10, 10, '10.10.2', 2,0,1,0, 'MACOS_10_10_2') 2015-02-09 14:29:36.287 THREAD 27 INFO: IF NOT EXISTS (SELECT 1 FROM SEM_OS_INFO WHERE OPERATING_SYSTEM = 'OS X 10.10.3') INSERT INTO SEM_OS_INFO (OPERATING_SYSTEM, OS_NAME, OS_TYPE, SPC_OS_NAME, SPC_OS_TYPE, OS_MAJOR, OS_MINOR, SPC_OS_VERSION, OS_FAMILY, DELETED, USN, TIME_STAMP, I18N_KEY) VALUES ('OS X 10.10.3', 'OS X', '10.10.3', 'OS X', '', 10, 10, '10.10.3', 2,0,1,0, 'MACOS_10_10_3') 2015-02-09 14:29:36.288 THREAD 27 INFO: IF NOT EXISTS (SELECT 1 FROM SEM_OS_INFO WHERE OPERATING_SYSTEM = 'OS X 10.10.4') INSERT INTO SEM_OS_INFO (OPERATING_SYSTEM, OS_NAME, OS_TYPE, SPC_OS_NAME, SPC_OS_TYPE, OS_MAJOR, OS_MINOR, SPC_OS_VERSION, OS_FAMILY, DELETED, USN, TIME_STAMP, I18N_KEY) VALUES ('OS X 10.10.4', 'OS X', '10.10.4', 'OS X', '', 10, 10, '10.10.4', 2,0,1,0, 'MACOS_10_10_4') 2015-02-09 14:29:36.289 THREAD 27 INFO: IF NOT EXISTS (SELECT 1 FROM SEM_OS_INFO WHERE OPERATING_SYSTEM = 'OS X 10.10.5') INSERT INTO SEM_OS_INFO (OPERATING_SYSTEM, OS_NAME, OS_TYPE, SPC_OS_NAME, SPC_OS_TYPE, OS_MAJOR, OS_MINOR, SPC_OS_VERSION, OS_FAMILY, DELETED, USN, TIME_STAMP, I18N_KEY) VALUES ('OS X 10.10.5', 'OS X', '10.10.5', 'OS X', '', 10, 10, '10.10.5', 2,0,1,0, 'MACOS_10_10_5') 2015-02-09 14:29:36.290 THREAD 27 INFO: IF NOT EXISTS (SELECT 1 FROM SEM_OS_INFO WHERE OPERATING_SYSTEM = 'OS X 10.10.6') INSERT INTO SEM_OS_INFO (OPERATING_SYSTEM, OS_NAME, OS_TYPE, SPC_OS_NAME, SPC_OS_TYPE, OS_MAJOR, OS_MINOR, SPC_OS_VERSION, OS_FAMILY, DELETED, USN, TIME_STAMP, I18N_KEY) VALUES ('OS X 10.10.6', 'OS X', '10.10.6', 'OS X', '', 10, 10, '10.10.6', 2,0,1,0, 'MACOS_10_10_6') 2015-02-09 14:29:36.291 THREAD 27 INFO: IF NOT EXISTS (SELECT 1 FROM SEM_OS_INFO WHERE OPERATING_SYSTEM = 'OS X 10.10.7') INSERT INTO SEM_OS_INFO (OPERATING_SYSTEM, OS_NAME, OS_TYPE, SPC_OS_NAME, SPC_OS_TYPE, OS_MAJOR, OS_MINOR, SPC_OS_VERSION, OS_FAMILY, DELETED, USN, TIME_STAMP, I18N_KEY) VALUES ('OS X 10.10.7', 'OS X', '10.10.7', 'OS X', '', 10, 10, '10.10.7', 2,0,1,0, 'MACOS_10_10_7') 2015-02-09 14:29:36.292 THREAD 27 INFO: IF NOT EXISTS (SELECT 1 FROM SEM_OS_INFO WHERE OPERATING_SYSTEM = 'OS X 10.10.8') INSERT INTO SEM_OS_INFO (OPERATING_SYSTEM, OS_NAME, OS_TYPE, SPC_OS_NAME, SPC_OS_TYPE, OS_MAJOR, OS_MINOR, SPC_OS_VERSION, OS_FAMILY, DELETED, USN, TIME_STAMP, I18N_KEY) VALUES ('OS X 10.10.8', 'OS X', '10.10.8', 'OS X', '', 10, 10, '10.10.8', 2,0,1,0, 'MACOS_10_10_8') 2015-02-09 14:29:36.293 THREAD 27 INFO: IF NOT EXISTS (SELECT 1 FROM SEM_OS_INFO WHERE OPERATING_SYSTEM = 'OS X 10.10.9') INSERT INTO SEM_OS_INFO (OPERATING_SYSTEM, OS_NAME, OS_TYPE, SPC_OS_NAME, SPC_OS_TYPE, OS_MAJOR, OS_MINOR, SPC_OS_VERSION, OS_FAMILY, DELETED, USN, TIME_STAMP, I18N_KEY) VALUES ('OS X 10.10.9', 'OS X', '10.10.9', 'OS X', '', 10, 10, '10.10.9', 2,0,1,0, 'MACOS_10_10_9') 2015-02-09 14:29:36.294 THREAD 27 INFO: IF NOT EXISTS (SELECT 1 FROM SEM_OS_INFO WHERE OPERATING_SYSTEM = 'OS X 10.10.10') INSERT INTO SEM_OS_INFO (OPERATING_SYSTEM, OS_NAME, OS_TYPE, SPC_OS_NAME, SPC_OS_TYPE, OS_MAJOR, OS_MINOR, SPC_OS_VERSION, OS_FAMILY, DELETED, USN, TIME_STAMP, I18N_KEY) VALUES ('OS X 10.10.10', 'OS X', '10.10.10', 'OS X', '', 10, 10, '10.10.10', 2,0,1,0, 'MACOS_10_10_10') 2015-02-09 14:29:36.294 THREAD 27 INFO: /* Defect 3529291 updated clause (SA.R_OS_TYPE) NOT IN (269091840,269092096,269092352,269092608,269092864,269093120,269093376)*/ DROP PROCEDURE SEM_HOMEPAGE_SONAR_REDANDYELLOW 2015-02-09 14:29:36.308 THREAD 27 INFO: CREATE PROCEDURE SEM_HOMEPAGE_SONAR_REDANDYELLOW( in yesterday ntext, in tooolddef ntext, in sqlwhere ntext) BEGIN DECLARE Command ntext; SET Command = 'SELECT COUNT(A.color) as anzahl, A.color FROM ( SELECT COUNT(DISTINCT(SA.AGENT_ID)) as anzahl, ''color'' = (CASE WHEN ' || yesterday || '> SA.CREATION_TIME THEN ''RED'' ELSE ''YELLOW'' END ), SA.AGENT_ID FROM V_AGENT_INCL_GROUP_ID SA with (NOLOCK) INNER JOIN V_GROUPS G ON G.ID=SA.GROUP_ID INNER JOIN V_DOMAINS S ON S.ID=SA.DOMAIN_ID LEFT OUTER JOIN SEM_CONTENT SC with (NOLOCK) on SC.AGENT_ID=SA.AGENT_ID LEFT OUTER JOIN V_SONAR ON SC.PATTERN_IDX=V_SONAR.PATTERN_IDX WHERE SA.AGENT_TYPE=''105'' AND SA.DELETED=0 and (V_SONAR.DELETED=0 OR V_SONAR.DELETED IS NULL) AND SA.STATUS=1 AND SA.MAJOR_VERSION>10 AND SA.PTP_ONOFF not in (2, 127) and SC.DELETED=0 and (SA.R_OS_TYPE) NOT IN (269091840,269092096,269092352,269092608,269092864,269093120,269093376) ' || sqlwhere || ' group by (CASE WHEN ' || yesterday || '> SA.CREATION_TIME THEN ''RED'' ELSE ''YELLOW'' END), SA.AGENT_ID HAVING ( MAX(V_SONAR.VERSION) IS NULL OR MAX(V_SONAR.VERSION) <=''' || tooolddef || ''')) AS A GROUP BY A.color'; EXECUTE IMMEDIATE WITH RESULT SET ON Command; END 2015-02-09 14:29:36.325 THREAD 27 INFO: /* Defect 3536829 */ DROP VIEW V_SEM_SVA_COMPUTER_NAME 2015-02-09 14:29:36.342 THREAD 27 INFO: CREATE VIEW V_SEM_SVA_COMPUTER_NAME as SELECT S.SVA_ID, S.STATUS, C.COMPUTER_NAME, C.IP_ADDR1_TEXT FROM SEM_SVA as S with (nolock) LEFT OUTER JOIN V_SEM_SVA_COMPUTER as C WITH (NOLOCK) ON S.COMPUTER_ID = C.COMPUTER_ID WHERE S.DELETED=0 2015-02-09 14:29:36.383 THREAD 27 INFO: Process SQL script file:EmbeddedFerrariBeta2ToFerrariRC.sql 2015-02-09 14:29:36.384 THREAD 27 INFO: Process SQL InputStream sqlis:sun.net.www.protocol.jar.JarURLConnection$JarURLInputStream@3fded7 2015-02-09 14:29:36.384 THREAD 27 INFO: DatabaseUtilities> execCommandFromScript>> cmdSeperator : ;; , sqlStr : /* Defect 3592383 */ IF EXISTS (SELECT INDEX_NAME FROM SYSINDEX WHERE INDEX_NAME = 'I_AUDIT_TIMESTAMP' ) DROP INDEX I_AUDIT_TIMESTAMP 2015-02-09 14:29:36.384 THREAD 27 INFO: /* Defect 3592383 */ IF EXISTS (SELECT INDEX_NAME FROM SYSINDEX WHERE INDEX_NAME = 'I_AUDIT_TIMESTAMP' ) DROP INDEX I_AUDIT_TIMESTAMP 2015-02-09 14:29:36.400 THREAD 27 INFO: IF NOT EXISTS (SELECT INDEX_NAME FROM SYSINDEX WHERE INDEX_NAME = 'I_AUDIT_LOG_TIMESTAMP' ) CREATE INDEX I_AUDIT_LOG_TIMESTAMP ON AUDIT_LOG (TIMESTAMP) 2015-02-09 14:29:36.408 THREAD 27 INFO: DROP PROCEDURE SEM_AV_SUMMARY_SOURCE 2015-02-09 14:29:36.417 THREAD 27 INFO: CREATE PROCEDURE SEM_AV_SUMMARY_SOURCE(in filter_5150 ntext) BEGIN DECLARE Command ntext; SET Command = 'SELECT A.SOURCE as Source, SUM(A.NOOFVIRUSES) as anzahl from ALERTS as A with (NOLOCK) INNER JOIN V_AGENT_INCL_GROUP_ID as SA with (NOLOCK) ON SA.COMPUTER_ID = A.COMPUTER_IDX INNER JOIN V_GROUPS G on G.ID=SA.GROUP_ID INNER JOIN V_DOMAINS S on S.ID=SA.DOMAIN_ID INNER JOIN V_SERVERS P on P.ID=SA.LAST_SERVER_ID where A.ALERT_IDX IN (1,2,10) AND ' || filter_5150 || ' GROUP BY A.SOURCE ORDER BY anzahl DESC, A.SOURCE ASC '; EXECUTE IMMEDIATE WITH RESULT SET ON Command; END 2015-02-09 14:29:36.433 THREAD 27 INFO: DROP PROCEDURE SEM_AV_SUMMARY_GROUP 2015-02-09 14:29:36.442 THREAD 27 INFO: CREATE PROCEDURE SEM_AV_SUMMARY_GROUP(in filter_5150 ntext) BEGIN DECLARE Command ntext; SET Command = 'SELECT G.NAME as Clientgroup, SUM(A.NOOFVIRUSES) as anzahl from ALERTS as A with (NOLOCK) INNER JOIN V_AGENT_INCL_GROUP_ID as SA with (NOLOCK) ON SA.COMPUTER_ID = A.COMPUTER_IDX INNER JOIN V_DOMAINS S on S.ID=SA.DOMAIN_ID INNER JOIN V_SERVERS P on P.ID=SA.LAST_SERVER_ID INNER JOIN V_GROUPS G with (NOLOCK) on G.ID=SA.GROUP_ID where A.ALERT_IDX IN (1,2,10) AND ' || filter_5150 || ' GROUP BY G.NAME ORDER BY anzahl DESC, G.NAME ASC'; EXECUTE IMMEDIATE WITH RESULT SET ON Command; END 2015-02-09 14:29:36.458 THREAD 27 INFO: DROP PROCEDURE SEM_AV_SUMMARY_RISK_DIST 2015-02-09 14:29:36.467 THREAD 27 INFO: CREATE PROCEDURE SEM_AV_SUMMARY_RISK_DIST(in filter_5150 ntext) BEGIN DECLARE Command ntext; SET Command = 'SELECT (CASE WHEN V.VIRUSNAME!='''' THEN V.VIRUSNAME ELSE HP.APP_NAME END) AS Virusname, COUNT(DISTINCT A.COMPUTER_IDX) as NumUniqueInfectedMachines FROM ALERTS as A with (NOLOCK) INNER JOIN V_AGENT_INCL_GROUP_ID as SA with (NOLOCK) ON SA.COMPUTER_ID = A.COMPUTER_IDX INNER JOIN V_GROUPS G on G.ID=SA.GROUP_ID INNER JOIN V_DOMAINS S on S.ID=SA.DOMAIN_ID INNER JOIN V_SERVERS P on P.ID=SA.LAST_SERVER_ID , V_VIRUS as V with (NOLOCK), V_HPP_APPLICATION_RISK as HP with (NOLOCK) WHERE A.VIRUSNAME_IDX = V.VIRUSNAME_IDX and A.ALERT_IDX IN (1,2,10) AND A.HPP_APP_IDX = HP.APP_IDX AND ' || filter_5150 || ' GROUP BY (CASE WHEN V.VIRUSNAME!='''' THEN V.VIRUSNAME ELSE HP.APP_NAME END) ORDER BY COUNT(DISTINCT A.COMPUTER_IDX) DESC, Virusname ASC '; EXECUTE IMMEDIATE WITH RESULT SET ON Command; END 2015-02-09 14:29:36.484 THREAD 27 INFO: /* Defect 3595485 - COLUMN ORDER IS DIFFERENT BETWEEN FRESHINSTALL AND UPGRADE (EMBEDDE DB) */ /* Detect wrong order for PARTNER_ID column */ IF NOT EXISTS (SELECT 1 FROM SYSTABLE T, SYSCOLUMN C WHERE T.TABLE_ID=C.TABLE_ID AND T.TABLE_NAME='OAUTH_CLIENT_DETAILS' AND COLUMN_ID=15 AND COLUMN_NAME = 'PARTNER_ID') BEGIN /* Drop existing indexes */ ALTER TABLE OAUTH_CLIENT_DETAILS DROP CONSTRAINT PK_OAUTH_CLIENT_DETAILS CREATE TABLE OAUTH_CLIENT_DETAILS_TMP( CLIENT_ID VARCHAR(80) NOT NULL, CLIENT_SECRET VARCHAR(80), APP_NAME NVARCHAR(200), RESOURCE_IDS VARCHAR(200), SCOPE VARCHAR(2000), AUTHORIZED_GRANT_TYPES VARCHAR(80), WEB_SERVER_REDIRECT_URI NVARCHAR(2000), AUTHORITIES VARCHAR(200), ACCESS_TOKEN_VALIDITY INT, ENABLED TINYINT, CREATED_BY VARCHAR(80), CREATION_DATE DATETIME NOT NULL, ACTIVATION_CODE VARCHAR(256), ACTIVATION_CODE_EXPIRE_DATE DATETIME, PARTNER_ID CHAR(32) ) /* Populate the existing data */ INSERT INTO OAUTH_CLIENT_DETAILS_TMP (CLIENT_ID, CLIENT_SECRET, APP_NAME, RESOURCE_IDS, SCOPE, AUTHORIZED_GRANT_TYPES, WEB_SERVER_REDIRECT_URI, AUTHORITIES, ACCESS_TOKEN_VALIDITY, ENABLED, CREATED_BY, CREATION_DATE, ACTIVATION_CODE, ACTIVATION_CODE_EXPIRE_DATE, PARTNER_ID) SELECT CLIENT_ID, CLIENT_SECRET, APP_NAME, RESOURCE_IDS, SCOPE, AUTHORIZED_GRANT_TYPES, WEB_SERVER_REDIRECT_URI, AUTHORITIES, ACCESS_TOKEN_VALIDITY, ENABLED, CREATED_BY, CREATION_DATE, ACTIVATION_CODE, ACTIVATION_CODE_EXPIRE_DATE, PARTNER_ID FROM OAUTH_CLIENT_DETAILS /* Archive the table and rename the new table */ DROP TABLE OAUTH_CLIENT_DETAILS ALTER TABLE OAUTH_CLIENT_DETAILS_TMP RENAME OAUTH_CLIENT_DETAILS /* Recreate the index */ ALTER TABLE OAUTH_CLIENT_DETAILS ADD CONSTRAINT PK_OAUTH_CLIENT_DETAILS PRIMARY KEY (CLIENT_ID) END 2015-02-09 14:29:36.486 THREAD 27 INFO: /* Detect wrong order for COMMAND.RESULT column */ IF NOT EXISTS (SELECT 1 FROM SYSTABLE T, SYSCOLUMN C WHERE T.TABLE_ID=C.TABLE_ID AND T.TABLE_NAME='COMMAND' AND COLUMN_ID=22 AND COLUMN_NAME = 'RESULT') BEGIN /* Drop existing indexes */ IF EXISTS (SELECT INDEX_NAME FROM SYSINDEX WHERE INDEX_NAME = 'I_COMMAND_USN' ) DROP INDEX COMMAND.I_COMMAND_USN ALTER TABLE COMMAND DROP CONSTRAINT PK_COMMAND CREATE TABLE COMMAND_TMP( HARDWARE_KEY char(32) NOT NULL, COMMAND_ID char(32) NOT NULL, DOMAIN_ID char(32) NOT NULL, USN bigint NOT NULL, BEGIN_TIME bigint NOT NULL DEFAULT 0, LAST_UPDATE_TIME bigint NOT NULL DEFAULT 0, STATE_ID int NOT NULL DEFAULT 0, SUB_STATE_ID int NULL, SUB_STATE_DESC nvarchar(260) NULL, ESTIMATED_DURATION int NOT NULL DEFAULT 0, PERCENT_COMPLETE tinyint NOT NULL DEFAULT 0, TIME_STAMP bigint NOT NULL, DELETED tinyint NOT NULL, RESERVED_INT1 int NULL, RESERVED_INT2 int NULL, RESERVED_BIGINT1 bigint NULL, RESERVED_BIGINT2 bigint NULL, RESERVED_CHAR1 char(32) NULL, RESERVED_CHAR2 char(32) NULL, RESERVED_VARCHAR1 varchar(260) NULL, RESERVED_BINARY varbinary(1000) NULL, RESULT NTEXT NULL ) /* Populate the existing data */ INSERT INTO COMMAND_TMP ( HARDWARE_KEY, COMMAND_ID, DOMAIN_ID, USN, BEGIN_TIME, LAST_UPDATE_TIME, STATE_ID, SUB_STATE_ID, SUB_STATE_DESC, ESTIMATED_DURATION, PERCENT_COMPLETE, TIME_STAMP, DELETED, RESERVED_INT1, RESERVED_INT2, RESERVED_BIGINT1, RESERVED_BIGINT2, RESERVED_CHAR1, RESERVED_CHAR2, RESERVED_VARCHAR1, RESERVED_BINARY, RESULT) SELECT HARDWARE_KEY, COMMAND_ID, DOMAIN_ID, USN, BEGIN_TIME, LAST_UPDATE_TIME, STATE_ID, SUB_STATE_ID, SUB_STATE_DESC, ESTIMATED_DURATION, PERCENT_COMPLETE, TIME_STAMP, DELETED, RESERVED_INT1, RESERVED_INT2, RESERVED_BIGINT1, RESERVED_BIGINT2, RESERVED_CHAR1, RESERVED_CHAR2, RESERVED_VARCHAR1, RESERVED_BINARY, RESULT FROM COMMAND /* Archive the table and rename the new table */ DROP TABLE COMMAND ALTER TABLE COMMAND_TMP RENAME COMMAND /* Recreate the index */ ALTER TABLE COMMAND ADD CONSTRAINT PK_COMMAND PRIMARY KEY NONCLUSTERED (HARDWARE_KEY, COMMAND_ID) CREATE INDEX I_COMMAND_USN ON COMMAND (USN) END 2015-02-09 14:29:36.489 THREAD 27 INFO: /* Detect wrong order for SEM_COMPUTER.KERNEL column */ IF NOT EXISTS (SELECT 1 FROM SYSTABLE T, SYSCOLUMN C WHERE T.TABLE_ID=C.TABLE_ID AND T.TABLE_NAME='SEM_COMPUTER' AND COLUMN_ID=54 AND COLUMN_NAME = 'KERNEL') BEGIN /* Drop existing indexes */ IF EXISTS (SELECT INDEX_NAME FROM SYSINDEX WHERE INDEX_NAME = 'I_SEM_COMPUTER_USN' ) DROP INDEX SEM_COMPUTER.I_SEM_COMPUTER_USN IF EXISTS (SELECT INDEX_NAME FROM SYSINDEX WHERE INDEX_NAME = 'I_SEM_COMPUTER_HWK' ) DROP INDEX SEM_COMPUTER.I_SEM_COMPUTER_HWK IF EXISTS (SELECT INDEX_NAME FROM SYSINDEX WHERE INDEX_NAME = 'I_SEM_COMPUTER_DOM' ) DROP INDEX SEM_COMPUTER.I_SEM_COMPUTER_DOM IF EXISTS (SELECT INDEX_NAME FROM SYSINDEX WHERE INDEX_NAME = 'I_SEM_COMPUTER_ID_PLUS' ) DROP INDEX SEM_COMPUTER.I_SEM_COMPUTER_ID_PLUS IF EXISTS (SELECT INDEX_NAME FROM SYSINDEX WHERE INDEX_NAME = 'I_SEM_COMPUTER_DELETED' ) DROP INDEX SEM_COMPUTER.I_SEM_COMPUTER_DELETED IF EXISTS (SELECT INDEX_NAME FROM SYSINDEX WHERE INDEX_NAME = 'I_SEM_COMPUTER_MAC_ADDR1' ) DROP INDEX SEM_COMPUTER.I_SEM_COMPUTER_MAC_ADDR1 IF EXISTS (SELECT INDEX_NAME FROM SYSINDEX WHERE INDEX_NAME = 'I_SEM_COMPUTER_MAC_ADDR2' ) DROP INDEX SEM_COMPUTER.I_SEM_COMPUTER_MAC_ADDR2 IF EXISTS (SELECT INDEX_NAME FROM SYSINDEX WHERE INDEX_NAME = 'I_SEM_COMPUTER_MAC_ADDR3' ) DROP INDEX SEM_COMPUTER.I_SEM_COMPUTER_MAC_ADDR3 IF EXISTS (SELECT INDEX_NAME FROM SYSINDEX WHERE INDEX_NAME = 'I_SEM_COMPUTER_MAC_ADDR4' ) DROP INDEX SEM_COMPUTER.I_SEM_COMPUTER_MAC_ADDR4 IF EXISTS (SELECT INDEX_NAME FROM SYSINDEX WHERE INDEX_NAME = 'I_SEM_COMPUTER_ID_DOMAIN_ID' ) DROP INDEX SEM_COMPUTER.I_SEM_COMPUTER_ID_DOMAIN_ID ALTER TABLE SEM_COMPUTER DROP CONSTRAINT PK_SEM_COMPUTER CREATE TABLE SEM_COMPUTER_TMP( COMPUTER_ID char(32) NOT NULL, DOMAIN_ID char(32) NULL, HARDWARE_KEY char(32) NULL, COMPUTER_NAME nvarchar(64) NULL, COMPUTER_DOMAIN_NAME nvarchar(256) NULL, COMPUTER_DESCRIPTION nvarchar(256) NULL, PROCESSOR_TYPE nvarchar(64) NULL, PROCESSOR_CLOCK bigint NULL, PROCESSOR_NUM int NULL, MEMORY bigint NULL, BIOS_VERSION varchar(128) NULL, TPM_DEVICE int NULL, OPERATION_SYSTEM nvarchar(512) NULL, SERVICE_PACK nvarchar(64) NULL, CURRENT_LOGIN_USER nvarchar(256) NULL, CURRENT_LOGIN_DOMAIN nvarchar(256) NULL, DNS_SERVER1 bigint NULL, DNS_SERVER2 bigint NULL, WINS_SERVER1 bigint NULL, WINS_SERVER2 bigint NULL, DHCP_SERVER bigint NULL, MAC_ADDR1 varchar(17) NULL, IP_ADDR1 bigint NULL, GATEWAY1 bigint NULL, SUBNET_MASK1 bigint NULL, MAC_ADDR2 varchar(17) NULL, IP_ADDR2 bigint NULL, GATEWAY2 bigint NULL, SUBNET_MASK2 bigint NULL, MAC_ADDR3 varchar(17) NULL, IP_ADDR3 bigint NULL, GATEWAY3 bigint NULL, SUBNET_MASK3 bigint NULL, MAC_ADDR4 varchar(17) NULL, IP_ADDR4 bigint NULL, GATEWAY4 bigint NULL, SUBNET_MASK4 bigint NULL, USN bigint NOT NULL, TIME_STAMP bigint NOT NULL, DELETED tinyint NOT NULL, RESERVED_INT1 int NULL, RESERVED_INT2 int NULL, RESERVED_BIGINT1 bigint NULL, RESERVED_BIGINT2 bigint NULL, RESERVED_CHAR1 char(32) NULL, RESERVED_CHAR2 char(32) NULL, RESERVED_VARCHAR1 nvarchar(260) NULL, RESERVED_BINARY varbinary(2000) NULL, DISK_TOTAL bigint NULL, DISK_DRIVE varchar(3) NULL, OS_LANG int NULL, HYPERVISOR_VENDOR_ID tinyint NULL, BIOS_SERIALNUMBER varchar(128) NULL, KERNEL nvarchar(256) NULL, UUID varchar(128) NULL ) /* Populate the existing data */ INSERT INTO SEM_COMPUTER_TMP ( COMPUTER_ID, DOMAIN_ID, HARDWARE_KEY, COMPUTER_NAME, COMPUTER_DOMAIN_NAME, COMPUTER_DESCRIPTION, PROCESSOR_TYPE, PROCESSOR_CLOCK, PROCESSOR_NUM, MEMORY, BIOS_VERSION, TPM_DEVICE, OPERATION_SYSTEM, SERVICE_PACK, CURRENT_LOGIN_USER, CURRENT_LOGIN_DOMAIN, DNS_SERVER1, DNS_SERVER2, WINS_SERVER1, WINS_SERVER2, DHCP_SERVER, MAC_ADDR1, IP_ADDR1, GATEWAY1, SUBNET_MASK1, MAC_ADDR2, IP_ADDR2, GATEWAY2, SUBNET_MASK2, MAC_ADDR3, IP_ADDR3, GATEWAY3, SUBNET_MASK3, MAC_ADDR4, IP_ADDR4, GATEWAY4, SUBNET_MASK4, USN, TIME_STAMP, DELETED, RESERVED_INT1, RESERVED_INT2, RESERVED_BIGINT1, RESERVED_BIGINT2, RESERVED_CHAR1, RESERVED_CHAR2, RESERVED_VARCHAR1, RESERVED_BINARY, DISK_TOTAL, DISK_DRIVE, OS_LANG, HYPERVISOR_VENDOR_ID, BIOS_SERIALNUMBER, KERNEL, UUID) SELECT COMPUTER_ID, DOMAIN_ID, HARDWARE_KEY, COMPUTER_NAME, COMPUTER_DOMAIN_NAME, COMPUTER_DESCRIPTION, PROCESSOR_TYPE, PROCESSOR_CLOCK, PROCESSOR_NUM, MEMORY, BIOS_VERSION, TPM_DEVICE, OPERATION_SYSTEM, SERVICE_PACK, CURRENT_LOGIN_USER, CURRENT_LOGIN_DOMAIN, DNS_SERVER1, DNS_SERVER2, WINS_SERVER1, WINS_SERVER2, DHCP_SERVER, MAC_ADDR1, IP_ADDR1, GATEWAY1, SUBNET_MASK1, MAC_ADDR2, IP_ADDR2, GATEWAY2, SUBNET_MASK2, MAC_ADDR3, IP_ADDR3, GATEWAY3, SUBNET_MASK3, MAC_ADDR4, IP_ADDR4, GATEWAY4, SUBNET_MASK4, USN, TIME_STAMP, DELETED, RESERVED_INT1, RESERVED_INT2, RESERVED_BIGINT1, RESERVED_BIGINT2, RESERVED_CHAR1, RESERVED_CHAR2, RESERVED_VARCHAR1, RESERVED_BINARY, DISK_TOTAL, DISK_DRIVE, OS_LANG, HYPERVISOR_VENDOR_ID, BIOS_SERIALNUMBER, KERNEL, UUID FROM SEM_COMPUTER /* Archive the table and rename the new table */ DROP TABLE SEM_COMPUTER ALTER TABLE SEM_COMPUTER_TMP RENAME SEM_COMPUTER /* Recreate the index */ ALTER TABLE SEM_COMPUTER ADD CONSTRAINT PK_SEM_COMPUTER PRIMARY KEY NONCLUSTERED (COMPUTER_ID) CREATE INDEX I_SEM_COMPUTER_USN ON SEM_COMPUTER (USN) CREATE INDEX I_SEM_COMPUTER_HWK ON SEM_COMPUTER (HARDWARE_KEY) CREATE INDEX I_SEM_COMPUTER_DOM ON SEM_COMPUTER (DOMAIN_ID,DELETED) CREATE INDEX I_SEM_COMPUTER_ID_PLUS ON SEM_COMPUTER (COMPUTER_ID,COMPUTER_NAME, IP_ADDR1, CURRENT_LOGIN_USER,OPERATION_SYSTEM, DELETED, MEMORY, DISK_TOTAL, PROCESSOR_TYPE) CREATE INDEX I_SEM_COMPUTER_DELETED ON SEM_COMPUTER (DELETED, COMPUTER_ID, COMPUTER_NAME, IP_ADDR1) CREATE INDEX I_SEM_COMPUTER_MAC_ADDR1 ON SEM_COMPUTER (MAC_ADDR1) CREATE INDEX I_SEM_COMPUTER_MAC_ADDR2 ON SEM_COMPUTER (MAC_ADDR2) CREATE INDEX I_SEM_COMPUTER_MAC_ADDR3 ON SEM_COMPUTER (MAC_ADDR3) CREATE INDEX I_SEM_COMPUTER_MAC_ADDR4 ON SEM_COMPUTER (MAC_ADDR4) CREATE INDEX I_SEM_COMPUTER_ID_DOMAIN_ID ON SEM_COMPUTER (COMPUTER_ID, DOMAIN_ID) END 2015-02-09 14:29:36.492 THREAD 27 INFO: DROP VIEW V_SEM_COMPUTER 2015-02-09 14:29:36.543 THREAD 27 INFO: CREATE VIEW V_SEM_COMPUTER AS SELECT *, CAST((case when DNS_SERVER1 < 0 then 0xFFFFFFFF + DNS_SERVER1 else DNS_SERVER1 end / 256 / 256 / 256) & 0xFF as VARCHAR) + '.' + CAST((case when DNS_SERVER1 < 0 then 0xFFFFFFFF + DNS_SERVER1 else DNS_SERVER1 end / 256 / 256) & 0xFF as VARCHAR) + '.' + CAST((case when DNS_SERVER1 < 0 then 0xFFFFFFFF + DNS_SERVER1 else DNS_SERVER1 end / 256) & 0xFF as VARCHAR) + '.' + CAST( case when DNS_SERVER1 < 0 then 0xFFFFFFFF + DNS_SERVER1 else DNS_SERVER1 end & 0xFF as VARCHAR) as DNS_SERVER1_TEXT, CAST((case when DNS_SERVER2 < 0 then 0xFFFFFFFF + DNS_SERVER2 else DNS_SERVER2 end / 256 / 256 / 256) & 0xFF as VARCHAR) + '.' + CAST((case when DNS_SERVER2 < 0 then 0xFFFFFFFF + DNS_SERVER2 else DNS_SERVER2 end / 256 / 256) & 0xFF as VARCHAR) + '.' + CAST((case when DNS_SERVER2 < 0 then 0xFFFFFFFF + DNS_SERVER2 else DNS_SERVER2 end / 256) & 0xFF as VARCHAR) + '.' + CAST( case when DNS_SERVER2 < 0 then 0xFFFFFFFF + DNS_SERVER2 else DNS_SERVER2 end & 0xFF as VARCHAR) as DNS_SERVER2_TEXT, CAST((case when WINS_SERVER1 < 0 then 0xFFFFFFFF + WINS_SERVER1 else WINS_SERVER1 end / 256 / 256 / 256) & 0xFF as VARCHAR) + '.' + CAST((case when WINS_SERVER1 < 0 then 0xFFFFFFFF + WINS_SERVER1 else WINS_SERVER1 end / 256 / 256) & 0xFF as VARCHAR) + '.' + CAST((case when WINS_SERVER1 < 0 then 0xFFFFFFFF + WINS_SERVER1 else WINS_SERVER1 end / 256) & 0xFF as VARCHAR) + '.' + CAST( case when WINS_SERVER1 < 0 then 0xFFFFFFFF + WINS_SERVER1 else WINS_SERVER1 end & 0xFF as VARCHAR) as WINS_SERVER1_TEXT, CAST((case when WINS_SERVER2 < 0 then 0xFFFFFFFF + WINS_SERVER2 else WINS_SERVER2 end / 256 / 256 / 256) & 0xFF as VARCHAR) + '.' + CAST((case when WINS_SERVER2 < 0 then 0xFFFFFFFF + WINS_SERVER2 else WINS_SERVER2 end / 256 / 256) & 0xFF as VARCHAR) + '.' + CAST((case when WINS_SERVER2 < 0 then 0xFFFFFFFF + WINS_SERVER2 else WINS_SERVER2 end / 256) & 0xFF as VARCHAR) + '.' + CAST( case when WINS_SERVER2 < 0 then 0xFFFFFFFF + WINS_SERVER2 else WINS_SERVER2 end & 0xFF as VARCHAR) as WINS_SERVER2_TEXT, CAST((case when DHCP_SERVER < 0 then 0xFFFFFFFF + DHCP_SERVER else DHCP_SERVER end / 256 / 256 / 256) & 0xFF as VARCHAR) + '.' + CAST((case when DHCP_SERVER < 0 then 0xFFFFFFFF + DHCP_SERVER else DHCP_SERVER end / 256 / 256) & 0xFF as VARCHAR) + '.' + CAST((case when DHCP_SERVER < 0 then 0xFFFFFFFF + DHCP_SERVER else DHCP_SERVER end / 256) & 0xFF as VARCHAR) + '.' + CAST( case when DHCP_SERVER < 0 then 0xFFFFFFFF + DHCP_SERVER else DHCP_SERVER end & 0xFF as VARCHAR) as DHCP_SERVER_TEXT, CAST((case when IP_ADDR1 < 0 then 0xFFFFFFFF + IP_ADDR1 else IP_ADDR1 end / 256 / 256 / 256) & 0xFF as VARCHAR) + '.' + CAST((case when IP_ADDR1 < 0 then 0xFFFFFFFF + IP_ADDR1 else IP_ADDR1 end / 256 / 256) & 0xFF as VARCHAR) + '.' + CAST((case when IP_ADDR1 < 0 then 0xFFFFFFFF + IP_ADDR1 else IP_ADDR1 end / 256) & 0xFF as VARCHAR) + '.' + CAST( case when IP_ADDR1 < 0 then 0xFFFFFFFF + IP_ADDR1 else IP_ADDR1 end & 0xFF as VARCHAR) as IP_ADDR1_TEXT, CAST((case when GATEWAY1 < 0 then 0xFFFFFFFF + GATEWAY1 else GATEWAY1 end / 256 / 256 / 256) & 0xFF as VARCHAR) + '.' + CAST((case when GATEWAY1 < 0 then 0xFFFFFFFF + GATEWAY1 else GATEWAY1 end / 256 / 256) & 0xFF as VARCHAR) + '.' + CAST((case when GATEWAY1 < 0 then 0xFFFFFFFF + GATEWAY1 else GATEWAY1 end / 256) & 0xFF as VARCHAR) + '.' + CAST( case when GATEWAY1 < 0 then 0xFFFFFFFF + GATEWAY1 else GATEWAY1 end & 0xFF as VARCHAR) as GATEWAY1_TEXT, CAST((case when SUBNET_MASK1 < 0 then 0xFFFFFFFF + SUBNET_MASK1 else SUBNET_MASK1 end / 256 / 256 / 256) & 0xFF as VARCHAR) + '.' + CAST((case when SUBNET_MASK1 < 0 then 0xFFFFFFFF + SUBNET_MASK1 else SUBNET_MASK1 end / 256 / 256) & 0xFF as VARCHAR) + '.' + CAST((case when SUBNET_MASK1 < 0 then 0xFFFFFFFF + SUBNET_MASK1 else SUBNET_MASK1 end / 256) & 0xFF as VARCHAR) + '.' + CAST( case when SUBNET_MASK1 < 0 then 0xFFFFFFFF + SUBNET_MASK1 else SUBNET_MASK1 end & 0xFF as VARCHAR) as SUBNET_MASK1_TEXT, CAST((case when IP_ADDR2 < 0 then 0xFFFFFFFF + IP_ADDR2 else IP_ADDR2 end / 256 / 256 / 256) & 0xFF as VARCHAR) + '.' + CAST((case when IP_ADDR2 < 0 then 0xFFFFFFFF + IP_ADDR2 else IP_ADDR2 end / 256 / 256) & 0xFF as VARCHAR) + '.' + CAST((case when IP_ADDR2 < 0 then 0xFFFFFFFF + IP_ADDR2 else IP_ADDR2 end / 256) & 0xFF as VARCHAR) + '.' + CAST( case when IP_ADDR2 < 0 then 0xFFFFFFFF + IP_ADDR2 else IP_ADDR2 end & 0xFF as VARCHAR) as IP_ADDR2_TEXT, CAST((case when GATEWAY2 < 0 then 0xFFFFFFFF + GATEWAY2 else GATEWAY2 end / 256 / 256 / 256) & 0xFF as VARCHAR) + '.' + CAST((case when GATEWAY2 < 0 then 0xFFFFFFFF + GATEWAY2 else GATEWAY2 end / 256 / 256) & 0xFF as VARCHAR) + '.' + CAST((case when GATEWAY2 < 0 then 0xFFFFFFFF + GATEWAY2 else GATEWAY2 end / 256) & 0xFF as VARCHAR) + '.' + CAST( case when GATEWAY2 < 0 then 0xFFFFFFFF + GATEWAY2 else GATEWAY2 end & 0xFF as VARCHAR) as GATEWAY2_TEXT, CAST((case when SUBNET_MASK2 < 0 then 0xFFFFFFFF + SUBNET_MASK2 else SUBNET_MASK2 end / 256 / 256 / 256) & 0xFF as VARCHAR) + '.' + CAST((case when SUBNET_MASK2 < 0 then 0xFFFFFFFF + SUBNET_MASK2 else SUBNET_MASK2 end / 256 / 256) & 0xFF as VARCHAR) + '.' + CAST((case when SUBNET_MASK2 < 0 then 0xFFFFFFFF + SUBNET_MASK2 else SUBNET_MASK2 end / 256) & 0xFF as VARCHAR) + '.' + CAST( case when SUBNET_MASK2 < 0 then 0xFFFFFFFF + SUBNET_MASK2 else SUBNET_MASK2 end & 0xFF as VARCHAR) as SUBNET_MASK2_TEXT, CAST((case when IP_ADDR3 < 0 then 0xFFFFFFFF + IP_ADDR3 else IP_ADDR3 end / 256 / 256 / 256) & 0xFF as VARCHAR) + '.' + CAST((case when IP_ADDR3 < 0 then 0xFFFFFFFF + IP_ADDR3 else IP_ADDR3 end / 256 / 256) & 0xFF as VARCHAR) + '.' + CAST((case when IP_ADDR3 < 0 then 0xFFFFFFFF + IP_ADDR3 else IP_ADDR3 end / 256) & 0xFF as VARCHAR) + '.' + CAST( case when IP_ADDR3 < 0 then 0xFFFFFFFF + IP_ADDR3 else IP_ADDR3 end & 0xFF as VARCHAR) as IP_ADDR3_TEXT, CAST((case when GATEWAY3 < 0 then 0xFFFFFFFF + GATEWAY3 else GATEWAY3 end / 256 / 256 / 256) & 0xFF as VARCHAR) + '.' + CAST((case when GATEWAY3 < 0 then 0xFFFFFFFF + GATEWAY3 else GATEWAY3 end / 256 / 256) & 0xFF as VARCHAR) + '.' + CAST((case when GATEWAY3 < 0 then 0xFFFFFFFF + GATEWAY3 else GATEWAY3 end / 256) & 0xFF as VARCHAR) + '.' + CAST( case when GATEWAY3 < 0 then 0xFFFFFFFF + GATEWAY3 else GATEWAY3 end & 0xFF as VARCHAR) as GATEWAY3_TEXT, CAST((case when SUBNET_MASK3 < 0 then 0xFFFFFFFF + SUBNET_MASK3 else SUBNET_MASK3 end / 256 / 256 / 256) & 0xFF as VARCHAR) + '.' + CAST((case when SUBNET_MASK3 < 0 then 0xFFFFFFFF + SUBNET_MASK3 else SUBNET_MASK3 end / 256 / 256) & 0xFF as VARCHAR) + '.' + CAST((case when SUBNET_MASK3 < 0 then 0xFFFFFFFF + SUBNET_MASK3 else SUBNET_MASK3 end / 256) & 0xFF as VARCHAR) + '.' + CAST( case when SUBNET_MASK3 < 0 then 0xFFFFFFFF + SUBNET_MASK3 else SUBNET_MASK3 end & 0xFF as VARCHAR) as SUBNET_MASK3_TEXT, CAST((case when IP_ADDR4 < 0 then 0xFFFFFFFF + IP_ADDR4 else IP_ADDR4 end / 256 / 256 / 256) & 0xFF as VARCHAR) + '.' + CAST((case when IP_ADDR4 < 0 then 0xFFFFFFFF + IP_ADDR4 else IP_ADDR4 end / 256 / 256) & 0xFF as VARCHAR) + '.' + CAST((case when IP_ADDR4 < 0 then 0xFFFFFFFF + IP_ADDR4 else IP_ADDR4 end / 256) & 0xFF as VARCHAR) + '.' + CAST( case when IP_ADDR4 < 0 then 0xFFFFFFFF + IP_ADDR4 else IP_ADDR4 end & 0xFF as VARCHAR) as IP_ADDR4_TEXT, CAST((case when GATEWAY4 < 0 then 0xFFFFFFFF + GATEWAY4 else GATEWAY4 end / 256 / 256 / 256) & 0xFF as VARCHAR) + '.' + CAST((case when GATEWAY4 < 0 then 0xFFFFFFFF + GATEWAY4 else GATEWAY4 end / 256 / 256) & 0xFF as VARCHAR) + '.' + CAST((case when GATEWAY4 < 0 then 0xFFFFFFFF + GATEWAY4 else GATEWAY4 end / 256) & 0xFF as VARCHAR) + '.' + CAST( case when GATEWAY4 < 0 then 0xFFFFFFFF + GATEWAY4 else GATEWAY4 end & 0xFF as VARCHAR) as GATEWAY4_TEXT, CAST((case when SUBNET_MASK4 < 0 then 0xFFFFFFFF + SUBNET_MASK4 else SUBNET_MASK4 end / 256 / 256 / 256) & 0xFF as VARCHAR) + '.' + CAST((case when SUBNET_MASK4 < 0 then 0xFFFFFFFF + SUBNET_MASK4 else SUBNET_MASK4 end / 256 / 256) & 0xFF as VARCHAR) + '.' + CAST((case when SUBNET_MASK4 < 0 then 0xFFFFFFFF + SUBNET_MASK4 else SUBNET_MASK4 end / 256) & 0xFF as VARCHAR) + '.' + CAST( case when SUBNET_MASK4 < 0 then 0xFFFFFFFF + SUBNET_MASK4 else SUBNET_MASK4 end & 0xFF as VARCHAR) as SUBNET_MASK4_TEXT FROM SEM_COMPUTER WHERE DELETED=0 2015-02-09 14:29:36.602 THREAD 27 INFO: /* Defect 3595485 - COLUMN ORDER IS DIFFERENT BETWEEN FRESHINSTALL AND UPGRADE (EMBEDDE DB) */ IF NOT EXISTS (SELECT INDEX_NAME FROM SYSINDEX WHERE INDEX_NAME = 'I_SEM_COMPUTER_ID_PLUS' ) CREATE INDEX I_SEM_COMPUTER_ID_PLUS ON SEM_COMPUTER (COMPUTER_ID,COMPUTER_NAME, IP_ADDR1, CURRENT_LOGIN_USER,OPERATION_SYSTEM, DELETED, MEMORY, DISK_TOTAL, PROCESSOR_TYPE) 2015-02-09 14:29:36.604 THREAD 27 WARNING: Upgrade> doUpgrade>> Upgrading database schema done! 2015-02-09 14:29:36.637 THREAD 27 WARNING: Upgrade> doUpgrade>> upgradeSemConfigRootObject... 2015-02-09 14:29:36.643 THREAD 27 WARNING: Upgrade> doUpgrade>> upgradeSemConfigRootObject...Done 2015-02-09 14:29:36.666 THREAD 27 INFO: Upgrading from 12 RU3 to 12 RU4 2015-02-09 14:29:36.667 THREAD 27 INFO: UpgradeStep >> checkUpgradeStatus. 2015-02-09 14:29:36.667 THREAD 27 INFO: UpgradeStep >> checkUpgradeStatus. 2015-02-09 14:29:36.677 THREAD 27 INFO: UpgradeStep >> checkUpgradeStatus. 2015-02-09 14:29:36.677 THREAD 27 INFO: UpgradeStep >> checkUpgradeStatus. 2015-02-09 14:29:36.751 THREAD 27 INFO: upgradeADCPolicies>> Started. 2015-02-09 14:29:36.785 THREAD 27 INFO: upgradeADCPolicies>> domainId:1637D4D8C0A8003401C958AFE493528B startIndex:1 policyBatchSize:50 morePolicies:true 2015-02-09 14:29:36.829 THREAD 27 INFO: upgradeADCPolicies>> domain:1637D4D8C0A8003401C958AFE493528B retrieved policy size:1 morePolicies:false 2015-02-09 14:29:36.831 THREAD 27 INFO: addSEPMigrationExclusions>> Checking policy Application and Device Control policy id=E17A3765C0A80034013C296BFF1D9C2A 2015-02-09 14:29:36.833 THREAD 27 INFO: addSEPMigrationExclusions>> policy Application and Device Control policy contains SEP migration blocking settings 2015-02-09 14:29:36.833 THREAD 27 INFO: addSEPMigrationExclusions>> added SEP migration exclusions to policy Application and Device Control policy 2015-02-09 14:29:36.833 THREAD 27 INFO: addSEPMigrationExclusions>> Finished policy Application and Device Control policy id=E17A3765C0A80034013C296BFF1D9C2A added=true 2015-02-09 14:29:36.898 THREAD 27 INFO: upgradeADCPolicies>> Commit policy Application and Device Control policy id=E17A3765C0A80034013C296BFF1D9C2A 2015-02-09 14:29:36.898 THREAD 27 INFO: upgradeADCPolicies>> Finished. The result is: true 2015-02-09 14:29:36.901 THREAD 27 INFO: Upgrading Mac policies from 12.1.3.0 to 12.1.4.0 2015-02-09 14:29:36.901 THREAD 27 INFO: MacLuPolicyUpgrade: Start upgrading of LU Content policies for Mac settings 2015-02-09 14:29:36.917 THREAD 27 INFO: fetching domain ids for the policies 2015-02-09 14:29:36.919 THREAD 27 INFO: upgradeMacAVPolicy>> startIndex: 1 policyBatchSize: 50 morePolicies:true 2015-02-09 14:29:36.925 THREAD 27 INFO: loaded [1] LUContent policies 2015-02-09 14:29:36.926 THREAD 27 INFO: MacLuIPSPolicyUpgrade: Working on Domain:[1637D4D8C0A8003401C958AFE493528B] 2015-02-09 14:29:36.926 THREAD 27 INFO: MacLuPolicyUpgrade: Domain Id: 1637D4D8C0A8003401C958AFE493528B LU Content Policy: LiveUpdate Content policy 2015-02-09 14:29:36.949 THREAD 27 INFO: MacLuPolicyUpgrade: Domain: 1637D4D8C0A8003401C958AFE493528B LU Content Policy: LiveUpdate Content policy. Policy Updated successfully 2015-02-09 14:29:36.949 THREAD 27 INFO: MacLuPolicyUpgrade: Finished upgrading of LU Content policies for Mac settings 2015-02-09 14:29:36.949 THREAD 27 INFO: Start upgrading Mac AV policies for Mac settings ... 2015-02-09 14:29:36.949 THREAD 27 INFO: fetching domain ids for the policies 2015-02-09 14:29:36.951 THREAD 27 INFO: upgradeMacAVPolicy>> startIndex: 1 policyBatchSize: 50 morePolicies:true 2015-02-09 14:29:37.046 THREAD 27 INFO: upgradeMacAVPolicy>> No of AV policies retrieved : 5 2015-02-09 14:29:37.046 THREAD 27 INFO: Number of MacAdminDefinedScans associated with this AvPolicy = 0 2015-02-09 14:29:37.047 THREAD 27 INFO: SchemaMacPolicyUpgradeToAmberRU4.upgradeAVPolicy:: Upgrading AV policy for domain :[1637D4D8C0A8003401C958AFE493528B] 2015-02-09 14:29:37.047 THREAD 27 INFO: SchemaMacPolicyUpgradeToAmberRU4.upgradeAVPolicy() :: updating AV Policy : id: 03D93153C0A8003400238016B07DBC6E 2015-02-09 14:29:37.076 THREAD 27 INFO: Number of MacAdminDefinedScans associated with this AvPolicy = 1 2015-02-09 14:29:37.076 THREAD 27 INFO: SchemaMacPolicyUpgradeToAmberRU4.upgradeAVPolicy:: Upgrading AV policy for domain :[1637D4D8C0A8003401C958AFE493528B] 2015-02-09 14:29:37.076 THREAD 27 INFO: SchemaMacPolicyUpgradeToAmberRU4.upgradeAVPolicy() :: updating AV Policy : id: 45B52356C0A8003400D78DF072DC0D07 2015-02-09 14:29:37.226 THREAD 27 INFO: Number of MacAdminDefinedScans associated with this AvPolicy = 1 2015-02-09 14:29:37.226 THREAD 27 INFO: SchemaMacPolicyUpgradeToAmberRU4.upgradeAVPolicy:: Upgrading AV policy for domain :[1637D4D8C0A8003401C958AFE493528B] 2015-02-09 14:29:37.227 THREAD 27 INFO: SchemaMacPolicyUpgradeToAmberRU4.upgradeAVPolicy() :: updating AV Policy : id: 59E6DABFC0A80034012F99241C35E179 2015-02-09 14:29:37.264 THREAD 27 INFO: Number of MacAdminDefinedScans associated with this AvPolicy = 1 2015-02-09 14:29:37.264 THREAD 27 INFO: SchemaMacPolicyUpgradeToAmberRU4.upgradeAVPolicy:: Upgrading AV policy for domain :[1637D4D8C0A8003401C958AFE493528B] 2015-02-09 14:29:37.264 THREAD 27 INFO: SchemaMacPolicyUpgradeToAmberRU4.upgradeAVPolicy() :: updating AV Policy : id: B657CFF5C0A8003400C075279BCECD59 2015-02-09 14:29:37.299 THREAD 27 INFO: Number of MacAdminDefinedScans associated with this AvPolicy = 0 2015-02-09 14:29:37.299 THREAD 27 WARNING: SchemaMacPolicyUpgradeToAmberRU4.getAvFileApObject :: AV Policy does not contain Mac AV Auto Protect policy. isTemplate: false id: E20C7C23C0A8003400CADE319D09BAC9 2015-02-09 14:29:37.299 THREAD 27 INFO: Finished upgrading Mac AV policies for Mac settings ... 2015-02-09 14:29:37.299 THREAD 27 INFO: Start upgrading Mac Admin Defined Scans for Mac settings ... 2015-02-09 14:29:37.300 THREAD 27 INFO: getMacADSGuids>> startIndex: 0 policyBatchSize: 50 endIndex: 49 2015-02-09 14:29:37.464 THREAD 27 INFO: Finished upgrading Mac Admin Defined Scans policies for Mac settings ... 2015-02-09 14:29:37.464 THREAD 27 INFO: Start upgrading Mac Scheduled Scan Templates for Mac settings ... 2015-02-09 14:29:37.464 THREAD 27 INFO: SchemaMacPolicyUpgradeToAmberRU4.upgradeMacScheduleScanTemplates begins 2015-02-09 14:29:37.472 THREAD 27 INFO: SchemaMacPolicyUpgradeToAmberRU4.upgradeMacScheduleScanTemplates:: Upgrading policy templates for domain : 1637D4D8C0A8003401C958AFE493528B 2015-02-09 14:29:37.476 THREAD 27 SEVERE: java.lang.NullPointerException 2015-02-09 14:29:37.476 THREAD 27 SEVERE: at com.sygate.scm.server.upgrade.SchemaMacPolicyUpgradeToAmberRU4.upgradeMacAdminScanInScheduleScanTemplates(SchemaMacPolicyUpgradeToAmberRU4.java:610) 2015-02-09 14:29:37.476 THREAD 27 SEVERE: at com.sygate.scm.server.upgrade.SchemaMacPolicyUpgradeToAmberRU4.upgrade(SchemaMacPolicyUpgradeToAmberRU4.java:127) 2015-02-09 14:29:37.476 THREAD 27 SEVERE: at com.sygate.scm.server.upgrade.Schema12RU3To12RU4.upgrade(Schema12RU3To12RU4.java:63) 2015-02-09 14:29:37.476 THREAD 27 SEVERE: at com.sygate.scm.server.upgrade.SchemaUpgrade.execute(SchemaUpgrade.java:84) 2015-02-09 14:29:37.476 THREAD 27 SEVERE: at com.sygate.scm.server.upgrade.Upgrade.doUpgrade(Upgrade.java:1221) 2015-02-09 14:29:37.476 THREAD 27 SEVERE: at com.sygate.scm.server.upgrade.ui.UpgradeTask.go(UpgradeTask.java:114) 2015-02-09 14:29:37.476 THREAD 27 SEVERE: at com.sygate.scm.server.upgrade.ui.UpgradeProgressPanel$2.construct(UpgradeProgressPanel.java:241) 2015-02-09 14:29:37.476 THREAD 27 SEVERE: at com.sygate.scm.util.SwingWorker$2.run(SwingWorker.java:145) 2015-02-09 14:29:37.476 THREAD 27 SEVERE: at java.lang.Thread.run(Thread.java:745) 2015-02-09 14:29:37.476 THREAD 27 SEVERE: Upgrade.doUpgrade java.lang.NullPointerException 2015-02-09 14:29:37.476 THREAD 27 WARNING: Upgrade> doUpgrade>> Upgrade process completed in (ms) : 13769 2015-02-09 14:29:37.514 THREAD 27 INFO: AuditUtil> auditEvent>> The Upgrading is executed by windows user: administrator 2015-02-09 14:29:37.536 THREAD 23 INFO: MainFrame>> doInitFinalPanel> Upgrade.serviceInstallState = 0 2015-02-09 14:33:01.251 THREAD 23 INFO: UpgradeFinalPanel >> saveStage > Starting the semsrv service... 2015-02-09 14:33:04.426 THREAD 23 INFO: The Symantec Endpoint Protection Manager Webserver service is starting. 2015-02-09 14:33:04.426 THREAD 23 INFO: The Symantec Endpoint Protection Manager Webserver service could not be started.A service specific error occurred: 1.More help is available by typing NET HELPMSG 3547. 2015-02-09 14:33:04.426 THREAD 23 INFO: SemServiceManager> serviceControl>> Executed command - start semwebsrv, process return value = 2 2015-02-09 14:33:05.083 THREAD 23 INFO: System error 1068 has occurred.The dependency service or group failed to start. 2015-02-09 14:33:05.083 THREAD 23 INFO: SemServiceManager> serviceControl>> Executed command - start semsrv, process return value = 2 2015-02-09 14:33:05.155 THREAD 23 INFO: The service name is invalid.More help is available by typing NET HELPMSG 2185. 2015-02-09 14:33:05.156 THREAD 23 INFO: SemServiceManager> serviceControl>> Executed command - start semlaunchsrv, process return value = 2