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
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 7 years ago
-
no I dont, where to find it? - kace1000-2015 7 years ago
-
How do you identify site? By Label, Location, etc.? - chucksteel 7 years ago
Answers (5)
Please log in to answer
Posted by:
kace1000-2015
7 years ago
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 7 years ago-
that quest link ask for asset tag or support contract to see the article - kace1000-2015 7 years ago
-
get your service tag: log in, click the question mark in upper right, click "About K1000," check "Serial Number" - JasonEgg 7 years ago
-
Expired Maintenance - kace1000-2015 7 years ago
Posted by:
JasonEgg
7 years ago
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 7 years ago
Posted by:
kace1000-2015
7 years ago
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
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 7 years ago
-
how? - kace1000-2015 7 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 7 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 7 years ago
Posted by:
chucksteel
7 years ago
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
7 years ago
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 7 years ago
-
just creating report - kace1000-2015 7 years ago
-
I strongly encourage using a tool to help you with reports. Tutorial here: https://support.quest.com/kb/114992 - JasonEgg 7 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 7 years ago-
it's showing software and number of machines that has it - kace1000-2015 7 years ago
-
its shows also windows updates installed and drivers etc.. - kace1000-2015 7 years ago