Hello all. I am relatively new to Kaseya. The reporting tool leaves a lot to be desired and as a SaaS user, I am restricted from the RDBMS. I am attempting to develop a report part that depicts ONLY the most recent Agent Procedure Log entry for a specific Procedure. The procedure captures a file from the agent machine into a variable then writes the variable to the Agent Procedure Log. I want the log entry on a report but I do not want any history - just the most current entry.
The report part can query for the Top N but I am not able to specify less than two. In SQL I'd simply sort by the date descending and retrieve the TOP 1.
Any thoughts?
I would add a column in your report for log time and set the aggregate to MAX.
I made a report that if a certain folder was ever found it would write in the agent logs so I could report off of it. This customer has 400+agents that I needed to see for this folder. I only wanted to know the latest log entry so I made a report and added a column for procedure step description and filtered my exact phrase that was in the logs. Then I added another column for log time, and set the aggregate to MAX. I found this only shows me the last log entry for that particular phrase that I filtered for. Maybe change your report to do this? If you need more help send me an E-mail and I might be able to send you screen shots.
RN
I would also like to know how to do this. I run a Procedure that logs the status of different services. Through when I first made it we wanted to know history. We would also like to know now what the last status that was reported. I would filter by date. But only column/data field I can find starts with time.
Thanks, Ryan. Makes perfect sense. I'll give that a shot.
Cris
Ok Let me know if you need any more help.
Ryan, that is really close. but some how I still ended up with 2 per. Down from 15...
DL did you ever figure it out? I would suggest changing how your filtering the information. Filter the exact phrase your looking for in the logs. My guess is your getting two phrases that are almost identical.
Ryan,
Yes I think I got what I was looking for. You are correct, I had 2 var that were close it each other.
Thanks for the help
No problem!