Determine the amount of data for a first level project Down
Use z. B when measuring "home directories"
MATCH (n: Project) - [: rel_child_ini] -> (v) - [: rel_child0] -> (u) where id (n) = 5006787 with u match (u) - [: rel_child0 * 0 ..] -> (x) RETURN distinct u.sourcepath, sum (toInteger (x.filecount)) as filecount, sum (toInteger (x.foldersize)) as quantity order by quantity desc
u.sourcepath | filecount | Quantity in bytes |
\\ ebner.cc \ data \ home folders \ red | 27616 | 2,90775E + 11 |
\\ ebner.cc \ data \ home folders \ kef | 259 | 2,90025E + 11 |
\\ ebner.cc \ data \ home folders \ spen | 18468 | 95732667873 |
\\ ebner.cc \ data \ home folders \ bih | 71760 | 76801631519 |
\\ ebner.cc \ data \ home folders \ cal | 10621 | 73212395625 |
\\ ebner.cc \ data \ home folders \ stoc | 70091 | 72358766675 |
\\ ebner.cc \ data \ home folders \ fl | 58984 | 70173335415 |