The following document contains the results of Rat (Release Audit Tool).
*****************************************************
Summary
-------
Generated at: 2017-03-12T00:14:40-05:00
Notes: 0
Binaries: 0
Archives: 2
Standards: 10
Apache Licensed: 0
Generated Documents: 0
JavaDocs are generated, thus a license header is optional.
Generated files do not require license headers.
10 Unknown Licenses
*****************************************************
Files with unapproved licenses:
C:/projects/fgsms/fgsms-server/fgsms-database-export/db_test.sql
C:/projects/fgsms/fgsms-server/fgsms-database-export/export_fgsms_config.sql
C:/projects/fgsms/fgsms-server/fgsms-database-export/export_fgsms_performance.sql
C:/projects/fgsms/fgsms-server/fgsms-database-export/pom.xml
C:/projects/fgsms/fgsms-server/fgsms-database-export/src/main/java/org/miloss/fgsms/tools/Column.java
C:/projects/fgsms/fgsms-server/fgsms-database-export/src/main/java/org/miloss/fgsms/tools/DatabaseExport.java
C:/projects/fgsms/fgsms-server/fgsms-database-export/src/main/java/org/miloss/fgsms/tools/JDBCType.java
C:/projects/fgsms/fgsms-server/fgsms-database-export/src/main/java/org/miloss/fgsms/tools/Table.java
C:/projects/fgsms/fgsms-server/fgsms-database-export/src/main/resources/log4j.properties
C:/projects/fgsms/fgsms-server/fgsms-database-export/src/main/resources/log4j.xml
*****************************************************
Archives:
+ C:/projects/fgsms/fgsms-server/fgsms-database-export/test.tar
+ C:/projects/fgsms/fgsms-server/fgsms-database-export/testc.tar
*****************************************************
Files with Apache License headers will be marked AL
Binary files (which do not require any license headers) will be marked B
Compressed archives will be marked A
Notices, licenses etc. will be marked N
!????? C:/projects/fgsms/fgsms-server/fgsms-database-export/db_test.sql
!????? C:/projects/fgsms/fgsms-server/fgsms-database-export/export_fgsms_config.sql
!????? C:/projects/fgsms/fgsms-server/fgsms-database-export/export_fgsms_performance.sql
!????? C:/projects/fgsms/fgsms-server/fgsms-database-export/pom.xml
!????? C:/projects/fgsms/fgsms-server/fgsms-database-export/src/main/java/org/miloss/fgsms/tools/Column.java
!????? C:/projects/fgsms/fgsms-server/fgsms-database-export/src/main/java/org/miloss/fgsms/tools/DatabaseExport.java
!????? C:/projects/fgsms/fgsms-server/fgsms-database-export/src/main/java/org/miloss/fgsms/tools/JDBCType.java
!????? C:/projects/fgsms/fgsms-server/fgsms-database-export/src/main/java/org/miloss/fgsms/tools/Table.java
!????? C:/projects/fgsms/fgsms-server/fgsms-database-export/src/main/resources/log4j.properties
!????? C:/projects/fgsms/fgsms-server/fgsms-database-export/src/main/resources/log4j.xml
A C:/projects/fgsms/fgsms-server/fgsms-database-export/test.tar
A C:/projects/fgsms/fgsms-server/fgsms-database-export/testc.tar
*****************************************************
Printing headers for text files without a valid license header...
=====================================================
== File: C:/projects/fgsms/fgsms-server/fgsms-database-export/db_test.sql
=====================================================
-- used during CI tests only,
-- creates alternate the databases to test the db export's validity
CREATE DATABASE fgsms_performance_test
WITH OWNER = fgsms
ENCODING = 'UTF8'
TABLESPACE = pg_default
CONNECTION LIMIT = -1
;
CREATE DATABASE fgsms_config_test
WITH OWNER = fgsms
ENCODING = 'UTF8'
TABLESPACE = pg_default
CONNECTION LIMIT = -1
;
-- switch to the performance database
\c fgsms_performance_test
;
CREATE TABLE statusext
(
uri text NOT NULL,
utcdatetime bigint NOT NULL,
dataname text NOT NULL,
datavalue text NOT NULL
)
WITH (
OIDS=FALSE
);
ALTER TABLE statusext OWNER TO fgsms
;
COMMENT ON TABLE statusext IS 'fgsms version 6.3 and up'
;
--quick access for web service dependency injection
CREATE TABLE dependencies
(
sourcesoapaction text NOT NULL,
destinationsoapaction text NOT NULL,
destinationurl text NOT NULL,
sourceurl text NOT NULL,
CONSTRAINT dependencies_pkey PRIMARY KEY (sourceurl, destinationurl, destinationsoapaction, sourcesoapaction)
)
=====================================================
== File: C:/projects/fgsms/fgsms-server/fgsms-database-export/export_fgsms_config.sql
=====================================================
insert into agents(agenttype) VALUES ('org.miloss.fgsms.osagent.OSAgent');
insert into agents(agenttype) VALUES ('org.miloss.fgsms.agents.JAXWSGenericAgent');
insert into agents(agenttype) VALUES ('agent');
insert into agents(agenttype) VALUES ('junitAgent');
insert into dcsservicehosts(hostname,records) VALUES ('desktop-ni28oib',1121);
insert into auditlog(utcdatetime,username,classname,method,memo,classification,ipaddress) VALUES (1485114139843,'fgsmsagent','org.miloss.fgsms.services.pcs.impl.PCS4jBean','setProcessListByMachine','desktop-ni28oib JVM Free:60542752 Total: 237834240 0.7454413964953069% in use, processors: 8','UNCLASSIFIED None','127.0.0.1');
insert into auditlog(utcdatetime,username,classname,method,memo,classification,ipaddress) VALUES (1485114139896,'fgsmsagent','org.miloss.fgsms.services.pcs.impl.PCS4jBean','Createpolicy','urn:desktop-ni28oib:system JVM Free:58935392 Total: 237834240 0.7521997169120813% in use, processors: 8','UNCLASSIFIED None','127.0.0.1');
insert into auditlog(utcdatetime,username,classname,method,memo,classification,ipaddress) VALUES (1485114140878,'fgsmsagent','org.miloss.fgsms.services.pcs.impl.PCS4jBean','getServicePolicy','http://desktop-ni28oib:8888/fgsmsServices/services/PCS JVM Free:127322224 Total: 281346048 0.5474533056174296% in use, processors: 8','UNCLASSIFIED None','127.0.0.1');
insert into auditlog(utcdatetime,username,classname,method,memo,classification,ipaddress) VALUES (1485114140996,'fgsmsagent','org.miloss.fgsms.services.pcs.impl.PCS4jBean','Createpolicy','http://desktop-ni28oib:8888/fgsmsServices/services/PCS JVM Free:122624944 Total: 281346048 0.564149043956004% in use, processors: 8','UNCLASSIFIED None','127.0.0.1');
insert into auditlog(utcdatetime,username,classname,method,memo,classification,ipaddress) VALUES (1485114141083,'fgsmsagent','org.miloss.fgsms.services.dcs.impl.DCS4jBean','addMachineAndProcessData','uri=desktop-ni28oib JVM Free:118156856 Total: 281346048 0.5800301556039629% in use, processors: 8','UNCLASSIFIED None','127.0.0.1');
insert into auditlog(utcdatetime,username,classname,method,memo,classification,ipaddress) VALUES (1485114141142,'fgsmsagent','org.miloss.fgsms.services.dcs.impl.DCS4jBean','addMoreData','msg count=1 1st record agent type=org.miloss.fgsms.agents.JAXWSGenericAgent uri=http://desktop-ni28oib:8888/fgsmsServices/services/PCS JVM Free:116615472 Total: 281346048 0.5855087610827219% in use, processors: 8','UNCLASSIFIED None','127.0.0.1');
insert into auditlog(utcdatetime,username,classname,method,memo,classification,ipaddress) VALUES (1485114141265,'fgsmsagent','org.miloss.fgsms.services.pcs.impl.PCS4jBean','getServicePolicy','http://desktop-ni28oib:8888/fgsmsServices/services/DCS JVM Free:114013136 Total: 281346048 0.5947583525324657% in use, processors: 8','UNCLASSIFIED None','127.0.0.1');
insert into auditlog(utcdatetime,username,classname,method,memo,classification,ipaddress) VALUES (1485114141343,'fgsmsagent','org.miloss.fgsms.services.dcs.impl.DCS4jBean','addMoreData','msg count=1 1st record agent type=org.miloss.fgsms.agents.JAXWSGenericAgent uri=http://desktop-ni28oib:8888/fgsmsServices/services/DCS JVM Free:112294064 Total: 281346048 0.600868521885191% in use, processors: 8','UNCLASSIFIED None','127.0.0.1');
insert into auditlog(utcdatetime,username,classname,method,memo,classification,ipaddress) VALUES (1485114170461,'fgsmsagent','org.miloss.fgsms.services.dcs.impl.DCS4jBean','addMachineAndProcessData','uri=desktop-ni28oib JVM Free:111746384 Total: 281346048 0.6028151637658689% in use, processors: 8','UNCLASSIFIED None','127.0.0.1');
insert into auditlog(utcdatetime,username,classname,method,memo,classification,ipaddress) VALUES (1485114170490,'fgsmsagent','org.miloss.fgsms.services.dcs.impl.DCS4jBean','addMoreData','msg count=1 1st record agent type=org.miloss.fgsms.agents.JAXWSGenericAgent uri=http://desktop-ni28oib:8888/fgsmsServices/services/DCS JVM Free:109553424 Total: 281346048 0.6106096930140635% in use, processors: 8','UNCLASSIFIED None','127.0.0.1');
insert into auditlog(utcdatetime,username,classname,method,memo,classification,ipaddress) VALUES (1485114200762,'fgsmsagent','org.miloss.fgsms.services.dcs.impl.DCS4jBean','addMachineAndProcessData','uri=desktop-ni28oib JVM Free:105137096 Total: 281346048 0.6263068319338895% in use, processors: 8','UNCLASSIFIED None','127.0.0.1');
insert into auditlog(utcdatetime,username,classname,method,memo,classification,ipaddress) VALUES (1485114200789,'fgsmsagent','org.miloss.fgsms.services.dcs.impl.DCS4jBean','addMoreData','msg count=1 1st record agent type=org.miloss.fgsms.agents.JAXWSGenericAgent uri=http://desktop-ni28oib:8888/fgsmsServices/services/DCS JVM Free:103198664 Total: 281346048 0.6331966816893053% in use, processors: 8','UNCLASSIFIED None','127.0.0.1');
insert into auditlog(utcdatetime,username,classname,method,memo,classification,ipaddress) VALUES (1485114212207,'fgsmsadmin','org.miloss.fgsms.services.pcs.impl.PCS4jBean','getGlobalPolicy','JVM Free:95812664 Total: 281346048 0.6594490497339419% in use, processors: 8','UNCLASSIFIED none','127.0.0.1');
insert into auditlog(utcdatetime,username,classname,method,memo,classification,ipaddress) VALUES (1485114212221,'fgsmsagent','org.miloss.fgsms.services.dcs.impl.DCS4jBean','addMoreData','msg count=1 1st record agent type=org.miloss.fgsms.agents.JAXWSGenericAgent uri=http://desktop-ni28oib:8888/fgsmsServices/services/PCS JVM Free:93459224 Total: 281346048 0.6678139797435505% in use, processors: 8','UNCLASSIFIED None','127.0.0.1');
insert into auditlog(utcdatetime,username,classname,method,memo,classification,ipaddress) VALUES (1485114213234,'fgsmsadmin','org.miloss.fgsms.services.status.impl.StatusServiceImpl','getAllStatus','JVM Free:102909416 Total: 281346048 0.634224767927076% in use, processors: 8','UNCLASSIFIED None','127.0.0.1');
insert into auditlog(utcdatetime,username,classname,method,memo,classification,ipaddress) VALUES (1485114213296,'fgsmsadmin','org.miloss.fgsms.services.das.impl.DAS4jBean','GetMonitoredServiceList','JVM Free:95579472 Total: 281346048 0.6602778937914919% in use, processors: 8','UNCLASSIFIED None','127.0.0.1');
insert into auditlog(utcdatetime,username,classname,method,memo,classification,ipaddress) VALUES (1485114213297,'fgsmsadmin','org.miloss.fgsms.services.das.impl.DAS4jBean','GetServiceListfromPolicyDB','JVM Free:95579472 Total: 281346048 0.6602778937914919% in use, processors: 8','UNCLASSIFIED None','127.0.0.1');
insert into auditlog(utcdatetime,username,classname,method,memo,classification,ipaddress) VALUES (1485114213311,'fgsmsagent','org.miloss.fgsms.services.pcs.impl.PCS4jBean','getServicePolicy','http://desktop-ni28oib:8888/fgsmsServices/services/SS JVM Free:94377600 Total: 281346048 0.6645497575995807% in use, processors: 8','UNCLASSIFIED None','127.0.0.1');
insert into auditlog(utcdatetime,username,classname,method,memo,classification,ipaddress) VALUES (1485114213334,'fgsmsadmin','org.miloss.fgsms.services.das.impl.DAS4jBean','getQuickStatsAllRequest','JVM Free:92063736 Total: 281346048 0.672774020980739% in use, processors: 8','UNCLASSIFIED None','127.0.0.1');
insert into auditlog(utcdatetime,username,classname,method,memo,classification,ipaddress) VALUES (1485114213335,'fgsmsadmin','org.miloss.fgsms.services.das.impl.DAS4jBean','GetServiceListfromPolicyDB','JVM Free:91997696 Total: 281346048 0.6730087497088283% in use, processors: 8','UNCLASSIFIED None','127.0.0.1');
insert into auditlog(utcdatetime,username,classname,method,memo,classification,ipaddress) VALUES (1485114213370,'fgsmsagent','org.miloss.fgsms.services.pcs.impl.PCS4jBean','Createpolicy','http://desktop-ni28oib:8888/fgsmsServices/services/SS JVM Free:91087376 Total: 281346048 0.676244338075792% in use, processors: 8','UNCLASSIFIED None','127.0.0.1');
insert into auditlog(utcdatetime,username,classname,method,memo,classification,ipaddress) VALUES (1485114213376,'fgsmsagent','org.miloss.fgsms.services.pcs.impl.PCS4jBean','getServicePolicy','http://desktop-ni28oib:8888/fgsmsServices/services/DAS JVM Free:90042928 Total: 281346048 0.6799566631908048% in use, processors: 8','UNCLASSIFIED None','127.0.0.1');
insert into auditlog(utcdatetime,username,classname,method,memo,classification,ipaddress) VALUES (1485114213408,'fgsmsagent','org.miloss.fgsms.services.dcs.impl.DCS4jBean','addMoreData','msg count=1 1st record agent type=org.miloss.fgsms.agents.JAXWSGenericAgent uri=http://desktop-ni28oib:8888/fgsmsServices/services/SS JVM Free:84951120 Total: 281346048 0.6980546888648672% in use, processors: 8','UNCLASSIFIED None','127.0.0.1');
insert into auditlog(utcdatetime,username,classname,method,memo,classification,ipaddress) VALUES (1485114213438,'fgsmsagent','org.miloss.fgsms.services.pcs.impl.PCS4jBean','Createpolicy','http://desktop-ni28oib:8888/fgsmsServices/services/DAS JVM Free:81668184 Total: 281346048 0.7097233652985238% in use, processors: 8','UNCLASSIFIED None','127.0.0.1');
insert into auditlog(utcdatetime,username,classname,method,memo,classification,ipaddress) VALUES (1485114213457,'fgsmsagent','org.miloss.fgsms.services.pcs.impl.PCS4jBean','getServicePolicy','http://desktop-ni28oib:8888/fgsmsServices/services/DAS JVM Free:77667344 Total: 281346048 0.7239437178801246% in use, processors: 8','UNCLASSIFIED None','127.0.0.1');
insert into auditlog(utcdatetime,username,classname,method,memo,classification,ipaddress) VALUES (1485114213459,'fgsmsagent','org.miloss.fgsms.services.dcs.impl.DCS4jBean','addMoreData','msg count=1 1st record agent type=org.miloss.fgsms.agents.JAXWSGenericAgent uri=http://desktop-ni28oib:8888/fgsmsServices/services/DAS JVM Free:77610448 Total: 281346048 0.7241459457074015% in use, processors: 8','UNCLASSIFIED None','127.0.0.1');
insert into auditlog(utcdatetime,username,classname,method,memo,classification,ipaddress) VALUES (1485114213524,'fgsmsagent','org.miloss.fgsms.services.dcs.impl.DCS4jBean','addMoreData','msg count=1 1st record agent type=org.miloss.fgsms.agents.JAXWSGenericAgent uri=http://desktop-ni28oib:8888/fgsmsServices/services/DAS JVM Free:75547016 Total: 281346048 0.7314800881795219% in use, processors: 8','UNCLASSIFIED None','127.0.0.1');
insert into auditlog(utcdatetime,username,classname,method,memo,classification,ipaddress) VALUES (1485114222587,'fgsmsadmin','org.miloss.fgsms.services.pcs.impl.PCS4jBean','getDomainList','JVM Free:82549776 Total: 281346048 0.706589886060884% in use, processors: 8','UNCLASSIFIED None','127.0.0.1');
insert into auditlog(utcdatetime,username,classname,method,memo,classification,ipaddress) VALUES (1485114222605,'fgsmsagent','org.miloss.fgsms.services.dcs.impl.DCS4jBean','addMoreData','msg count=1 1st record agent type=org.miloss.fgsms.agents.JAXWSGenericAgent uri=http://desktop-ni28oib:8888/fgsmsServices/services/PCS JVM Free:80683104 Total: 281346048 0.7132246762534941% in use, processors: 8','UNCLASSIFIED None','127.0.0.1');
insert into auditlog(utcdatetime,username,classname,method,memo,classification,ipaddress) VALUES (1485114223316,'fgsmsadmin','org.miloss.fgsms.services.pcs.impl.PCS4jBean','getMachinesByDomain','unspecified JVM Free:73737696 Total: 281346048 0.7379110297650244% in use, processors: 8','UNCLASSIFIED None','127.0.0.1');
insert into auditlog(utcdatetime,username,classname,method,memo,classification,ipaddress) VALUES (1485114223341,'fgsmsagent','org.miloss.fgsms.services.dcs.impl.DCS4jBean','addMoreData','msg count=1 1st record agent type=org.miloss.fgsms.agents.JAXWSGenericAgent uri=http://desktop-ni28oib:8888/fgsmsServices/services/PCS JVM Free:71833248 Total: 281346048 0.7446800887709644% in use, processors: 8','UNCLASSIFIED None','127.0.0.1');
insert into auditlog(utcdatetime,username,classname,method,memo,classification,ipaddress) VALUES (1485114224079,'fgsmsadmin','org.miloss.fgsms.services.pcs.impl.PCS4jBean','getProcessesListByMachine','desktop-ni28oib JVM Free:64719184 Total: 281346048 0.7699659033419229% in use, processors: 8','UNCLASSIFIED None','127.0.0.1');
insert into auditlog(utcdatetime,username,classname,method,memo,classification,ipaddress) VALUES (1485114224120,'fgsmsagent','org.miloss.fgsms.services.dcs.impl.DCS4jBean','addMoreData','msg count=1 1st record agent type=org.miloss.fgsms.agents.JAXWSGenericAgent uri=http://desktop-ni28oib:8888/fgsmsServices/services/PCS JVM Free:98384608 Total: 281346048 0.6503074818381668% in use, processors: 8','UNCLASSIFIED None','127.0.0.1');
=====================================================
== File: C:/projects/fgsms/fgsms-server/fgsms-database-export/export_fgsms_performance.sql
=====================================================
insert into rawdatamachineprocess(uri,memoryused,percentcpu,id,utcdatetime,threads,openfiles,startedat) VALUES ('urn:desktop-ni28oib:system',0,0,'eaff9c0b-f577-413c-a0ae-9502e7e88c03',1485114141085,1995,0,70057000);
insert into rawdatamachineprocess(uri,memoryused,percentcpu,id,utcdatetime,threads,openfiles,startedat) VALUES ('urn:desktop-ni28oib:system',0,0,'c067347e-fc07-413a-b3f0-d6dcbccb7856',1485114170462,1910,0,70086000);
insert into rawdatamachineprocess(uri,memoryused,percentcpu,id,utcdatetime,threads,openfiles,startedat) VALUES ('urn:desktop-ni28oib:system',0,0,'40986c5e-d385-4e0a-8ad9-80f7548ae947',1485114200763,1871,0,70117000);
insert into rawdatamachineprocess(uri,memoryused,percentcpu,id,utcdatetime,threads,openfiles,startedat) VALUES ('urn:desktop-ni28oib:system',0,0,'500f5108-7ddf-4214-ac10-477684388460',1485114231071,1921,0,70147000);
insert into rawdatamachineprocess(uri,memoryused,percentcpu,id,utcdatetime,threads,openfiles,startedat) VALUES ('urn:desktop-ni28oib:system',0,0,'f2c09f73-6aa0-423d-97e8-3b0e933e574f',1485114261389,1907,0,70177000);
insert into rawdatamachineprocess(uri,memoryused,percentcpu,id,utcdatetime,threads,openfiles,startedat) VALUES ('urn:desktop-ni28oib:system',0,0,'a785aa1b-4b7b-4513-a7b7-df0bb1fc46a6',1485114291963,1892,0,70208000);
insert into rawdatamachineprocess(uri,memoryused,percentcpu,id,utcdatetime,threads,openfiles,startedat) VALUES ('urn:desktop-ni28oib:WindowsService:postgresql-x64-9.6',0,0,'a2cfd307-2204-4eb3-a2eb-02f0fab4422d',1485114291963,0,0,0);
insert into rawdatamachineprocess(uri,memoryused,percentcpu,id,utcdatetime,threads,openfiles,startedat) VALUES ('urn:desktop-ni28oib:system',0,0,'4d4568af-82cc-4165-877b-b35700a79757',1485114322498,1917,0,70238000);
insert into rawdatamachineprocess(uri,memoryused,percentcpu,id,utcdatetime,threads,openfiles,startedat) VALUES ('urn:desktop-ni28oib:WindowsService:postgresql-x64-9.6',0,0,'61bd0f35-e295-45a3-9f70-deb01c8fbbce',1485114322498,0,0,0);
insert into rawdatamachineprocess(uri,memoryused,percentcpu,id,utcdatetime,threads,openfiles,startedat) VALUES ('urn:desktop-ni28oib:system',0,0,'87602417-edcc-4c89-a47c-331ca13720bf',1485114353021,1914,0,70269000);
insert into rawdatamachineprocess(uri,memoryused,percentcpu,id,utcdatetime,threads,openfiles,startedat) VALUES ('urn:desktop-ni28oib:WindowsService:postgresql-x64-9.6',0,0,'38c86652-2f44-4ca7-ae2b-e188e4a74728',1485114353021,0,0,0);
insert into rawdatamachineprocess(uri,memoryused,percentcpu,id,utcdatetime,threads,openfiles,startedat) VALUES ('urn:desktop-ni28oib:system',0,0,'35eb8cf0-74a3-46b6-8061-1e200ec0a65d',1485114788613,1925,0,70571000);
insert into rawdatamachineprocess(uri,memoryused,percentcpu,id,utcdatetime,threads,openfiles,startedat) VALUES ('urn:desktop-ni28oib:WindowsService:postgresql-x64-9.6',0,0,'f0faf095-407a-4b64-b238-4c46b17b8195',1485114788613,0,0,0);
insert into rawdatamachineprocess(uri,memoryused,percentcpu,id,utcdatetime,threads,openfiles,startedat) VALUES ('urn:desktop-ni28oib:system',0,0,'46bd9d4b-f7d0-45e5-be08-c0f1b5a45082',1485114790183,1893,0,70706000);
insert into rawdatamachineprocess(uri,memoryused,percentcpu,id,utcdatetime,threads,openfiles,startedat) VALUES ('urn:desktop-ni28oib:WindowsService:postgresql-x64-9.6',0,0,'e6ce61f3-7023-46ff-8e3e-e17ee29c7ed0',1485114790183,0,0,0);
insert into rawdatamachineprocess(uri,memoryused,percentcpu,id,utcdatetime,threads,openfiles,startedat) VALUES ('urn:desktop-ni28oib:system',0,0,'cb9d2703-eab9-4de1-8451-d5d7992d63be',1485114820985,1914,0,70737000);
insert into rawdatamachineprocess(uri,memoryused,percentcpu,id,utcdatetime,threads,openfiles,startedat) VALUES ('urn:desktop-ni28oib:WindowsService:postgresql-x64-9.6',0,0,'ec284e57-d3b3-4e4b-a5f0-59d92961f0c4',1485114820985,0,0,0);
insert into rawdatamachineprocess(uri,memoryused,percentcpu,id,utcdatetime,threads,openfiles,startedat) VALUES ('urn:desktop-ni28oib:system',0,0,'d6c16da0-8f95-4d38-a0b8-24201d517c5d',1485114851634,1900,0,70767000);
insert into rawdatamachineprocess(uri,memoryused,percentcpu,id,utcdatetime,threads,openfiles,startedat) VALUES ('urn:desktop-ni28oib:WindowsService:postgresql-x64-9.6',0,0,'f4fede71-1a89-4870-822c-bddc1de3a5fa',1485114851634,0,0,0);
insert into rawdatamachineprocess(uri,memoryused,percentcpu,id,utcdatetime,threads,openfiles,startedat) VALUES ('urn:desktop-ni28oib:system',0,0,'827cea13-b4b8-48e1-8463-f4a58dabfe70',1485114882310,1913,0,70798000);
insert into rawdatamachineprocess(uri,memoryused,percentcpu,id,utcdatetime,threads,openfiles,startedat) VALUES ('urn:desktop-ni28oib:WindowsService:postgresql-x64-9.6',0,0,'07486c12-4ffb-45fc-b8fb-99883112e295',1485114882310,0,0,0);
insert into rawdatamachineprocess(uri,memoryused,percentcpu,id,utcdatetime,threads,openfiles,startedat) VALUES ('urn:desktop-ni28oib:system',0,0,'6d491978-5272-4817-9351-2ba03032b369',1485114919312,1870,0,70829000);
insert into rawdatamachineprocess(uri,memoryused,percentcpu,id,utcdatetime,threads,openfiles,startedat) VALUES ('urn:desktop-ni28oib:WindowsService:postgresql-x64-9.6',0,0,'3659ef81-ef44-4bff-b8bb-404a00cf234c',1485114919312,0,0,0);
insert into rawdatamachineprocess(uri,memoryused,percentcpu,id,utcdatetime,threads,openfiles,startedat) VALUES ('urn:desktop-ni28oib:system',0,0,'285c9e6a-917e-4683-a9b7-9661172a0e7f',1485114959128,1845,0,70859000);
insert into rawdatamachineprocess(uri,memoryused,percentcpu,id,utcdatetime,threads,openfiles,startedat) VALUES ('urn:desktop-ni28oib:WindowsService:postgresql-x64-9.6',0,0,'23b669a5-408e-4f74-bc68-6da6f577171a',1485114959128,0,0,0);
insert into rawdatamachineprocess(uri,memoryused,percentcpu,id,utcdatetime,threads,openfiles,startedat) VALUES ('urn:desktop-ni28oib:system',0,0,'8146f872-3289-4a06-9985-99fbfd2f9c30',1485115007792,1796,0,70920000);
insert into rawdatamachineprocess(uri,memoryused,percentcpu,id,utcdatetime,threads,openfiles,startedat) VALUES ('urn:desktop-ni28oib:WindowsService:postgresql-x64-9.6',0,0,'d357c7cf-7568-4e96-b71b-6ad0a4d4304a',1485115007792,0,0,0);
insert into rawdatamachineprocess(uri,memoryused,percentcpu,id,utcdatetime,threads,openfiles,startedat) VALUES ('urn:desktop-ni28oib:system',0,0,'ae4458a0-b52c-43cd-8c89-7da81bcd17bb',1485115034296,1773,0,70950000);
insert into rawdatamachineprocess(uri,memoryused,percentcpu,id,utcdatetime,threads,openfiles,startedat) VALUES ('urn:desktop-ni28oib:WindowsService:postgresql-x64-9.6',0,0,'03052c68-d09b-4123-829b-fb3dd25c7068',1485115034296,0,0,0);
insert into rawdatamachineprocess(uri,memoryused,percentcpu,id,utcdatetime,threads,openfiles,startedat) VALUES ('urn:desktop-ni28oib:system',0,0,'ececde9e-3ba2-400b-9c74-a54dd3b24b98',1485115064734,1751,0,70981000);
insert into rawdatamachineprocess(uri,memoryused,percentcpu,id,utcdatetime,threads,openfiles,startedat) VALUES ('urn:desktop-ni28oib:WindowsService:postgresql-x64-9.6',0,0,'a6328496-4623-4db2-af29-d18129ff3b31',1485115064734,0,0,0);
insert into rawdatamachineprocess(uri,memoryused,percentcpu,id,utcdatetime,threads,openfiles,startedat) VALUES ('urn:desktop-ni28oib:system',0,0,'5b4de02c-0e31-446a-98a4-f574f732c2a9',1485115095181,1748,0,71011000);
=====================================================
== File: C:/projects/fgsms/fgsms-server/fgsms-database-export/pom.xml
=====================================================
<?xml version="1.0" encoding="UTF-8"?>
<!--
This Source Code Form is subject to the terms of the Mozilla Public
License, v. 2.0. If a copy of the MPL was not distributed with this
file, You can obtain one at http://mozilla.org/MPL/2.0/.
If it is not possible or desirable to put the notice in a particular
file, then You may include the notice in a location (such as a LICENSE
file in a relevant directory) where a recipient would be likely to look
for such a notice.
U.S. Government, Department of the Army
Army Materiel Command
Research Development Engineering Command
Communications Electronics Research Development and Engineering Center
-->
<project xmlns="http://maven.apache.org/POM/4.0.0" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xsi:schemaLocation="http://maven.apache.org/POM/4.0.0 http://maven.apache.org/maven-v4_0_0.xsd">
<modelVersion>4.0.0</modelVersion>
<parent>
<groupId>org.mil-oss</groupId>
<artifactId>fgsms-server</artifactId>
<version>7.0.0</version>
</parent>
<artifactId>fgsms-database-export</artifactId>
<packaging>bundle</packaging>
<name>fgsms Database Export Tool</name>
<description>A console tool to export the database content into sql scripts</description>
<dependencies>
<dependency>
<groupId>junit</groupId>
<artifactId>junit</artifactId>
<scope>test</scope>
</dependency>
<dependency>
<groupId>org.mil-oss</groupId>
<artifactId>fgsms-common</artifactId>
<version>${project.parent.version}</version>
</dependency>
<dependency>
<groupId>org.mil-oss</groupId>
<artifactId>fgsms-common-interfaces</artifactId>
<version>${project.parent.version}</version>
</dependency>
<dependency>
=====================================================
== File: C:/projects/fgsms/fgsms-server/fgsms-database-export/src/main/java/org/miloss/fgsms/tools/Column.java
=====================================================
/**
* This Source Code Form is subject to the terms of the Mozilla Public
* License, v. 2.0. If a copy of the MPL was not distributed with this
* file, You can obtain one at http://mozilla.org/MPL/2.0/.
*
* If it is not possible or desirable to put the notice in a particular
* file, then You may include the notice in a location (such as a LICENSE
* file in a relevant directory) where a recipient would be likely to look
* for such a notice.
*
*
*/
package org.miloss.fgsms.tools;
/**
*
* @author AO
*/
public class Column {
public String name;
public JDBCType type;
public boolean isFgsmsEncrypted=false;
}
=====================================================
== File: C:/projects/fgsms/fgsms-server/fgsms-database-export/src/main/java/org/miloss/fgsms/tools/DatabaseExport.java
=====================================================
/**
* This Source Code Form is subject to the terms of the Mozilla Public
* License, v. 2.0. If a copy of the MPL was not distributed with this
* file, You can obtain one at http://mozilla.org/MPL/2.0/.
*
* If it is not possible or desirable to put the notice in a particular
* file, then You may include the notice in a location (such as a LICENSE
* file in a relevant directory) where a recipient would be likely to look
* for such a notice.
*
*
*/
/* ---------------------------------------------------------------------------
* U.S. Government, Department of the Army
* Army Materiel Command
* Research Development Engineering Command
* Communications Electronics Research Development and Engineering Center
* ---------------------------------------------------------------------------
*/
package org.miloss.fgsms.tools;
import java.io.PrintWriter;
import java.sql.Connection;
import java.sql.Driver;
import java.sql.DriverManager;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
import java.util.ArrayList;
import java.util.List;
import org.apache.commons.cli.CommandLine;
import org.apache.commons.cli.CommandLineParser;
import org.apache.commons.cli.DefaultParser;
import org.apache.commons.cli.Options;
import org.miloss.fgsms.common.Constants;
import org.miloss.fgsms.common.Utility;
/**
* Exports the database AND decrypts all encryption database columns.
*
* If this isn't what you want, call pg_dump which comes with postgresql
*
* @author AO
*/
public class DatabaseExport {
public static void main(String[] args) throws Exception {
System.out.println("For best results, stop the FGSMS server(s)");
String database = "fgsms_performance";
String url = "jdbc:postgresql://localhost:5432/";
String username = "fgsms";
=====================================================
== File: C:/projects/fgsms/fgsms-server/fgsms-database-export/src/main/java/org/miloss/fgsms/tools/JDBCType.java
=====================================================
/**
* This Source Code Form is subject to the terms of the Mozilla Public
* License, v. 2.0. If a copy of the MPL was not distributed with this
* file, You can obtain one at http://mozilla.org/MPL/2.0/.
*
* If it is not possible or desirable to put the notice in a particular
* file, then You may include the notice in a location (such as a LICENSE
* file in a relevant directory) where a recipient would be likely to look
* for such a notice.
*
*
*/
package org.miloss.fgsms.tools;
public enum JDBCType {
BYTEA,INTEGER,BIGINT,VARCHAR,BOOLEAN,DOUBLE
}
=====================================================
== File: C:/projects/fgsms/fgsms-server/fgsms-database-export/src/main/java/org/miloss/fgsms/tools/Table.java
=====================================================
/**
* This Source Code Form is subject to the terms of the Mozilla Public
* License, v. 2.0. If a copy of the MPL was not distributed with this
* file, You can obtain one at http://mozilla.org/MPL/2.0/.
*
* If it is not possible or desirable to put the notice in a particular
* file, then You may include the notice in a location (such as a LICENSE
* file in a relevant directory) where a recipient would be likely to look
* for such a notice.
*
*
*/
package org.miloss.fgsms.tools;
import java.util.ArrayList;
import java.util.List;
/**
*
* @author AO
*/
public class Table {
public String name;
public List<Column> columns = new ArrayList<Column>();
}
=====================================================
== File: C:/projects/fgsms/fgsms-server/fgsms-database-export/src/main/resources/log4j.properties
=====================================================
log4j.rootLogger=INFO, CONSOLE
log4j.appender.jaxws.JAXWSWebServiceMetaDataBuilder=ERROR,CONSOLE
log4j.appender.jaxws=ERROR,CONSOLE
log4j.appender.org.jboss.ws.metadata=ERROR,CONSOLE
log4j.appender.org.jboss.ws.metadata.builder=ERROR,CONSOLE
log4j.appender.org.jboss.ws.metadata.builder.MetaDataBuilder=ERROR,CONSOLE
log4j.appender.builder.MetaDataBuilder=ERROR,CONSOLE
log4j.appender.builder=ERROR,CONSOLE
log4j.appender.org.apache.cxf.service.factory.ReflectionServiceFactoryBean=ERROR,CONSOLE
log4j.appender.handler.HandlerChainExecutor=ERROR,CONSOLE
log4j.appender.handler=ERROR,CONSOLE
log4j.appender.soap.MessageContextAssociation=ERROR,CONSOLE
log4j.appender.httpclient.wire.content=WARN, CONSOLE
log4j.appender.httpclient.wire=WARN, CONSOLE
log4j.appender.org.apache.commons.httpclient=WARN, CONSOLE
log4j.appender.httpclient.wire.content=WARN, CONSOLE
log4j.appender.httpclient.wire=WARN, CONSOLE
log4j.appender.org.apache.commons.httpclient=WARN, CONSOLE
log4j.appender.umdm.EndpointMetaData==ERROR, CONSOLE
log4j.appender.handler.HandlerResolverImpl==ERROR, CONSOLE
log4j.appender.binding.BindingImpl==ERROR, CONSOLE
log4j.appender.jaxws.JAXWSWebServiceMetaDataBuilder==ERROR, CONSOLE
log4j.appender.utils.JBossWSEntityResolver==ERROR, CONSOLE
log4j.appender.fgsms.ServiceMixJMX=INFO,CONSOLE
log4j.appender.fgsms.Utility=INFO,CONSOLE
log4j.appender.fgsms.StatusBueller=INFO,CONSOLE
log4j.appender.fgsms.DataCollectorService=INFO,CONSOLE
log4j.appender.fgsms.DataAccessService=INFO,CONSOLE
log4j.appender.org.miloss.fgsms.common.AuditLogger=INFO,CONSOLE
log4j.appender.fgsms.UserIdentityUtil=INFO,CONSOLE
log4j.appender.fgsms.StatusBueller=INFO,CONSOLE
log4j.appender.fgsms.QpidPython=INFO,CONSOLE
log4j.appender.fgsms.QpidJMX=INFO,CONSOLE
log4j.appender.fgsms.DataPruner=INFO,CONSOLE
log4j.appender.fgsms.UDDIPublisher=INFO,CONSOLE
log4j.appender.fgsms.MulticastAlerting=INFO,CONSOLE
log4j.appender.fgsms.SLAProcessor=INFO,CONSOLE
#the following items are used for sending SLA Alerts to specific loggers. Configure them as necessary to pipe log output whereever you need it
log4j.appender.fgsms.SLAProcessor.SysLog=INFO,CONSOLE
log4j.appender.fgsms.SLAProcessor.UdpLog=INFO,CONSOLE
log4j.appender.fgsms.SLAProcessor.EventLog=INFO,CONSOLE
=====================================================
== File: C:/projects/fgsms/fgsms-server/fgsms-database-export/src/main/resources/log4j.xml
=====================================================
<?xml version="1.0" encoding="UTF-8"?>
<!--
Document : log4j.xml
Created on : October 18, 2011, 6:57 PM
Author : Administrator
Description:
Purpose of the document follows.
-->
<!DOCTYPE log4j:configuration SYSTEM "log4j.dtd">
<log4j:configuration xmlns:log4j="http://jakarta.apache.org/log4j/"
debug="false">
<appender name="CONSOLE" class="org.apache.log4j.ConsoleAppender">
<layout class="org.apache.log4j.PatternLayout">
<param name="ConversionPattern" value="[%d{dd/MM/yy hh:mm:ss:sss z}] %5p %c{2}: %m%n" />
</layout>
</appender>
<appender name="FILE" class="org.apache.log4j.RollingFileAppender">
<param name="File" value="${jboss.server.home.dir}/log/application.log" />
<param name="MaxFileSize" value="1MB" />
<param name="MaxBackupIndex" value="100" />
<layout class="org.apache.log4j.PatternLayout">
<param name="ConversionPattern" value="[%d{dd/MM/yy hh:mm:ss:sss z}] %5p %c{2}: %m%n" />
</layout>
</appender>
<root>
<priority value="info" />
<appender-ref ref="CONSOLE" />
<appender-ref ref="FILE" />
</root>
</log4j:configuration>