/build/static/layout/Breadcrumb_cap_w.png

software list

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
  • Do you know the ASSET_TYPE_ID for Location? I think it's 1 by default but I could be wrong. - JasonEgg 4 years ago
  • no I dont, where to find it? - kace1000-2015 4 years ago
  • How do you identify site? By Label, Location, etc.? - chucksteel 4 years ago

Answers (5)

Posted by: kace1000-2015 4 years ago
Senior Yellow Belt
0
what the name of the tool from quest that need to download?

Comments:
  • 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 - JasonEgg 4 years ago
    • that quest link ask for asset tag or support contract to see the article - kace1000-2015 4 years ago
      • get your service tag: log in, click the question mark in upper right, click "About K1000," check "Serial Number" - JasonEgg 4 years ago
      • Expired Maintenance - kace1000-2015 4 years ago
Posted by: JasonEgg 4 years ago
Red Belt
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:


Comments:
  • This assumes you're using Location asset to assign location, you may be using another method - JasonEgg 4 years ago
Posted by: kace1000-2015 4 years ago
Senior Yellow Belt
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



Comments:
  • You can create a smart label based on IP address to apply a label to computers in each location. - chucksteel 4 years ago
    • how? - kace1000-2015 4 years ago
      • 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 - JasonEgg 4 years ago
      • 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" - JasonEgg 4 years ago
Posted by: chucksteel 4 years ago
Red Belt
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


Posted by: kace1000-2015 4 years ago
Senior Yellow Belt
0
tried the first query and that did not return any result.

Comments:
  • Are you using a tool like MySQL Workbench to test queries or just creating a report? - chucksteel 4 years ago
    • just creating report - kace1000-2015 4 years ago
      • I strongly encourage using a tool to help you with reports. Tutorial here: https://support.quest.com/kb/114992 - JasonEgg 4 years ago
  • 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 - JasonEgg 4 years ago
    • it's showing software and number of machines that has it - kace1000-2015 4 years ago
      • its shows also windows updates installed and drivers etc.. - kace1000-2015 4 years ago

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