Thomas,
Thank you for this quick answer.
I'm out of office next week; I'll try as soon as I'm back.
[cid:image003.jpg@01D35A47.AC488CD0]
Olivier HERTRICH
EXPERT ITS
DIRECTION OPÉRATIONS TECHNOLOGIES / INTEGRATION CENTER
DIRECTION DES SYSTÈMES D'INFORMATION
T +33 562417338
M +33 608020775
o.hertr...@daher.com<mailto:o.hertr...@daher.com>
TARBES - FRANCE
www.daher.com<http://www.daher.com> - www.tbm.aero<http://www.tbm.aero>
De : LEIBOVICI Thomas [mailto:thomas.leibov...@cea.fr]
Envoyé : vendredi 10 novembre 2017 14:17
À : HERTRICH Olivier <o.hertr...@daher.com>; robinhood-supp...@lists.sf.net
Objet : Re: [robinhood-support] Fileclass with time criteria
Hi,
Fileclass are expected to be quite static, while time conditions may change
every second...
I know the kind of report you mention has already been done with robinhood
For example the "filesystem temprature" graph shown in this presentation slide
14, is based on such report:
https://www.eofs.eu/_media/events/lad13/04_kilian_cavalotti_lustre.usage.monitoring.pdf
It shows the "modification age" and the "access age" of the data.
This is the request to build such graph for access times. Just replace
'last_access' with 'last_mod' to get the same for last modification time :
SET SESSION TRANSACTION ISOLATION LEVEL READ UNCOMMITTED; START TRANSACTION;
SELECT age, SUM(c) AS cnt, SUM(v) AS vol FROM ( SELECT c, v, CASE
WHEN log_age < ROUND(LOG(10,900),5) THEN 'r_0'
WHEN log_age < ROUND(LOG(10,3600),5) THEN 'r_1'
WHEN log_age < ROUND(LOG(10,21600),5) THEN 'r_2'
WHEN log_age < ROUND(LOG(10,86400),5) THEN 'r_3'
WHEN log_age < ROUND(LOG(10,604800),5) THEN 'r_4'
WHEN log_age < ROUND(LOG(10,2592000),5) THEN 'r_5'
WHEN log_age < ROUND(LOG(10,5184000),5) THEN 'r_6'
WHEN log_age < ROUND(LOG(10,7776000),5) THEN 'r_7'
ELSE 'r_8' END AS age FROM ( SELECT
IF(UNIX_TIMESTAMP(NOW())>=last_access,ROUND(LOG(10,UNIX_TIMESTAMP(NOW())-last_access),5),NULL)
AS log_age, COUNT(*) AS c, IFNULL(SUM(size),0) AS v FROM ENTRIES GROUP BY
log_age ) AS ps ) AS stats GROUP BY age; COMMIT;
For duplicate name-size couples, a crafty sql request should do it...
You can first create a temporary table with id, size and name:
CREATE TABLE FIND_DUP AS (SELECT E.id, E.size, N.parent_id, N.name,
this_path(N.parent_id, N.name) as path from ENTRIES E,NAMES N WHERE E.id=N.id
and E.type='file');
Then you can list name-size duplicates using:
SELECT A.path, B.path, A.size FROM FIND_DUP A, FIND_DUP B WHERE A.size=B.size
and A.name=B.name and A.id <> B.id;
HTH
Thomas
On 11/09/17 19:28, HERTRICH Olivier wrote:
Discovering Robinhood, I search to have a report based last_access time to
identify the size of data older than some dates.
It seems that time criteria are not allowed in Fileclass definition.
How can I have this reports?
I also search to find duplicate files (same name/ same size, for now). IS this
possible ?
Thank you for your help.
[cid:image002.jpg@01D35A47.AC3AAA20]
Olivier HERTRICH
EXPERT ITS
DIRECTION OPÉRATIONS TECHNOLOGIES / INTEGRATION CENTER
DIRECTION DES SYSTÈMES D'INFORMATION
T +33 562417338
M +33 608020775
o.hertr...@daher.com<mailto:o.hertr...@daher.com>
TARBES - FRANCE
www.daher.com<http://www.daher.com> - www.tbm.aero<http://www.tbm.aero>
This e-mail and any files transmitted with it (the «message ») are confidential
and intended solely for the use of the addressees. If you receive this message
in error, please delete it and immediately notify the sender. Any use not in
accord with its purpose, any dissemination or disclosure, either whole or
partial, is strictly prohibited except formal approval. Any views or opinions
presented are solely those of its author and do not necessarily represent those
of Daher or any of its subsidiary companies. The internet cannot guarantee the
integrity of this message. Neither Daher nor any of its subsidiaries or
affiliates shall be liable for the message if altered, changed or falsified.
While we take all reasonable precautions to ensure that viruses are not
transmitted via emails, we recommend that you take your own measures to prevent
viruses from entering your computer system.
------------------------------------------------------------------------------
Check out the vibrant tech community on one of the world's most
engaging tech sites, Slashdot.org! http://sdm.link/slashdot
_______________________________________________
robinhood-support mailing list
robinhood-support@lists.sourceforge.net<mailto:robinhood-support@lists.sourceforge.net>
https://lists.sourceforge.net/lists/listinfo/robinhood-support
------------------------------------------------------------------------------
Check out the vibrant tech community on one of the world's most
engaging tech sites, Slashdot.org! http://sdm.link/slashdot
_______________________________________________
robinhood-support mailing list
robinhood-support@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/robinhood-support
