Hi,
I used an IDE that was already installed on the server by a previous developer - Robo 3t (it appears this has now been superseded by Studio 3T from the popup on open) with an already created connection to localhost:27017. the database for us was called qlikalerting and within that were 34 collections.
I've subsequently set up a scheduled task to execute the following .js file daily to delete anything over 7 days:
use qlikalerting;
db.currentOp();
db.getCollection('datahistory').deleteMany({timestamp:{$lt:new Date()-(1000*60*60*24*7)}});
db.getCollection('datahistorypositivevalues').aggregate([{
"$lookup": {
"from":"datahistory",
"localField": "scanId",
"foreignField":"scanId",
"as":"scanCheck"}
}, {
"$match":{
"scanCheck":{
"$size":0
}
}
}]).forEach((doc) => {
db.getCollection("datahistorypositivevalues").remove({ "_id": doc._id });
});
db.getCollection('datahistorynegativevalues').aggregate([{
"$lookup": {
"from":"datahistory",
"localField": "scanId",
"foreignField":"scanId",
"as":"scanCheck"}
}, {
"$match":{
"scanCheck":{
"$size":0
}
}
}]).forEach((doc) => {
db.getCollection("datahistorynegativevalues").remove({ "_id": doc._id });
});
executed via a .bat file.
It seems to work for us, no idea if its breaking something else but as it was essentially unusable beforehand I didn't see much risk. Obviously treat with caution, make sure you understand what its doing, be ready to roll back to a backup etc. etc.
good luck!
