win2016 information

http://shaurong.blogspot.tw/2016/10/windows-server-2016-standard-retailkms.html

http://notes.isaackuo.idv.tw/2013/12/windows-server.html

movie maker

https://www.topwin-movie-maker.com/tw-hk/

This quiz is to help members learn about confluence, and I also wish when members have confluence question, they can discuss with me more.

microsoft

https://docs.microsoft.com/zh-tw/windows-server/get-started/system-requirements

confluence login

List of Users who Logged in Successfully to Confluence after 19th January 2017

SELECT u.user_name, d.directory_name, l.successdate
FROM logininfo l
JOIN user_mapping m ON m.user_key = l.username
JOIN cwd_user u ON m.username = u.user_name
JOIN cwd_directory d ON u.directory_id = d.id
WHERE successdate > '2017-01-19'
ORDER BY successdate;

 

  Total Number of Users who Logged in Successfully to Confluence after 19th January 2017
 

 
  
SELECT COUNT(u.user_name)
FROM logininfo l
JOIN user_mapping m ON m.user_key = l.username
JOIN cwd_user u ON m.username = u.user_name
JOIN cwd_directory d ON u.directory_id = d.id
WHERE successdate > '2017-01-19'