system

http://blog.xuite.net/ronan863/blog/124389029-WIN7%E7%A7%BB%E9%99%A4%E5%85%B1%E7%94%A8%E5%BE%8C%E8%B3%87%E6%96%99%E5%A4%BE%E5%87%BA%E7%8F%BE%E5%B0%8F%E9%8E%96%E9%A0%AD%E7%AC%A6%E8%99%9F

http://www.itprotoday.com/management-mobility/disabling-logging-anonymous-logon-events

page view macro sql

SELECT TAB2.pageid, TAB1.title ,TAB3.spacename
FROM content TAB1,
(SELECT pageid FROM content
WHERE pageid IN (select cast(right(bandanacontext,8) as integer) as contentcode from public.Bandana where  bandanacontext like 'net.kentcom.PageViewTracker.Daily.%' and LEFT(bandanakey,4) || '/' || SUBSTRING(bandanakey,5,2) || '/' || RIGHT(bandanakey,2) between '2018/01/01' and '2018/01/24') and pageid is not null) TAB2,spaces TAB3 
WHERE TAB2.pageid =  TAB1.contentid and TAB1.spaceid = TAB3.spaceid

confluence log7

<Valve className="org.apache.catalina.valves.AccessLogValve" directory="logs" prefix="conf_access_log" suffix=".log" pattern="%t %{X-AUSERNAME}o %{User-Agent}i %h %m %r %b %s %I" />



https://confluence.atlassian.com/doc/working-with-confluence-logs-108364721.html#WorkingwithConfluenceLogs-runtime

https://confluence.atlassian.com/doc/working-with-confluence-logs-108364721.html

https://confluence.atlassian.com/doc/enabling-detailed-sql-logging-179030.html

https://confluence.atlassian.com/doc/configuring-logging-181535215.html

https://confluence.atlassian.com/confkb/how-to-enable-user-access-logging-182943.html

https://confluence.atlassian.com/confkb/audit-confluence-using-the-tomcat-valve-component-223216846.html

excel共用

https://support.office.com/zh-tw/article/%E5%8D%94%E5%8A%A9%E4%BF%9D%E8%AD%B7%E6%82%A8%E7%9A%84%E9%9A%B1%E7%A7%81%E6%AC%8A-252a47ec-1b31-4fd0-8450-e66d6c2de950

https://support.office.com/zh-tw/article/%E9%97%9C%E6%96%BC%E5%85%B1%E7%94%A8%E6%B4%BB%E9%A0%81%E7%B0%BF%E5%8A%9F%E8%83%BD-49b833c0-873b-48d8-8bf2-c1c59a628534

log2

-- Table: public.log2

-- DROP TABLE public.log2;

CREATE TABLE public.log2
(
    d1 character varying(255) COLLATE pg_catalog."default",
    d2 character varying(255) COLLATE pg_catalog."default",
    d3 text COLLATE pg_catalog."default",
    id integer NOT NULL DEFAULT nextval('testincrement'::regclass)
)
WITH (
    OIDS = FALSE
)
TABLESPACE pg_default;

ALTER TABLE public.log2
    OWNER to confluence_user;

https://marketplace.atlassian.com/plugins/com.nolddor.announcement-banner/server/overview

https://marketplace.atlassian.com/plugins/de.communardo.confluence.plugins.subspace/cloud/support