/build/static/layout/Breadcrumb_cap_w.png

KACE Product Support Question


software list

03/29/2017 582 views
how do I get a report that list all software installed on a site, we have 3 locations and I want to see all softwares installed on users PCS from that location.

thanks

3 Comments   [ + ] Show comments

Comments

  • Do you know the ASSET_TYPE_ID for Location? I think it's 1 by default but I could be wrong.
  • no I dont, where to find it?
  • How do you identify site? By Label, Location, etc.?

All Answers

0
what the name of the tool from quest that need to download?
Answered 04/12/2017 by: kace1000-2015
Senior Yellow Belt

  • Download MySQL Workbench: https://dev.mysql.com/downloads/workbench/5.2.html
    Link the program to your KACE db: https://support.quest.com/kb/114992
    • that quest link ask for asset tag or support contract to see the article
      • get your service tag: log in, click the question mark in upper right, click "About K1000," check "Serial Number"
      • Expired Maintenance
0
If Location is an asset type, it'll be located in Assets > Asset Types. If you hover over "Location" you can see the ID# at the end of the URL:

Answered 03/30/2017 by: JasonEgg
Red Belt

  • This assumes you're using Location asset to assign location, you may be using another method
0
Asset location ID=1, it showing # asset= 24 . how do I confirm what's inside locations?

I think I need to setup locations first based on ip addresses, is this possible? we have 3 locations and each location is on a separate network
location 1  10.10.4.x
location 2  10.10.5.x
location 2  10.10.6.x


Answered 03/30/2017 by: kace1000-2015
Senior Yellow Belt

  • You can create a smart label based on IP address to apply a label to computers in each location.
    • how?
      • Smart labels are extremely important to know about when working with KACE, so I suggest becoming familiar with them: https://support.quest.com/technical-documents/kace-systems-management-appliance/7.0/administrator-guide/27
      • for the first location, for example, follow the instructions above and set the label logic to "IP Address" "begins with" "10.10.4." then name the label something like "Comp - Location - Boston"
0
This query will show you all of the software titles installed on machines with a given IP address that starts with "10.10.4.":
SELECT DISPLAY_NAME, COUNT(MACHINE.ID), GROUP_CONCAT(MACHINE.NAME)
FROM SOFTWARE
JOIN MACHINE_SOFTWARE_JT on MACHINE_SOFTWARE_JT.SOFTWARE_ID = SOFTWARE.ID
JOIN MACHINE on MACHINE.ID = MACHINE_SOFTWARE_JT.MACHINE_ID
WHERE MACHINE.IP like "10.10.4.%"
GROUP BY SOFTWARE.ID
I included a count and list of the computer names to help debug the query, you might want to remove those.

Another way to approach the IP address is with the INET_ATON function in MySQL:
Your ranges appear straight forward but for more complicated subnet schemes this could work better. For example:
SELECT DISPLAY_NAME, COUNT(MACHINE.ID), GROUP_CONCAT(MACHINE.NAME)
FROM SOFTWARE
JOIN MACHINE_SOFTWARE_JT on MACHINE_SOFTWARE_JT.SOFTWARE_ID = SOFTWARE.ID
JOIN MACHINE on MACHINE.ID = MACHINE_SOFTWARE_JT.MACHINE_ID
WHERE INET_ATON(MACHINE.IP) between INET_ATON("172.16.16.1") and INET_ATON("172.16.23.255")
GROUP BY SOFTWARE.ID


Answered 03/30/2017 by: chucksteel
Red Belt

0
tried the first query and that did not return any result.
Answered 03/30/2017 by: kace1000-2015
Senior Yellow Belt

  • Are you using a tool like MySQL Workbench to test queries or just creating a report?
    • just creating report
      • I strongly encourage using a tool to help you with reports. Tutorial here: https://support.quest.com/kb/114992
  • What happens if you run only the below query? This might take a little while to run, depending on the size of your environment (took my box 30 seconds):
    SELECT DISPLAY_NAME, COUNT(MACHINE.ID), GROUP_CONCAT(MACHINE.NAME)
    FROM SOFTWARE
    JOIN MACHINE_SOFTWARE_JT on MACHINE_SOFTWARE_JT.SOFTWARE_ID = SOFTWARE.ID
    JOIN MACHINE on MACHINE.ID = MACHINE_SOFTWARE_JT.MACHINE_ID
    GROUP BY SOFTWARE.ID
    • it's showing software and number of machines that has it
      • its shows also windows updates installed and drivers etc..

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