Kace Agent - Check if current version is installed
Is there a way to create a report to check if machines have the current Kace agent installed without entering the current agent version?
I'm looking for a '$current_agent_variable' basically. I have a report that finds machines with 'Server' in the OS name, but want to also add a way to check if each server has the current Kace agent regardless of what the current agent is. I don't want to have to remember to update the report each time we update the Kace agent.
Thanks!
Sort of like below:
If OS name contains 'Server' and the Kace agent version is < $current_agent_variable
Answers (5)
My mostly final code...until I add something, then add something, then ... [code] SELECT NAME, IP, CLIENT_VERSION FROM MACHINE WHERE (( OS_NAME like '%Server%') AND MACHINE.CLIENT_VERSION != (SELECT VERSION FROM CLIENT_DISTRIBUTION WHERE ID = 1)) GROUP BY MACHINE.ID [/code]
Okay It intriguied me once everyone start the discussion rolling so I did some digging..
SELECT NAME, IP, CLIENT_VERSION FROM MACHINE
WHERE
MACHINE.CLIENT_VERSION != (SELECT VERSION FROM CLIENT_DISTRIBUTION WHERE ID = 1)
Comments:
-
WINNER!! Awesome!
Thanks so much
My mostly final code...until I add something, then add something, then ...
[code]
SELECT NAME, IP, CLIENT_VERSION FROM MACHINE
WHERE
(( OS_NAME like '%Server%') AND MACHINE.CLIENT_VERSION != (SELECT VERSION FROM CLIENT_DISTRIBUTION WHERE ID = 1)) GROUP BY MACHINE.ID
[/code] - murbot 11 years ago
There is a variable for the agent installed. $(kace_agent_version) but this wont tell you if its current or not. As far as I know there is no variable that pulls the current version you are deploying.
Comments:
-
Thanks.
hmmm.... I suppose if I trust myself I could poll a machine that I know to have the current version and that gets the current version quickly after a new agent bundle is loaded into Kace. Then use that as the value. Not sure how to poll one machine, then compare. Time to tinker.... or ask our SQL admin. :-)
If anyone has suggestions, please share. This would be very helpful. - murbot 11 years ago
Duh! I can run something that checks the directory where I store the current agent for the file version and then use that as the variable. Just need to figure out how to pass it back to another report.
If you want an overall report of the numbers of each agent version in your environment, you can do that using the built-in report wizard:
Reporting>Choose Action>Add New Report (Wizard)
1. Title the report as necessary and assign the category as needed.
2. Select Software as the Report Topic.
3. Under Software Info, select Display Name and Display Version.
4. Sort and add breaks as needed.
5. Under Filters, add a filter that matches: Display Name contains kace
If you want a report of which computers have which agents, it would be similar to the above, but you would select Computer as the topic and pick "System Name" and "Agent Version" under Computer Identity Information.
Can you just go to Settings>K1000 Agent>Agent Updates from Kace. Make sure it's enabled, and under limit update to labels add you server label. That way whenever you do upload a new package that server label would automatically get it on next check in.
Then I guess you can still run a report, but I'm not sure of any way around not changing it everytime. To verify it is working. It will more than likely not be needed though.
SELECT NAME, IP FROM MACHINE M LEFT JOIN MACHINE_SOFTWARE_JT MSJT ON M.ID = MSJT.MACHINE_ID LEFT JOIN SOFTWARE S ON MSJT.SOFTWARE_ID = S.ID WHERE (S.DISPLAY_NAME = 'DELL KACE AGENT' AND S.DISPLAY_VERSION != '5.4.5315') AND OS_NAME LIKE '%server%'