/build/static/layout/Breadcrumb_cap_w.png

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

0 Comments   [ + ] Show comments

Answers (5)

Answer Summary:
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]
Posted by: jdornan 11 years ago
Red Belt
1

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
Posted by: jdornan 11 years ago
Red Belt
0

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
Posted by: murbot 11 years ago
10th Degree Black Belt
0

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.

Posted by: jknox 11 years ago
Red Belt
0

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.

Posted by: dugullett 11 years ago
Red Belt
0

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%'

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