MacOS Computers and Installed Programs
I have an issue where some of our MacOS computers aren't reporting the installed programs correctly. The machines only show a few programs rather than the correct number. I only noticed the issue when looking into something else so I'm wondering if this is occurring for other folks as well. I have a support ticket entered but I'd like to see if anyone else gets similar results, in case it is something particular to our environment. The following SQL query will find computers with less than 10 titles installed. If anyone has a moment, I would appreciate it if you could create a report or run the query in their favorite MySQL tool and see if it returns machines:
SELECT InstallCounts.MACHINE_ID as MID, InstallCounts.Installs as Installs,
MACHINE.NAME, MACHINE.OS_NAME, CLIENT_VERSION, MACHINE.LAST_INVENTORY
from (SELECT MACHINE_ID, COUNT(*) as Installs FROM ORG1.MACHINE_SOFTWARE_JT MSJT
GROUP BY MACHINE_ID) as InstallCounts
JOIN MACHINE on MACHINE.ID = InstallCounts.MACHINE_ID
where Installs < 10;
Thanks.
SELECT InstallCounts.MACHINE_ID as MID, InstallCounts.Installs as Installs,
MACHINE.NAME, MACHINE.OS_NAME, CLIENT_VERSION, MACHINE.LAST_INVENTORY
from (SELECT MACHINE_ID, COUNT(*) as Installs FROM ORG1.MACHINE_SOFTWARE_JT MSJT
GROUP BY MACHINE_ID) as InstallCounts
JOIN MACHINE on MACHINE.ID = InstallCounts.MACHINE_ID
where Installs < 10;
Thanks.
0 Comments
[ + ] Show comments
Answers (5)
Please log in to answer
Posted by:
scottlutz
12 years ago
Chaps,
this is a known issue, and already has a bug filed against, though I don't have the number handy. It is targeted at the 5.4 release at present, though this may change.
Mlathrop, if you haven't filed a support ticket, please do so that it can get escalated appropriately.
this is a known issue, and already has a bug filed against, though I don't have the number handy. It is targeted at the 5.4 release at present, though this may change.
Mlathrop, if you haven't filed a support ticket, please do so that it can get escalated appropriately.
Posted by:
steelc
12 years ago
Thanks, Scott.
Now I'm wondering: How many known issues are there that aren't listed in the release notes? I just double checked the latest release notes for both the server and client and this issue isn't listed in either one. Also, has KACE ever considered posting the known issues/bugs online? I normally check the knowledge base before submitting support requests and I would happily check a list of known issues as well, if I could.
Now I'm wondering: How many known issues are there that aren't listed in the release notes? I just double checked the latest release notes for both the server and client and this issue isn't listed in either one. Also, has KACE ever considered posting the known issues/bugs online? I normally check the knowledge base before submitting support requests and I would happily check a list of known issues as well, if I could.
Posted by:
scottlutz
12 years ago
Sorry, I should have clarified....
By known issue, I meant that it has been seen "in the wild", and that there is a ticket filed against it. It was discovered post 5.3 release, which is why it's not in the Release Notes.
HTH
By known issue, I meant that it has been seen "in the wild", and that there is a ticket filed against it. It was discovered post 5.3 release, which is why it's not in the Release Notes.
HTH
Posted by:
mlathrop
12 years ago
support ticket submitted.
I have the same 'beef' - known issues are not communicated globally, only to individuals reporting them. Also release notes are often difficult to locate. Example: My k2000 has notified me that an update has been downloaded and is ready to install - link to the release notes is missing https://service.kace.com/service/kbox2000/updates/downloads/release_notes_3.3.52857.txt
Also multiple searches on kace support site turn up NOTHING on release 3.3.52857
I have the same 'beef' - known issues are not communicated globally, only to individuals reporting them. Also release notes are often difficult to locate. Example: My k2000 has notified me that an update has been downloaded and is ready to install - link to the release notes is missing https://service.kace.com/service/kbox2000/updates/downloads/release_notes_3.3.52857.txt
Also multiple searches on kace support site turn up NOTHING on release 3.3.52857
Rating comments in this legacy AppDeploy message board thread won't reorder them,so that the conversation will remain readable.