[root@emitestbed44 ~]# rpm -qa |grep wms-ice glite-wms-ice-3.5.2-1.sl6.x86_64 [root@emitestbed44 ~]# sqlite3 /var/ice/persist_dir/ice.db "select * from registered_jobs"|head -10 1385386018|https://cream-22.pd.infn.it:8443/ce-cream/services/CREAM2|https://emitestbed44.cnaf.infn.it:9000/xYw1-XA2SyH4_QzdAtpq8Q|CREAM338382500 1385386100|https://cert-34.pd.infn.it:8443/ce-cream/services/CREAM2|https://emitestbed44.cnaf.infn.it:9000/GHk4WMHvpqvkqGdhqnEhLg|CREAM331043588 1385386199|https://cream-22.pd.infn.it:8443/ce-cream/services/CREAM2|https://emitestbed44.cnaf.infn.it:9000/U34pEMesHxh9GpcLXMc7Mg|CREAM309159863 1385386201|https://cream-23.pd.infn.it:8443/ce-cream/services/CREAM2|https://emitestbed44.cnaf.infn.it:9000/R0ITU8KTaPArYcJpqgiOOA|CREAM880286424 1385386202|https://cert-34.pd.infn.it:8443/ce-cream/services/CREAM2|https://emitestbed44.cnaf.infn.it:9000/6FFI9sT_Uhwv4zy2UjnBfg|CREAM718520612 1385386756|https://emi-demo13.cnaf.infn.it:8443/ce-cream/services/CREAM2|https://emitestbed44.cnaf.infn.it:9000/Xfl08lKtZpmq0LUC54BfWA|CREAM723549821 1385389528|https://emi-demo13.cnaf.infn.it:8443/ce-cream/services/CREAM2|https://emitestbed44.cnaf.infn.it:9000/X_4kN7w4LDbcqJHSGb96lw|CREAM555641037 1385389635|https://emi-demo13.cnaf.infn.it:8443/ce-cream/services/CREAM2|https://emitestbed44.cnaf.infn.it:9000/k8qiT2O_6oKfimgk-lt1DQ|CREAM405564918 1385391062|https://emi-demo13.cnaf.infn.it:8443/ce-cream/services/CREAM2|https://emitestbed44.cnaf.infn.it:9000/tmVU7iS54Vrpi4VpFMeG-g|CREAM888251674 1385393742|https://emi-demo13.cnaf.infn.it:8443/ce-cream/services/CREAM2|https://emitestbed44.cnaf.infn.it:9000/5MECwk4qDFLKUO2ZtmO9aQ|CREAM456084351 You have new mail in /var/spool/mail/root [root@emitestbed44 ~]# [root@emitestbed44 ~]# [root@emitestbed44 ~]# queryRegisteredJobs 1385386000 1385393742 GridJobID=https://emitestbed44.cnaf.infn.it:9000/xYw1-XA2SyH4_QzdAtpq8Q - Timestamp=1385386018 - CreamJobID=https://cream-22.pd.infn.it:8443/ce-cream/services/CREAM2/CREAM338382500 GridJobID=https://emitestbed44.cnaf.infn.it:9000/GHk4WMHvpqvkqGdhqnEhLg - Timestamp=1385386100 - CreamJobID=https://cert-34.pd.infn.it:8443/ce-cream/services/CREAM2/CREAM331043588 GridJobID=https://emitestbed44.cnaf.infn.it:9000/U34pEMesHxh9GpcLXMc7Mg - Timestamp=1385386199 - CreamJobID=https://cream-22.pd.infn.it:8443/ce-cream/services/CREAM2/CREAM309159863 GridJobID=https://emitestbed44.cnaf.infn.it:9000/R0ITU8KTaPArYcJpqgiOOA - Timestamp=1385386201 - CreamJobID=https://cream-23.pd.infn.it:8443/ce-cream/services/CREAM2/CREAM880286424 GridJobID=https://emitestbed44.cnaf.infn.it:9000/6FFI9sT_Uhwv4zy2UjnBfg - Timestamp=1385386202 - CreamJobID=https://cert-34.pd.infn.it:8443/ce-cream/services/CREAM2/CREAM718520612 GridJobID=https://emitestbed44.cnaf.infn.it:9000/Xfl08lKtZpmq0LUC54BfWA - Timestamp=1385386756 - CreamJobID=https://emi-demo13.cnaf.infn.it:8443/ce-cream/services/CREAM2/CREAM723549821 GridJobID=https://emitestbed44.cnaf.infn.it:9000/X_4kN7w4LDbcqJHSGb96lw - Timestamp=1385389528 - CreamJobID=https://emi-demo13.cnaf.infn.it:8443/ce-cream/services/CREAM2/CREAM555641037 GridJobID=https://emitestbed44.cnaf.infn.it:9000/k8qiT2O_6oKfimgk-lt1DQ - Timestamp=1385389635 - CreamJobID=https://emi-demo13.cnaf.infn.it:8443/ce-cream/services/CREAM2/CREAM405564918 GridJobID=https://emitestbed44.cnaf.infn.it:9000/tmVU7iS54Vrpi4VpFMeG-g - Timestamp=1385391062 - CreamJobID=https://emi-demo13.cnaf.infn.it:8443/ce-cream/services/CREAM2/CREAM888251674 GridJobID=https://emitestbed44.cnaf.infn.it:9000/5MECwk4qDFLKUO2ZtmO9aQ - Timestamp=1385393742 - CreamJobID=https://emi-demo13.cnaf.infn.it:8443/ce-cream/services/CREAM2/CREAM456084351 [root@emitestbed44 ~]# date -d @1385386000 +%c Mon 25 Nov 2013 02:26:40 PM CET [root@emitestbed44 ~]# date -d @1385393742 +%c Mon 25 Nov 2013 04:35:42 PM CET [root@emitestbed44 ~]# sqlite3 /var/ice/persist_dir/ice.db "select * from registered_jobs"|tail -10 1385636317|https://emi-demo13.cnaf.infn.it:8443/ce-cream/services/CREAM2|https://emitestbed44.cnaf.infn.it:9000/67KLuVCypjmXdIBnZiZ2LQ|CREAM296422896 1385636318|https://emitestbed49.cnaf.infn.it:8443/ce-cream/services/CREAM2|https://emitestbed44.cnaf.infn.it:9000/pnrRVQiuzH6q4y3pTa80Bg|CREAM060426278 1385636319|https://emitestbed49.cnaf.infn.it:8443/ce-cream/services/CREAM2|https://emitestbed44.cnaf.infn.it:9000/pnL7RaJ1kY_DRBccDKlg6w|CREAM390340627 1385636319|https://emi-demo13.cnaf.infn.it:8443/ce-cream/services/CREAM2|https://emitestbed44.cnaf.infn.it:9000/ARdj_nhSXaFJ1-huMOesDA|CREAM785167539 1385636320|https://emi-demo13.cnaf.infn.it:8443/ce-cream/services/CREAM2|https://emitestbed44.cnaf.infn.it:9000/ASh9FcxPWigIoMCIFlYtRw|CREAM443818119 1385636321|https://emitestbed49.cnaf.infn.it:8443/ce-cream/services/CREAM2|https://emitestbed44.cnaf.infn.it:9000/Y7O5d2W9QfqyNRlX5j3r3A|CREAM339178501 1385636322|https://emitestbed49.cnaf.infn.it:8443/ce-cream/services/CREAM2|https://emitestbed44.cnaf.infn.it:9000/5s2HC9w2E8t-4SHirNvUgQ|CREAM808713047 1385636324|https://emitestbed49.cnaf.infn.it:8443/ce-cream/services/CREAM2|https://emitestbed44.cnaf.infn.it:9000/Uh_HftNJtBkOQg4XR1mewQ|CREAM524572299 1385636325|https://emitestbed49.cnaf.infn.it:8443/ce-cream/services/CREAM2|https://emitestbed44.cnaf.infn.it:9000/7mf73wuCGa8cswylasfkWw|CREAM543992053 1385636327|https://emitestbed49.cnaf.infn.it:8443/ce-cream/services/CREAM2|https://emitestbed44.cnaf.infn.it:9000/NQCb28Cq3YvCa1LPlHtvGg|CREAM346226932 [root@emitestbed44 ~]# queryRegisteredJobs `date -d "2013-11-26" "+%s"` `date -d "2013-11-27" "+%s"` GridJobID=https://emitestbed44.cnaf.infn.it:9000/ZMBBM5k64jwVCgE7SlFAIw - Timestamp=1385456429 - CreamJobID=https://cream-23.pd.infn.it:8443/ce-cream/services/CREAM2/CREAM159931018 GridJobID=https://emitestbed44.cnaf.infn.it:9000/VdFpn3-s8bNNOEnF0Hqtig - Timestamp=1385460112 - CreamJobID=https://cream-23.pd.infn.it:8443/ce-cream/services/CREAM2/CREAM857702103 GridJobID=https://emitestbed44.cnaf.infn.it:9000/zLNkdXaXP0Wd7C2wvgm60w - Timestamp=1385460114 - CreamJobID=https://cert-34.pd.infn.it:8443/ce-cream/services/CREAM2/CREAM261033754 GridJobID=https://emitestbed44.cnaf.infn.it:9000/bImF-nwSt7aSaJetf743aQ - Timestamp=1385460114 - CreamJobID=https://cert-34.pd.infn.it:8443/ce-cream/services/CREAM2/CREAM247462902 GridJobID=https://emitestbed44.cnaf.infn.it:9000/OVEsCqK0l-3UUByRXVaZ6g - Timestamp=1385463797 - CreamJobID=https://cream-23.pd.infn.it:8443/ce-cream/services/CREAM2/CREAM468802575 GridJobID=https://emitestbed44.cnaf.infn.it:9000/mze9udXz3E8NQoTpP5Ctgg - Timestamp=1385463800 - CreamJobID=https://cream-23.pd.infn.it:8443/ce-cream/services/CREAM2/CREAM595026211 GridJobID=https://emitestbed44.cnaf.infn.it:9000/vTpZCtH95zQI-5hdtfK0CA - Timestamp=1385463800 - CreamJobID=https://cert-34.pd.infn.it:8443/ce-cream/services/CREAM2/CREAM850949336 GridJobID=https://emitestbed44.cnaf.infn.it:9000/Ug7gl4Kb30Qixalxk8vFsQ - Timestamp=1385463801 - CreamJobID=https://cert-34.pd.infn.it:8443/ce-cream/services/CREAM2/CREAM799723773 GridJobID=https://emitestbed44.cnaf.infn.it:9000/cG92W83brJxaJNI_YNAciw - Timestamp=1385463801 - CreamJobID=https://cert-34.pd.infn.it:8443/ce-cream/services/CREAM2/CREAM740536165 GridJobID=https://emitestbed44.cnaf.infn.it:9000/89umaJQvyq_eSuxxheNYTA - Timestamp=1385465687 - CreamJobID=https://cream-23.pd.infn.it:8443/ce-cream/services/CREAM2/CREAM604409111 GridJobID=https://emitestbed44.cnaf.infn.it:9000/ki-9uA4M_D8B7b0ZKhx2ug - Timestamp=1385465801 - CreamJobID=https://cream-22.pd.infn.it:8443/ce-cream/services/CREAM2/CREAM854766780 GridJobID=https://emitestbed44.cnaf.infn.it:9000/TP-XRCZ7PxbSZoBE9olrNQ - Timestamp=1385469486 - CreamJobID=https://cream-22.pd.infn.it:8443/ce-cream/services/CREAM2/CREAM871582080 GridJobID=https://emitestbed44.cnaf.infn.it:9000/rsEOXQz-dzkA51Aoo6rLYA - Timestamp=1385469486 - CreamJobID=https://cream-22.pd.infn.it:8443/ce-cream/services/CREAM2/CREAM549444492 GridJobID=https://emitestbed44.cnaf.infn.it:9000/rD-ES-dZMmNbU5fKrJ3t2Q - Timestamp=1385469486 - CreamJobID=https://cream-22.pd.infn.it:8443/ce-cream/services/CREAM2/CREAM114826414 GridJobID=https://emitestbed44.cnaf.infn.it:9000/a8VDkLXDNgDxHjmy0UMvJg - Timestamp=1385473169 - CreamJobID=https://cream-22.pd.infn.it:8443/ce-cream/services/CREAM2/CREAM965723234 GridJobID=https://emitestbed44.cnaf.infn.it:9000/1q9LiKiW_qkv8zU38Vg1xA - Timestamp=1385473173 - CreamJobID=https://cream-22.pd.infn.it:8443/ce-cream/services/CREAM2/CREAM869814337 GridJobID=https://emitestbed44.cnaf.infn.it:9000/clho3qZvins7PPWJ5TWATQ - Timestamp=1385473173 - CreamJobID=https://emi-demo13.cnaf.infn.it:8443/ce-cream/services/CREAM2/CREAM393101036 GridJobID=https://emitestbed44.cnaf.infn.it:9000/wzv8zi__gNXfBWI5Lvod6w - Timestamp=1385473175 - CreamJobID=https://cream-22.pd.infn.it:8443/ce-cream/services/CREAM2/CREAM005575665 GridJobID=https://emitestbed44.cnaf.infn.it:9000/a05b-XIHhFrEUQmH02wx5g - Timestamp=1385473175 - CreamJobID=https://cert-34.pd.infn.it:8443/ce-cream/services/CREAM2/CREAM033135544 GridJobID=https://emitestbed44.cnaf.infn.it:9000/NhoLxP3i7j5GjZLBA8BmFQ - Timestamp=1385476856 - CreamJobID=https://cream-22.pd.infn.it:8443/ce-cream/services/CREAM2/CREAM898831434