2015-02-09 17:31:27.004 THREAD 1 SEVERE: ================== Server Environment =================== 2015-02-09 17:31:27.006 THREAD 1 SEVERE: os.name = Windows Server 2008 R2 2015-02-09 17:31:27.006 THREAD 1 SEVERE: os.version = 6.1 2015-02-09 17:31:27.006 THREAD 1 SEVERE: os.arch = x64 2015-02-09 17:31:27.006 THREAD 1 SEVERE: java.version = 1.7.0_55 2015-02-09 17:31:27.006 THREAD 1 SEVERE: java.vendor = Oracle Corporation 2015-02-09 17:31:27.006 THREAD 1 SEVERE: java.vm.name = Java HotSpot(TM) Client VM 2015-02-09 17:31:27.006 THREAD 1 SEVERE: java.vm.version = 24.55-b03 2015-02-09 17:31:27.007 THREAD 1 SEVERE: java.home = D:\Program Files\Symantec\Symantec Endpoint Protection Manager\jre 2015-02-09 17:31:27.007 THREAD 1 SEVERE: catalina.home = D:\Program Files\Symantec\Symantec Endpoint Protection Manager\tomcat 2015-02-09 17:31:27.007 THREAD 1 SEVERE: java.user = null 2015-02-09 17:31:27.007 THREAD 1 SEVERE: user.language = en 2015-02-09 17:31:27.007 THREAD 1 SEVERE: user.country = GB 2015-02-09 17:31:27.007 THREAD 1 SEVERE: scm.server.version = 12.1.5337.5000 2015-02-09 17:31:27.007 THREAD 1 INFO: Main> Main>> Checking upgrade arguments... Command-line argument is empty. 2015-02-09 17:31:27.007 THREAD 1 INFO: Main> Main>> Server Home = D:\Program Files\Symantec\Symantec Endpoint Protection Manager\tomcat 2015-02-09 17:31:27.222 THREAD 1 INFO: DatabaseUtilities> initDataSource>> Found 12.x driver 2015-02-09 17:31:27.246 THREAD 1 INFO: DatabaseUtilities> initDataSource>> dbport : 2638 2015-02-09 17:31:27.247 THREAD 1 INFO: DatabaseUtilities> initDataSource>> Datasource set in sqlanywhere>>ds:sybase.jdbc4.sqlanywhere.ASADataSource@1b94a21 2015-02-09 17:31:27.251 THREAD 1 INFO: Main> Main>> Database server is Embedded. 2015-02-09 17:31:27.258 THREAD 1 INFO: SemServiceManager> getServiceStatus>> Retrieve status for service SQLANYs_sem5 2015-02-09 17:31:27.326 THREAD 1 INFO: SemServiceManager> getServiceStatus>> The status for SQLANYs_sem5' service is 4 2015-02-09 17:31:27.344 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 17:31:27 GMT 2015 2015-02-09 17:31:27.344 THREAD 1 INFO: DatabaseUtilities> testDBConnection>> Testing DB connection using 'DefaultDatabaseConnection' method. Parameters used (needDateFormat: false, isRetryUntilDBUp: false, defaultConnectionMaxRetry: 20) 2015-02-09 17:31:27.427 THREAD 1 INFO: Main> Main>> DB(Embedded) test connection succeeded. Continuing with upgrade process... Current time = Mon Feb 09 17:31:27 GMT 2015 2015-02-09 17:31:27.629 THREAD 1 INFO: Has valid SAV license 2015-02-09 17:31:27.629 THREAD 1 INFO: Info>> No SNAC license file in D:\Program Files\Symantec\Symantec Endpoint Protection Manager\tomcat\etc\license 2015-02-09 17:31:29.135 THREAD 1 INFO: Main> executePreLaunchSteps>> Config schema format is getting upgraded from (schema version from db): 12.1.3.0 2015-02-09 17:31:29.296 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-17-31-29.zip 2015-02-09 17:31:29.349 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 17:31:29.349 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 17:31:29.350 THREAD 1 INFO: VersionToBeSupported: 12.1.3.0 2015-02-09 17:31:29.351 THREAD 1 INFO: SchemaVersion>> isSupported> versionToBeSupported '12.1.3.0 is supported for this release 2015-02-09 17:31:29.360 THREAD 1 INFO: Main> displayOnlineServerListIfAny>> Checking online servers. siteId = 96B58BB1C0A8003401C1991909C89285 2015-02-09 17:31:29.366 THREAD 1 INFO: SELECT CONTENT FROM SYSTEM_STATE WHERE OWNER = '9A680152C0A8003401B67D6A484CEE4D' 2015-02-09 17:31:29.377 THREAD 1 INFO: SYSOUT : Checking onlist status for server localhost 2015-02-09 17:31:29.377 THREAD 1 INFO: SYSOUT : Not checking status. offline status detected 2015-02-09 17:31:29.377 THREAD 1 INFO: SYSOUT : [name=localhost,id=9A680152C0A8003401B67D6A484CEE4D] is offline 2015-02-09 17:31:29.378 THREAD 1 INFO: Main> displayOnlineServerListIfAny>> Checking online servers. Exclude local server id = 9A680152C0A8003401B67D6A484CEE4D 2015-02-09 17:31:29.378 THREAD 1 INFO: Main> displayOnlineServerListIfAny>> Online servers = [] 2015-02-09 17:31:29.379 THREAD 1 INFO: Main> launchMainFrame>> Launching the UI. 2015-02-09 17:31:29.677 THREAD 1 INFO: ServerConfigurationRemediator >> needChooseLaunchServicePort >> ServerVersion.FERRARI_VERSION=12.1.4426.5000 2015-02-09 17:31:29.677 THREAD 1 INFO: ServerConfigurationRemediator >> needChooseLaunchServicePort >> needChooseLaunchServicePort=true serverVersionPreUpgrade=12.1.2015.2015 2015-02-09 17:31:29.708 THREAD 1 INFO: ServerConfigurationRemediator >> needChooseLaunchServicePort >> ServerVersion.FERRARI_VERSION=12.1.4426.5000 2015-02-09 17:31:29.708 THREAD 1 INFO: ServerConfigurationRemediator >> needChooseLaunchServicePort >> needChooseLaunchServicePort=true serverVersionPreUpgrade=12.1.2015.2015 2015-02-09 17:31:29.769 THREAD 1 INFO: isLicenseInstallationValid: sep.slf =true OD file=true 2015-02-09 17:31:29.774 THREAD 1 INFO: MainFrame >> needShowUpgradeDBTasksConfigPanel >> skipping panel because preUpgradeVersion=12.1.2015.2015 2015-02-09 17:31:32.220 THREAD 23 INFO: scm.server.port is found in conf.properties 2015-02-09 17:31:32.220 THREAD 23 INFO: scm.http.port is found in conf.properties 2015-02-09 17:31:32.220 THREAD 23 INFO: scm.webserver.http.port is found in conf.properties 2015-02-09 17:31:32.220 THREAD 23 INFO: scm.webserver.https.port is not found in conf.properties 2015-02-09 17:31:32.221 THREAD 23 INFO: scm.shutdown.port is found in conf.properties 2015-02-09 17:31:32.221 THREAD 23 INFO: scm.console.reporting.https.port is found in conf.properties 2015-02-09 17:31:32.221 THREAD 23 INFO: scm.webservices.port is found in conf.properties 2015-02-09 17:31:32.221 THREAD 23 INFO: scm.iis.http.port is not found in conf.properties 2015-02-09 17:31:32.221 THREAD 23 INFO: scm.iis.https.port is not found in conf.properties 2015-02-09 17:31:32.221 THREAD 23 INFO: scm.iisproxy.http.port is not found in conf.properties 2015-02-09 17:31:32.221 THREAD 23 INFO: scm.iisproxy.https.port is not found in conf.properties 2015-02-09 17:31:32.221 THREAD 23 INFO: scm.rmmwebservices.port is found in conf.properties 2015-02-09 17:31:35.100 THREAD 23 INFO: Run LiveUpdate during upgrade=true 2015-02-09 17:31:35.106 THREAD 27 WARNING: Upgrade> doUpgrade>> Upgrade process started @ : 0 2015-02-09 17:31:35.108 THREAD 27 INFO: UpgradeStep >> checkUpgradeStatus. 2015-02-09 17:31:35.116 THREAD 27 WARNING: Upgrade> doUpgrade>> Stopping SemSrv... 2015-02-09 17:31:35.191 THREAD 27 INFO: The Symantec Endpoint Protection Manager service is not started.More help is available by typing NET HELPMSG 3521. 2015-02-09 17:31:35.191 THREAD 27 INFO: SemServiceManager> serviceControl>> Executed command - stop semsrv, process return value = 2 2015-02-09 17:31:35.191 THREAD 27 INFO: SemServiceManager> waitForServiceTermination>> Waiting for service termination: semsrv 2015-02-09 17:31:35.191 THREAD 27 INFO: SemServiceManager> getServiceStatus>> Retrieve status for service semsrv 2015-02-09 17:31:35.258 THREAD 27 INFO: SemServiceManager> getServiceStatus>> The status for semsrv' service is 1 2015-02-09 17:31:35.273 THREAD 27 INFO: SemServiceManager> waitForServiceTermination>> Service is stopped. 2015-02-09 17:31:40.351 THREAD 27 INFO: The Symantec Endpoint Protection Manager Webserver service is stopping..The Symantec Endpoint Protection Manager Webserver service was stopped successfully. 2015-02-09 17:31:40.351 THREAD 27 INFO: SemServiceManager> serviceControl>> Executed command - stop semwebsrv, process return value = 0 2015-02-09 17:31:40.424 THREAD 27 INFO: The service name is invalid.More help is available by typing NET HELPMSG 2185. 2015-02-09 17:31:40.425 THREAD 27 INFO: SemServiceManager> serviceControl>> Executed command - stop semlaunchsrv, process return value = 2 2015-02-09 17:31:40.425 THREAD 27 INFO: SemServiceManager> waitForServiceTermination>> Waiting for service termination: semlaunchsrv 2015-02-09 17:31:40.425 THREAD 27 INFO: SemServiceManager> getServiceStatus>> Retrieve status for service semlaunchsrv 2015-02-09 17:31:40.502 THREAD 27 INFO: SemServiceManager> getServiceStatus>> Error code from sc query: 1060 2015-02-09 17:31:40.726 THREAD 27 INFO: SemServiceManager> waitForServiceTermination>> Service is stopped. 2015-02-09 17:31:40.726 THREAD 27 WARNING: Upgrade> doUpgrade>> Stopping SemSrv done! 2015-02-09 17:31:40.745 THREAD 27 INFO: DatabaseUtilities> initDataSource>> Found 12.x driver 2015-02-09 17:31:40.745 THREAD 27 INFO: DatabaseUtilities> initDataSource>> dbport : 2638 2015-02-09 17:31:40.745 THREAD 27 INFO: DatabaseUtilities> initDataSource>> Datasource set in sqlanywhere>>ds:sybase.jdbc4.sqlanywhere.ASADataSource@674818 2015-02-09 17:31:40.745 THREAD 27 INFO: SemServiceManager> getServiceStatus>> Retrieve status for service SQLANYs_sem5 2015-02-09 17:31:40.813 THREAD 27 INFO: SemServiceManager> getServiceStatus>> The status for SQLANYs_sem5' service is 4 2015-02-09 17:31:43.403 THREAD 27 INFO: The Symantec Embedded Database service is stopping.The Symantec Embedded Database service was stopped successfully. 2015-02-09 17:31:43.404 THREAD 27 INFO: SemServiceManager> serviceControl>> Executed command - stop SQLANYs_sem5, process return value = 0 2015-02-09 17:31:43.404 THREAD 27 INFO: SemServiceManager> waitForServiceTermination>> Waiting for service termination: SQLANYs_sem5 2015-02-09 17:31:43.404 THREAD 27 INFO: SemServiceManager> getServiceStatus>> Retrieve status for service SQLANYs_sem5 2015-02-09 17:31:43.472 THREAD 27 INFO: SemServiceManager> getServiceStatus>> The status for SQLANYs_sem5' service is 1 2015-02-09 17:31:43.488 THREAD 27 INFO: SemServiceManager> waitForServiceTermination>> Service is stopped. 2015-02-09 17:31:43.520 THREAD 27 INFO: UpgradeDBUtil> getEmbeddedDBVersion>> embeddedDBVersion matching string = 12.0.1.3152 2015-02-09 17:31:45.694 THREAD 27 INFO: The Symantec Embedded Database service is starting.The Symantec Embedded Database service was started successfully. 2015-02-09 17:31:45.694 THREAD 27 INFO: SemServiceManager> serviceControl>> Executed command - start SQLANYs_sem5, process return value = 0 2015-02-09 17:31:45.695 THREAD 27 INFO: Upgrade> doUpgrade>> Embedded database is 12x or higher, version number is 12.0.1.3152 2015-02-09 17:31:45.760 THREAD 27 INFO: 'SQLANYs_sem5' service is installed... 2015-02-09 17:31:45.760 THREAD 27 INFO: STATE : 4 RUNNING 2015-02-09 17:31:45.774 THREAD 27 INFO: Upgrade> doUpgrade>> Embedded database 12x or higher upgrade process done! 2015-02-09 17:31:45.850 THREAD 27 INFO: The requested service has already been started.More help is available by typing NET HELPMSG 2182. 2015-02-09 17:31:45.850 THREAD 27 INFO: SemServiceManager> serviceControl>> Executed command - start SQLANYs_sem5, process return value = 2 2015-02-09 17:31:45.850 THREAD 27 INFO: Waiting for service running: SQLANYs_sem5 2015-02-09 17:31:45.850 THREAD 27 INFO: SemServiceManager> getServiceStatus>> Retrieve status for service SQLANYs_sem5 2015-02-09 17:31:45.915 THREAD 27 INFO: SemServiceManager> getServiceStatus>> The status for SQLANYs_sem5' service is 4 2015-02-09 17:31:45.931 THREAD 27 INFO: The service SQLANYs_sem5 has already been started. 2015-02-09 17:31:45.935 THREAD 27 INFO: DatabaseUtilities> initDataSource>> Found 12.x driver 2015-02-09 17:31:45.935 THREAD 27 INFO: DatabaseUtilities> initDataSource>> dbport : 2638 2015-02-09 17:31:45.935 THREAD 27 INFO: DatabaseUtilities> initDataSource>> Datasource set in sqlanywhere>>ds:sybase.jdbc4.sqlanywhere.ASADataSource@a66284 2015-02-09 17:31:45.936 THREAD 27 INFO: DatabaseUtilities> testDBConnection>> Testing DB connection using 'DefaultDatabaseConnection' method. Parameters used (needDateFormat: false, isRetryUntilDBUp: false, defaultConnectionMaxRetry: 20) 2015-02-09 17:31:46.003 THREAD 27 INFO: isLicenseInstallationValid: sep.slf =true OD file=true 2015-02-09 17:31:46.129 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 17:31:46.232 THREAD 27 INFO: UpgradeDBUtil> createODBC>> Creating ODBC done! 2015-02-09 17:31:46.232 THREAD 27 INFO: UpgradeStep >> checkUpgradeStatus. 2015-02-09 17:31:46.232 THREAD 27 INFO: UpgradeStep >> checkUpgradeStatus. 2015-02-09 17:31:46.232 THREAD 27 INFO: Set the config manager cache threshold to 500! 2015-02-09 17:31:46.245 THREAD 27 INFO: updateEmbeddedStatementCount done 2015-02-09 17:31:46.264 THREAD 27 WARNING: Upgrade> doUpgrade>> Upgrading database schema... [formatVersion = 12.1.3.0, dbVersion = 12.1.3.0] 2015-02-09 17:31:46.275 THREAD 27 INFO: Process SQL script file:EmbeddedMcLarenToTesla.sql 2015-02-09 17:31:46.275 THREAD 27 INFO: Process SQL InputStream sqlis:sun.net.www.protocol.jar.JarURLConnection$JarURLInputStream@a4d015 2015-02-09 17:31:46.276 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 17:31:46.276 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 17:31:46.299 THREAD 27 INFO: DROP VIEW V_SEM_COMPUTER 2015-02-09 17:31:46.436 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 17:31:46.495 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 17:31:46.518 THREAD 27 INFO: DROP VIEW V_SEM_SVA_COMPUTER 2015-02-09 17:31:46.571 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 17:31:46.620 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 17:31:46.623 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 17:31:46.624 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 17:31:46.625 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 17:31:46.626 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 17:31:46.627 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 17:31:46.627 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 17:31:46.628 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 17:31:46.629 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 17:31:46.630 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 17:31:46.630 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 17:31:46.631 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 17:31:46.632 THREAD 27 INFO: Process SQL script file:EmbeddedTeslaToLightCycle.sql 2015-02-09 17:31:46.633 THREAD 27 INFO: Process SQL InputStream sqlis:sun.net.www.protocol.jar.JarURLConnection$JarURLInputStream@af7e20 2015-02-09 17:31:46.633 THREAD 27 INFO: DatabaseUtilities> execCommandFromScript>> cmdSeperator : ;; , sqlStr : DROP VIEW V_AGENT_INCL_GROUP_ID 2015-02-09 17:31:46.633 THREAD 27 INFO: DROP VIEW V_AGENT_INCL_GROUP_ID 2015-02-09 17:31:46.685 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 17:31:46.721 THREAD 27 INFO: Process SQL script file:Embedded12RU4MP1ToFerrariPCC.sql 2015-02-09 17:31:46.721 THREAD 27 INFO: Process SQL InputStream sqlis:sun.net.www.protocol.jar.JarURLConnection$JarURLInputStream@abc310 2015-02-09 17:31:46.721 THREAD 27 INFO: DatabaseUtilities> execCommandFromScript>> cmdSeperator : ;; , sqlStr : DROP TABLE TASKSTATE 2015-02-09 17:31:46.721 THREAD 27 INFO: DROP TABLE TASKSTATE 2015-02-09 17:31:46.738 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 17:31:46.751 THREAD 27 INFO: DROP TABLE ENUM_MAP 2015-02-09 17:31:46.763 THREAD 27 INFO: CREATE TABLE ENUM_MAP ( NAMESPACE NVARCHAR(255) NULL, VALUE INT NULL, NAME NVARCHAR(255) NULL ) 2015-02-09 17:31:46.770 THREAD 27 INFO: DROP VIEW V_TASKSTATE 2015-02-09 17:31:46.785 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 17:31:46.812 THREAD 27 INFO: DROP VIEW V_SCANS 2015-02-09 17:31:46.835 THREAD 27 INFO: CREATE VIEW V_SCANS as select * from SCANS where DELETED=0 2015-02-09 17:31:46.862 THREAD 27 INFO: INSERT INTO ENUM_MAP (NAMESPACE, VALUE, NAME) VALUES ('LiveUpdate', 0, 'LIVEUPDATE_SUCCEEDED') 2015-02-09 17:31:46.863 THREAD 27 INFO: INSERT INTO ENUM_MAP (NAMESPACE, VALUE, NAME) VALUES ('LiveUpdate', 1, 'LIVEUPDATE_FAILED') 2015-02-09 17:31:46.864 THREAD 27 INFO: INSERT INTO ENUM_MAP (NAMESPACE, VALUE, NAME) VALUES ('LiveUpdate', 2, 'LIVEUPDATE_STARTED') 2015-02-09 17:31:46.865 THREAD 27 INFO: INSERT INTO ENUM_MAP (NAMESPACE, VALUE, NAME) VALUES ('PolicyChange', 0, 'POLICYCHANGE_SUCCEEDED') 2015-02-09 17:31:46.866 THREAD 27 INFO: INSERT INTO ENUM_MAP (NAMESPACE, VALUE, NAME) VALUES ('PolicyChange', 1, 'POLICYCHANGE_FAILED') 2015-02-09 17:31:46.867 THREAD 27 INFO: INSERT INTO ENUM_MAP (NAMESPACE, VALUE, NAME) VALUES ('PolicyChange', 2, 'POLICYCHANGE_REQUESTRECEIVED') 2015-02-09 17:31:46.868 THREAD 27 INFO: INSERT INTO ENUM_MAP (NAMESPACE, VALUE, NAME) VALUES ('PolicyChange', 3, 'POLICYCHANGE_PUBLISHBEGIN') 2015-02-09 17:31:46.869 THREAD 27 INFO: INSERT INTO ENUM_MAP (NAMESPACE, VALUE, NAME) VALUES ('PolicyChange', 4, 'POLICYCHANGE_PUBLISHINPROGRESS') 2015-02-09 17:31:46.869 THREAD 27 INFO: INSERT INTO ENUM_MAP (NAMESPACE, VALUE, NAME) VALUES ('Replication', 0, 'REPLICATION_SUCCESS') 2015-02-09 17:31:46.870 THREAD 27 INFO: INSERT INTO ENUM_MAP (NAMESPACE, VALUE, NAME) VALUES ('Replication', 1, 'REPLICATION_FAILED') 2015-02-09 17:31:46.871 THREAD 27 INFO: INSERT INTO ENUM_MAP (NAMESPACE, VALUE, NAME) VALUES ('Replication', 2, 'REPLICATION_CHANGE_RECEIVED') 2015-02-09 17:31:46.872 THREAD 27 INFO: INSERT INTO ENUM_MAP (NAMESPACE, VALUE, NAME) VALUES ('Replication', 3, 'REPLICATION_REMOTEREPLICATE') 2015-02-09 17:31:46.873 THREAD 27 INFO: INSERT INTO ENUM_MAP (NAMESPACE, VALUE, NAME) VALUES ('Replication', 4, 'REPLICATION_NEEDTO_SYNC_SERVERTIME') 2015-02-09 17:31:46.874 THREAD 27 INFO: INSERT INTO ENUM_MAP (NAMESPACE, VALUE, NAME) VALUES ('Replication', 5, 'REPLICATION_RESOLVING_NAME_CHANGE') 2015-02-09 17:31:46.875 THREAD 27 INFO: INSERT INTO ENUM_MAP (NAMESPACE, VALUE, NAME) VALUES ('Replication', 6, 'REPLICATION_SKIP') 2015-02-09 17:31:46.875 THREAD 27 INFO: INSERT INTO ENUM_MAP (NAMESPACE, VALUE, NAME) VALUES ('Replication', 7, 'REPLICATION_START') 2015-02-09 17:31:46.876 THREAD 27 INFO: INSERT INTO ENUM_MAP (NAMESPACE, VALUE, NAME) VALUES ('Replication', 8, 'REPLICATION_CHANGE_RECEIVING') 2015-02-09 17:31:46.877 THREAD 27 INFO: INSERT INTO ENUM_MAP (NAMESPACE, VALUE, NAME) VALUES ('Replication', 9, 'REPLICATION_DELTAMERGE') 2015-02-09 17:31:46.878 THREAD 27 INFO: ALTER TABLE HYPERVISOR_VENDOR DROP PRIMARY KEY 2015-02-09 17:31:47.313 THREAD 27 INFO: ALTER TABLE HYPERVISOR_VENDOR ADD CONSTRAINT PK_HYPERVISOR_VENDOR PRIMARY KEY (HYPERVISOR_VENDOR_ID) 2015-02-09 17:31:47.618 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 17:31:47.622 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 17:31:47.624 THREAD 27 INFO: ALTER TABLE SEM_COMPUTER MODIFY OPERATION_SYSTEM nvarchar(512) 2015-02-09 17:31:48.013 THREAD 27 INFO: ALTER TABLE SEM_SVA_COMPUTER MODIFY OPERATION_SYSTEM nvarchar(512) 2015-02-09 17:31:48.429 THREAD 27 INFO: DROP VIEW V_AGENT_INCL_GROUP_ID 2015-02-09 17:31:48.479 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 17:31:48.529 THREAD 27 INFO: DROP PROCEDURE SEM_AV_SUMMARY_ATTACKER 2015-02-09 17:31:48.553 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 17:31:48.601 THREAD 27 INFO: DROP PROCEDURE SEM_AV_SUMMARY_SONAR 2015-02-09 17:31:48.637 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 17:31:48.734 THREAD 27 INFO: DROP PROCEDURE SEM_AV_SUMMARY_GROUP 2015-02-09 17:31:48.745 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 17:31:48.762 THREAD 27 INFO: DROP PROCEDURE SEM_AV_SUMMARY_SOURCE 2015-02-09 17:31:48.770 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 17:31:48.787 THREAD 27 INFO: DROP PROCEDURE SEM_AV_SUMMARY_RISK_DIST 2015-02-09 17:31:48.795 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 17:31:48.812 THREAD 27 INFO: DROP PROCEDURE SEM_HOMEPAGE_UNMANAGED_MACHINES 2015-02-09 17:31:48.820 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 17:31:48.837 THREAD 27 INFO: DROP PROCEDURE SEM_HOMEPAGE_TWEXPIRING_LICENSES 2015-02-09 17:31:48.851 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 17:31:48.870 THREAD 27 INFO: DROP PROCEDURE SEM_HOMEPAGE_SONAR_REDANDYELLOW 2015-02-09 17:31:48.878 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 17:31:48.895 THREAD 27 INFO: DROP PROCEDURE SEM_HOMEPAGE_IPS_REDANDYELLOW 2015-02-09 17:31:48.903 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 17:31:48.920 THREAD 27 INFO: DROP PROCEDURE SEM_HOMEPAGE_MRCLEAN_REDANDYELLOW 2015-02-09 17:31:48.928 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 17:31:48.945 THREAD 27 INFO: DROP PROCEDURE SEM_HOMEPAGE_DISABLED_COUNTS 2015-02-09 17:31:48.954 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 17:31:48.970 THREAD 27 INFO: DROP PROCEDURE SEM_HOMEPAGE_TOTAL_TECH 2015-02-09 17:31:48.978 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 17:31:48.995 THREAD 27 INFO: drop view V_CLIENT_CHANGE_LOG 2015-02-09 17:31:49.012 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 17:31:49.054 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 17:31:49.083 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 17:31:49.084 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 17:31:49.085 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 17:31:49.086 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 17:31:49.087 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 17:31:49.088 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 17:31:49.097 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 17:31:49.099 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 17:31:49.099 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 17:31:49.100 THREAD 27 INFO: ALTER TABLE COMPUTER_APPLICATION MODIFY DELETED DEFAULT 0 2015-02-09 17:31:49.446 THREAD 27 INFO: ALTER TABLE SEM_APPLICATION MODIFY DELETED DEFAULT 0 2015-02-09 17:31:49.735 THREAD 27 INFO: ALTER TABLE SCANS MODIFY VSIC_SCAN DEFAULT 0 2015-02-09 17:31:50.012 THREAD 27 INFO: DROP VIEW V_SEM_COMPUTER 2015-02-09 17:31:50.060 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 17:31:50.112 THREAD 27 INFO: DROP VIEW V_SEM_SVA_COMPUTER_NAME 2015-02-09 17:31:50.127 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 17:31:50.154 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 17:31:50.156 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 17:31:50.158 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 17:31:50.160 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 17:31:50.163 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 17:31:50.165 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 17:31:50.166 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 17:31:50.168 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 17:31:50.170 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 17:31:50.172 THREAD 27 INFO: DROP VIEW V_AGENT_INCL_RISK_INFO 2015-02-09 17:31:50.243 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 17:31:50.287 THREAD 27 INFO: drop view V_AGENT_TRAFFIC_LOG 2015-02-09 17:31:50.321 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 17:31:50.362 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 17:31:50.364 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 17:31:50.366 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 17:31:50.368 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 17:31:50.370 THREAD 27 INFO: Process SQL script file:Embedded12RU4MP1ToFerrariPCCIndexes.sql 2015-02-09 17:31:50.371 THREAD 27 INFO: Process SQL InputStream sqlis:sun.net.www.protocol.jar.JarURLConnection$JarURLInputStream@1b909aa 2015-02-09 17:31:50.371 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 17:31:50.371 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 17:31:50.382 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 17:31:50.386 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 17:31:50.391 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 17:31:50.395 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 17:31:50.399 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 17:31:50.404 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 17:31:50.408 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 17:31:50.412 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 17:31:50.416 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 17:31:50.420 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 17:31:50.425 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 17:31:50.429 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 17:31:50.433 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 17:31:50.438 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 17:31:50.442 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 17:31:50.447 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 17:31:50.451 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 17:31:50.455 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 17:31:50.459 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 17:31:50.463 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 17:31:50.468 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 17:31:50.472 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 17:31:50.476 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 17:31:50.480 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 17:31:50.485 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 17:31:50.489 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 17:31:50.504 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 17:31:50.508 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 17:31:50.512 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 17:31:50.516 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 17:31:50.520 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 17:31:50.525 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 17:31:50.529 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 17:31:50.533 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 17:31:50.538 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 17:31:50.542 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 17:31:50.546 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 17:31:50.550 THREAD 27 INFO: IF EXISTS (SELECT NAME FROM SYSINDEXES WHERE NAME = 'I_ALERTS_SOURCE' ) DROP INDEX ALERTS.I_ALERTS_SOURCE 2015-02-09 17:31:50.555 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 17:31:50.559 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 17:31:50.584 THREAD 27 INFO: CREATE INDEX I_ALERTS_SOURCE_ALERT_IDX ON ALERTS(ALERTDATETIME, COMPUTER_IDX, MOTHER_IDX, SOURCE, ALERT_IDX, DELETED) 2015-02-09 17:31:50.601 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 17:31:50.612 THREAD 27 INFO: CREATE INDEX I_SEM_COMPUTER_DELETED ON SEM_COMPUTER(DELETED, COMPUTER_ID, COMPUTER_NAME, IP_ADDR1) 2015-02-09 17:31:50.626 THREAD 27 INFO: Process SQL script file:EmbeddedFerrariPCCToFerrariAlpha.sql 2015-02-09 17:31:50.626 THREAD 27 INFO: Process SQL InputStream sqlis:sun.net.www.protocol.jar.JarURLConnection$JarURLInputStream@91fa73 2015-02-09 17:31:50.627 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 17:31:50.627 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 17:31:50.629 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 17:31:50.630 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 17:31:50.632 THREAD 27 INFO: /* New table for maintaining trusted partner records */ DROP TABLE OAUTH_TRUSTED_PARTNER 2015-02-09 17:31:50.646 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 17:31:50.659 THREAD 27 INFO: DROP TABLE PROCESSING_MARKER 2015-02-09 17:31:50.676 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 17:31:50.687 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 17:31:50.690 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 17:31:50.692 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 17:31:50.694 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 17:31:50.698 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 17:31:50.702 THREAD 27 INFO: drop view V_AGENT_SECURITY_LOG 2015-02-09 17:31:50.746 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 17:31:50.793 THREAD 27 INFO: Process SQL script file:EmbeddedFerrariAlphaToFerrariBeta.sql 2015-02-09 17:31:50.794 THREAD 27 INFO: Process SQL InputStream sqlis:sun.net.www.protocol.jar.JarURLConnection$JarURLInputStream@eabd9c 2015-02-09 17:31:50.794 THREAD 27 INFO: DatabaseUtilities> execCommandFromScript>> cmdSeperator : ;; , sqlStr : DROP TABLE AUDIT_LOG 2015-02-09 17:31:50.794 THREAD 27 INFO: DROP TABLE AUDIT_LOG 2015-02-09 17:31:50.812 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 17:31:50.826 THREAD 27 INFO: CREATE INDEX I_AUDIT_TIMESTAMP ON AUDIT_LOG (TIMESTAMP) 2015-02-09 17:31:50.837 THREAD 27 INFO: DROP VIEW V_AUDIT_SYS_ADMIN 2015-02-09 17:31:50.852 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 17:31:50.876 THREAD 27 INFO: DROP VIEW V_AUDIT_LIMITED_ADMIN 2015-02-09 17:31:50.892 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 17:31:50.912 THREAD 27 INFO: DROP VIEW V_AUDIT_LOG 2015-02-09 17:31:50.927 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 17:31:50.954 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 17:31:50.978 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 17:31:51.669 THREAD 27 INFO: ALTER TABLE SEM_SVA_COMPUTER MODIFY OPERATION_SYSTEM nvarchar(512) NULL 2015-02-09 17:31:52.096 THREAD 27 INFO: /* re-create the view after alterning table*/ DROP VIEW V_SEM_COMPUTER 2015-02-09 17:31:52.144 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 17:31:52.193 THREAD 27 INFO: DROP VIEW V_SEM_SVA_COMPUTER 2015-02-09 17:31:52.244 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 17:31:52.293 THREAD 27 INFO: DROP VIEW V_ALERTS 2015-02-09 17:31:52.319 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 17:31:52.343 THREAD 27 INFO: Process SQL script file:EmbeddedFerrariBeta1ToFerrariBeta2.sql 2015-02-09 17:31:52.344 THREAD 27 INFO: Process SQL InputStream sqlis:sun.net.www.protocol.jar.JarURLConnection$JarURLInputStream@9f0ead 2015-02-09 17:31:52.344 THREAD 27 INFO: DatabaseUtilities> execCommandFromScript>> cmdSeperator : ;; , sqlStr : /* Defect 3522262 */ DROP VIEW V_HPP_APPLICATION_RISK 2015-02-09 17:31:52.344 THREAD 27 INFO: /* Defect 3522262 */ DROP VIEW V_HPP_APPLICATION_RISK 2015-02-09 17:31:52.360 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 17:31:52.385 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 17:31:52.386 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 17:31:52.386 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 17:31:52.388 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 17:31:52.389 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 17:31:52.390 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 17:31:52.390 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 17:31:52.391 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 17:31:52.392 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 17:31:52.393 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 17:31:52.394 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 17:31:52.395 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 17:31:52.395 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 17:31:52.407 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 17:31:52.426 THREAD 27 INFO: /* Defect 3536829 */ DROP VIEW V_SEM_SVA_COMPUTER_NAME 2015-02-09 17:31:52.442 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 17:31:52.460 THREAD 27 INFO: Process SQL script file:EmbeddedFerrariBeta2ToFerrariRC.sql 2015-02-09 17:31:52.461 THREAD 27 INFO: Process SQL InputStream sqlis:sun.net.www.protocol.jar.JarURLConnection$JarURLInputStream@1e41418 2015-02-09 17:31:52.461 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 17:31:52.461 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 17:31:52.474 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 17:31:52.485 THREAD 27 INFO: DROP PROCEDURE SEM_AV_SUMMARY_SOURCE 2015-02-09 17:31:52.501 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 17:31:52.535 THREAD 27 INFO: DROP PROCEDURE SEM_AV_SUMMARY_GROUP 2015-02-09 17:31:52.543 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 17:31:52.560 THREAD 27 INFO: DROP PROCEDURE SEM_AV_SUMMARY_RISK_DIST 2015-02-09 17:31:52.568 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 17:31:52.591 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 17:31:52.594 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 17:31:52.596 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 17:31:52.599 THREAD 27 INFO: DROP VIEW V_SEM_COMPUTER 2015-02-09 17:31:52.644 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 17:31:52.693 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 17:31:52.695 THREAD 27 WARNING: Upgrade> doUpgrade>> Upgrading database schema done! 2015-02-09 17:31:52.727 THREAD 27 WARNING: Upgrade> doUpgrade>> upgradeSemConfigRootObject... 2015-02-09 17:31:52.732 THREAD 27 WARNING: Upgrade> doUpgrade>> upgradeSemConfigRootObject...Done 2015-02-09 17:31:52.755 THREAD 27 INFO: Upgrading from 12 RU3 to 12 RU4 2015-02-09 17:31:52.755 THREAD 27 INFO: UpgradeStep >> checkUpgradeStatus. 2015-02-09 17:31:52.755 THREAD 27 INFO: UpgradeStep >> checkUpgradeStatus. 2015-02-09 17:31:52.765 THREAD 27 INFO: UpgradeStep >> checkUpgradeStatus. 2015-02-09 17:31:52.765 THREAD 27 INFO: UpgradeStep >> checkUpgradeStatus. 2015-02-09 17:31:52.835 THREAD 27 INFO: upgradeADCPolicies>> Started. 2015-02-09 17:31:52.865 THREAD 27 INFO: upgradeADCPolicies>> domainId:1637D4D8C0A8003401C958AFE493528B startIndex:1 policyBatchSize:50 morePolicies:true 2015-02-09 17:31:52.919 THREAD 27 INFO: upgradeADCPolicies>> domain:1637D4D8C0A8003401C958AFE493528B retrieved policy size:1 morePolicies:false 2015-02-09 17:31:52.922 THREAD 27 INFO: addSEPMigrationExclusions>> Checking policy Application and Device Control policy id=E17A3765C0A80034013C296BFF1D9C2A 2015-02-09 17:31:52.923 THREAD 27 INFO: addSEPMigrationExclusions>> policy Application and Device Control policy contains SEP migration blocking settings 2015-02-09 17:31:52.924 THREAD 27 INFO: addSEPMigrationExclusions>> added SEP migration exclusions to policy Application and Device Control policy 2015-02-09 17:31:52.924 THREAD 27 INFO: addSEPMigrationExclusions>> Finished policy Application and Device Control policy id=E17A3765C0A80034013C296BFF1D9C2A added=true 2015-02-09 17:31:53.129 THREAD 27 INFO: upgradeADCPolicies>> Commit policy Application and Device Control policy id=E17A3765C0A80034013C296BFF1D9C2A 2015-02-09 17:31:53.129 THREAD 27 INFO: upgradeADCPolicies>> Finished. The result is: true 2015-02-09 17:31:53.132 THREAD 27 INFO: Upgrading Mac policies from 12.1.3.0 to 12.1.4.0 2015-02-09 17:31:53.132 THREAD 27 INFO: MacLuPolicyUpgrade: Start upgrading of LU Content policies for Mac settings 2015-02-09 17:31:53.148 THREAD 27 INFO: fetching domain ids for the policies 2015-02-09 17:31:53.151 THREAD 27 INFO: upgradeMacAVPolicy>> startIndex: 1 policyBatchSize: 50 morePolicies:true 2015-02-09 17:31:53.157 THREAD 27 INFO: loaded [1] LUContent policies 2015-02-09 17:31:53.157 THREAD 27 INFO: MacLuIPSPolicyUpgrade: Working on Domain:[1637D4D8C0A8003401C958AFE493528B] 2015-02-09 17:31:53.157 THREAD 27 INFO: MacLuPolicyUpgrade: Domain Id: 1637D4D8C0A8003401C958AFE493528B LU Content Policy: LiveUpdate Content policy 2015-02-09 17:31:53.195 THREAD 27 INFO: MacLuPolicyUpgrade: Domain: 1637D4D8C0A8003401C958AFE493528B LU Content Policy: LiveUpdate Content policy. Policy Updated successfully 2015-02-09 17:31:53.195 THREAD 27 INFO: MacLuPolicyUpgrade: Finished upgrading of LU Content policies for Mac settings 2015-02-09 17:31:53.195 THREAD 27 INFO: Start upgrading Mac AV policies for Mac settings ... 2015-02-09 17:31:53.195 THREAD 27 INFO: fetching domain ids for the policies 2015-02-09 17:31:53.198 THREAD 27 INFO: upgradeMacAVPolicy>> startIndex: 1 policyBatchSize: 50 morePolicies:true 2015-02-09 17:31:53.288 THREAD 27 INFO: upgradeMacAVPolicy>> No of AV policies retrieved : 5 2015-02-09 17:31:53.288 THREAD 27 INFO: Number of MacAdminDefinedScans associated with this AvPolicy = 0 2015-02-09 17:31:53.288 THREAD 27 INFO: SchemaMacPolicyUpgradeToAmberRU4.upgradeAVPolicy:: Upgrading AV policy for domain :[1637D4D8C0A8003401C958AFE493528B] 2015-02-09 17:31:53.289 THREAD 27 INFO: SchemaMacPolicyUpgradeToAmberRU4.upgradeAVPolicy() :: updating AV Policy : id: 03D93153C0A8003400238016B07DBC6E 2015-02-09 17:31:53.325 THREAD 27 INFO: Number of MacAdminDefinedScans associated with this AvPolicy = 1 2015-02-09 17:31:53.326 THREAD 27 INFO: SchemaMacPolicyUpgradeToAmberRU4.upgradeAVPolicy:: Upgrading AV policy for domain :[1637D4D8C0A8003401C958AFE493528B] 2015-02-09 17:31:53.326 THREAD 27 INFO: SchemaMacPolicyUpgradeToAmberRU4.upgradeAVPolicy() :: updating AV Policy : id: 45B52356C0A8003400D78DF072DC0D07 2015-02-09 17:31:53.580 THREAD 27 INFO: Number of MacAdminDefinedScans associated with this AvPolicy = 1 2015-02-09 17:31:53.580 THREAD 27 INFO: SchemaMacPolicyUpgradeToAmberRU4.upgradeAVPolicy:: Upgrading AV policy for domain :[1637D4D8C0A8003401C958AFE493528B] 2015-02-09 17:31:53.580 THREAD 27 INFO: SchemaMacPolicyUpgradeToAmberRU4.upgradeAVPolicy() :: updating AV Policy : id: 59E6DABFC0A80034012F99241C35E179 2015-02-09 17:31:53.605 THREAD 27 INFO: Number of MacAdminDefinedScans associated with this AvPolicy = 1 2015-02-09 17:31:53.605 THREAD 27 INFO: SchemaMacPolicyUpgradeToAmberRU4.upgradeAVPolicy:: Upgrading AV policy for domain :[1637D4D8C0A8003401C958AFE493528B] 2015-02-09 17:31:53.605 THREAD 27 INFO: SchemaMacPolicyUpgradeToAmberRU4.upgradeAVPolicy() :: updating AV Policy : id: B657CFF5C0A8003400C075279BCECD59 2015-02-09 17:31:53.631 THREAD 27 INFO: Number of MacAdminDefinedScans associated with this AvPolicy = 0 2015-02-09 17:31:53.631 THREAD 27 WARNING: SchemaMacPolicyUpgradeToAmberRU4.getAvFileApObject :: AV Policy does not contain Mac AV Auto Protect policy. isTemplate: false id: E20C7C23C0A8003400CADE319D09BAC9 2015-02-09 17:31:53.631 THREAD 27 INFO: Finished upgrading Mac AV policies for Mac settings ... 2015-02-09 17:31:53.631 THREAD 27 INFO: Start upgrading Mac Admin Defined Scans for Mac settings ... 2015-02-09 17:31:53.631 THREAD 27 INFO: getMacADSGuids>> startIndex: 0 policyBatchSize: 50 endIndex: 49 2015-02-09 17:31:53.711 THREAD 27 INFO: Finished upgrading Mac Admin Defined Scans policies for Mac settings ... 2015-02-09 17:31:53.711 THREAD 27 INFO: Start upgrading Mac Scheduled Scan Templates for Mac settings ... 2015-02-09 17:31:53.711 THREAD 27 INFO: SchemaMacPolicyUpgradeToAmberRU4.upgradeMacScheduleScanTemplates begins 2015-02-09 17:31:53.718 THREAD 27 INFO: SchemaMacPolicyUpgradeToAmberRU4.upgradeMacScheduleScanTemplates:: Upgrading policy templates for domain : 1637D4D8C0A8003401C958AFE493528B 2015-02-09 17:31:53.722 THREAD 27 SEVERE: java.lang.NullPointerException 2015-02-09 17:31:53.722 THREAD 27 SEVERE: at com.sygate.scm.server.upgrade.SchemaMacPolicyUpgradeToAmberRU4.upgradeMacAdminScanInScheduleScanTemplates(SchemaMacPolicyUpgradeToAmberRU4.java:610) 2015-02-09 17:31:53.722 THREAD 27 SEVERE: at com.sygate.scm.server.upgrade.SchemaMacPolicyUpgradeToAmberRU4.upgrade(SchemaMacPolicyUpgradeToAmberRU4.java:127) 2015-02-09 17:31:53.722 THREAD 27 SEVERE: at com.sygate.scm.server.upgrade.Schema12RU3To12RU4.upgrade(Schema12RU3To12RU4.java:63) 2015-02-09 17:31:53.722 THREAD 27 SEVERE: at com.sygate.scm.server.upgrade.SchemaUpgrade.execute(SchemaUpgrade.java:84) 2015-02-09 17:31:53.722 THREAD 27 SEVERE: at com.sygate.scm.server.upgrade.Upgrade.doUpgrade(Upgrade.java:1221) 2015-02-09 17:31:53.723 THREAD 27 SEVERE: at com.sygate.scm.server.upgrade.ui.UpgradeTask.go(UpgradeTask.java:114) 2015-02-09 17:31:53.723 THREAD 27 SEVERE: at com.sygate.scm.server.upgrade.ui.UpgradeProgressPanel$2.construct(UpgradeProgressPanel.java:241) 2015-02-09 17:31:53.723 THREAD 27 SEVERE: at com.sygate.scm.util.SwingWorker$2.run(SwingWorker.java:145) 2015-02-09 17:31:53.723 THREAD 27 SEVERE: at java.lang.Thread.run(Thread.java:745) 2015-02-09 17:31:53.723 THREAD 27 SEVERE: Upgrade.doUpgrade java.lang.NullPointerException 2015-02-09 17:31:53.723 THREAD 27 WARNING: Upgrade> doUpgrade>> Upgrade process completed in (ms) : 18617 2015-02-09 17:31:53.855 THREAD 27 INFO: AuditUtil> auditEvent>> The Upgrading is executed by windows user: administrator 2015-02-09 17:31:53.869 THREAD 23 INFO: MainFrame>> doInitFinalPanel> Upgrade.serviceInstallState = 0 2015-02-09 17:31:57.353 THREAD 23 INFO: UpgradeFinalPanel >> saveStage > Starting the semsrv service... 2015-02-09 17:32:00.521 THREAD 23 INFO: The Symantec Endpoint Protection Manager Webserver service is starting.The Symantec Endpoint Protection Manager Webserver service was started successfully. 2015-02-09 17:32:00.522 THREAD 23 INFO: SemServiceManager> serviceControl>> Executed command - start semwebsrv, process return value = 0 2015-02-09 17:32:02.617 THREAD 23 INFO: The Symantec Endpoint Protection Manager service is starting.The Symantec Endpoint Protection Manager service was started successfully. 2015-02-09 17:32:02.618 THREAD 23 INFO: SemServiceManager> serviceControl>> Executed command - start semsrv, process return value = 0 2015-02-09 17:32:02.691 THREAD 23 INFO: The service name is invalid.More help is available by typing NET HELPMSG 2185. 2015-02-09 17:32:02.691 THREAD 23 INFO: SemServiceManager> serviceControl>> Executed command - start semlaunchsrv, process return value = 2