/build/static/layout/Breadcrumb_cap_w.png

Systems Management Question


Report list all PC's that a specific software is not installed on them

01/09/2020 283 views

Hi,


I have tried many SQL to run the report but I got wrong results. Can anyone help with report that list all PC's that a specific software is not installed on them, please?  

0 Comments   [ + ] Show comments

Comments


All Answers

0

Hi Ghamdifast,

there is no need to create a custom SQL report. You can easily filter your device inventory like this:

i086P8HSQFMAAAAAAAUHR5ppgFMJ2WWhcZCkIBDAAAAAAAFF2eUQCPhB5GCENBKIABAAAAAICiyzMK4BFQqtS6rlcMRTIsBfDOnTsBAAAAAACWJc8ogAurZU3dntb+hWIYlgJYRERERERERERERESkiFEAA0NFASwiIiIiIiIiIiIiIrL8KICBoaIAFhERERERERERERERWX4UwMBQUQCLiIiIiIiIiIiIiIgsPwpgYKgogEVERERERERERERERJYfBTAwVBTAIiIiIiIiIiIiIiIiy48CGBgqCmAREREREREREREREZHlRwEMDBUFsIiIiIiIiIiIiIiIyPKjAAaGigJYRERERERERERERERk+VEAA0NFASwiIiIiIiIiIiIiIrL8KICBoaIAFhERERERERERERERWX7+Pw0ejgMZEFtSAAAAAElFTkSuQmCC


From here you can then clock on "Choose Action" and either export the results in the needed format or create a report out of this filter.

Gdyom+LkY8QI6dhYOQjxMhpGBj5CDFyGgZGTiQcIycSjpETCcfIiYRj5ETCMXIi4Rg5kXC3Tk5OGDmRYP8H7J639HHacSsAAAAASUVORK5CYII=


Kind Regards

Timo

Answered 01/09/2020 by: Timokirch
2nd Degree Black Belt

  • Thank you so much. I'm using this everyday but I need to think more ;-)
  • When I tried to export the search to excel file, I got an error page.
    "Oops! Something went wrong.
    What happened:
    The KACE Systems Management Appliance has encountered an unhandled error. (more info)"

    Any suggestions?
    • Does the error message look like this: "PHP Error: Uncaught Unhandled Exception in /kbox/kboxwww/adminui/computer_inventory.php on line 913: mysqli error: [1054: Unknown column 'timestampdiff(SECOND, MACHINE.LAST_INVENTORY, now())' "

      I had the same problem. The cause was that I my order was on the column "Last Inventory". Try so sort your devices after their name oder something and not Last Inventory, Connection or anything like these.