Lansweeper Cloud Software Not Installed Report

[lwhofmann]

I currently have multiple reports in Classic that I use to show specific software packages that not installed, for example, All Computers Missing Rapid 7 Insight Agent. I am trying to recreate those reports in Lansweeper Cloud (Sites?) so that I can retrieve the results of the reports via API rather than having to manually export the reports every time I need the data. Can anyone out here help me with getting a report going? I have spent around 8-10 hours working on this with no valid results.

Thank you in advance!

[Jacob_H]

Hey Iwho:  this should work:  Let me know if it doesn't  -  

{
  "$match": {
    "Last Seen": {
      "$gte": "$$$(dateFN(-30,d))"
    }
  }
}

[lwhofmann]

Please see my previous response...it did not work.

Any additional assistance that you can provide is appreciated.

Thank you

[lwhofmann]

@Jacob_H Thank you for the reply, however, when I paste in the code that you supplied, I receive the following error:

"You cannot save changes made in this report because one or more steps contain errors.

Please fix them first before saving any changes."

Just to be clear, I deleted all of the code that was in the filter window and replaced it with the code that you provided. If I did something improperly, please let me know, otherwise, I am still needing assistance with getting this to work.

Thank you

[TravisFarrell]

@lwhofmann Did you have any luck with moving the "All Computers Missing Rapid7 Insight Agent" to Lansweeper Cloud?  Do you mind sharing the code?

[lwhofmann]

@TravisFarrell I have the report working, except for the piece specific to the "rolling" 31 days ago bit. I haven't had any time to dedicate to it, so for now, I am able to manually update the date, but I really need to get it to be dynamic. If you are needing the code for the report, I will gladly share it, but the date portion is manual for now.

[lwhofmann]

Thanks @DavidPK. I have watched that video a couple of times, and it helps some, but hasn't quite gotten me "across the finish line".

I have successfully created the report that I am wanting, with one exception...I am trying to filter out any assets that were last seen over 31 days ago. I can do it for a specific date, but I want it to "roll" based on the day that the report is run/viewed. So, at this point I am looking for some help with the custom filter that I would need to write.

The code for the "default" filter that I have working is:

{
  "$or": [
    {
      "Last Seen": {
        "$gtDate": "2024-12-29"
      }
    }
  ]
}

and I could really use some assistance getting it to be dynamic. ChatGPT has suggested that I use the following:

{
  "$match": {
    "Last Seen": {
      "$gte": {
        "$dateSubtract": {
          "startDate": "$$NOW",
          "unit": "day",
          "amount": 31
        }
      },
      "$lte": "$$NOW"
    }
  }
}

and I cannot save it because I get the following error: "One or more steps in the report contains errors. Please fix them before saving changes."

Thank you

[lwhofmann]

@DavidPK Any thoughts on how I can get this working after trying to use ChatGPT to provide an answer that got me close, but not quite there?

[DavidPK]

Hi 

Here is some information that could help you achieve your goal. 

https://community.lansweeper.com/t5/pro-tips/pro-tips-40-chatgpt-amp-advanced-reporting-in-cloud/ba-...