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
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]
Cancel
0 Comments   [ + ] Show Comments

Comments

Please log in to comment

Community Chosen Answer

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)
Answered 02/26/2013 by: jdornan
Red Belt

  • 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]
Please log in to comment

Answers

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. 

Answered 02/26/2013 by: jdornan
Red Belt

  • 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.
Please log in to comment
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.

Answered 02/26/2013 by: murbot
Tenth Degree Black Belt

Please log in to comment
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.

Answered 02/26/2013 by: jknox
Red Belt

Please log in to comment
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%'
Answered 02/26/2013 by: dugullett
Red Belt

Please log in to comment
Answer this question or Comment on this question for clarity