/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 608 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
3rd 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.

Don't be a Stranger!

Sign up today to participate, stay informed, earn points and establish a reputation for yourself!

Sign up! or login

Share

 
This website uses cookies. By continuing to use this site and/or clicking the "Accept" button you are providing consent Quest Software and its affiliates do NOT sell the Personal Data you provide to us either when you register on our websites or when you do business with us. For more information about our Privacy Policy and our data protection efforts, please visit GDPR-HQ