Heber Mac

Hi Michalj, Thank you for your reply and I apologise for the delay in replying to you. Does I get it right, that what you want to achieve, is clearly see which machine is outdated directly in the "computers" table, meaning outdated = endpoint software / agent is outdated. Is this correct? YES, you are correct. meaning outdated = endpoint software OR agent is outdated Reason: Currently if everything goes well with copying and pasting directly from the two individual reports into my Excel spreadsheet, I can generate the report I require in about 20 minutes (minimum time). I can then use the excel spreadsheet to track the effect of the tasks run to correct the problems. It also allows me to Highlight and filter out computers which have NOT connected to Eset Cloud recently. This means that I can concentrate my efforts on the computers I can CONTACT and CURE and track the results of the Tasks run against the various computers. I can’t upload the Excel spreadsheet but I attach herewith a PDF printout of the Excel spreadsheet in two parts. 210210326 010+All+Computer+listing Upload Part 01.pdf In part 01 Columns 1 to 6 are sourced directly from the Computers Category Report. Columns 7 and 8 are copies of column 6 from previous reports. Please note the YYMMDDHHMM Year, Month, Day, Hour and Minute headings. These allow me to track the results of Tasks previously run against the Computer. Please note column 4 this is the date converted into a SORTABLE format YYMMDD so that I can sort the computers and highlight in Blue those which have not contacted Eset Cloud and against which there is no point running tasks as they will not be processed. 210210326 010+All+Computer+listing Upload Part 02.pdf Column 6 and 7 of this report are generated from the Audit and License Management Category. Using Excel “=VLookup()” I allocate the “Outdated Version” into column 3 against the corresponding computers and where the computer has no “Outdated Version” “=vlookup()” puts in a “#N/A”, I would prefer a Blank Cell. Column 9 and 10 “Copy Column B”: Column 10 is compared to column 2 and if they agree an “OK” is put into column 9. The purpose of column 9 and 10 is to highlight if any new computers have been added or removed from the Report. Column 11 (last contact) and 12 : Column 11 is just a copy of the original last contact date exported in the Computer Report. Column 12 then converts this date into a Sortable Format the value of which is then copied back into the real last contact date column. The purpose is to allow the report be sorted by date and the OLD Last Contact computers highlighted in Blue. The objective is to get all the computers listed and show the problems associated with them “AS EFFICIENTLY AS POSSIBLE”. Yes, it does not show all the problems but I can only cure one problem at a time. Michalj: Please understand that I am a USER and my role it to support my clients to the best of my ability. In order for me to do this, I have to be as efficient as possible and this report will save me at least 20 minutes every time I review the status of my Clients Computer Eset Status. I have being using Eset Cloud for some time now and this report makes absolute sense to me. I do not have to go into multiple areas to search for problems that may or may not exist. Thank you. Regards Heber 210210326 010+All+Computer+listing Upload Part 01.pdf 210210326 010+All+Computer+listing Upload Part 02.pdf

Thank you igi008, Yes I see what you are saying but I am trying to get a single report that will show the status / problems on all my client’s computers in one report. There are only 90 computers and Eset can be maintained very easily once the combined report has been created. Regarding the Product Version status most of the occurrences of these errors are associated with computers that have not connected for some time and this is not obvious from the Product Version Status panel. The combined report tells you where the problems are and focuses your attention on correcting the errors. Most problems can be corrected from the same location Computers> Overview> very efficiently. My objective is to not waste time finding the problems but to use my time to fix the problems. The report layout also facilitates tracking problem computers over time. I believe, rightly or wrongly, that the combined report will avoid me wasting my time looking for problems but rather allow me to concentrate on curing problems. Is there any way to link a field in the Audit and License Management Category into a report in the Computers Category? Could Eset see their way to create a new field in the Computers Category which would indicate the status of the Product Version Status of the computer? This would be report either “BLANK” or “Outdated Version” for any of the sub headings (Agent, Endpoint etc.) (one row per computer not multiple rows). igi008, please ask them on my behalf, I have being trying to get this message through for MONTHS. It takes me about 12 minutes (if all goes well) to produce the report every time. This would be better spent correcting the errors that should be visible at the touch of a button. Again thanks for your reply. Regards Heber

Description: Single report linking “Computers” and “Audit and License Management”. Reason, view all computer problems in a single CSV report Detail: Objective to have a single SIMPLE report list of all the computers I am responsible for and highlight any computers which have problems, either computer based or Licence (version) based. ----- OOOOO ----- In detail and screen shots: 210108 Image 01: 210108 Image 02: The above report tells me if I have any problems with the actual computers. If you cure the worst functionality problem, then that is not a bad place to start and I tend to only cure one problem at a time. The above report requires a link to the following field. 210108 Image 03: 210108 Image 04: This field relates to ESET product Status and Eset Agent Status, and if both are Outdated you get duplicate records. I just need to know if either is Outdated and avoid duplicate rows in the combined report. 210108 Image 05: 210108 Image 06: Sample Report The Blue highlights non-current dates, manually entered. Is there any way to link fields between Categories? Regards Heber

While FCS has requested the change because it meets the Polish standard I would also like the DateTime format changed for a much more basic reason. When you export a report in CSV Format it appears as “24/11/2020 18:25:00” This at least is recognisable as a date format for sorting purposes. If you went with the YYYY-MM-DD HH:MM:SS [2020 11 24 18:25:00] (month number “00”) format then if you copied and pasted the contents of an on screen report directly into excel the Date Column would be sortable even if it come in as a text field. Regards Heber

210108 Image 01 210108 Image 02 210108 Image 03 210108 Image 04 210108 Image 05

Reason: Single Click - generated CSV file. You know all the computers that have problems either (Computer Category) “Worst Functionality / Protection Problems” and (Audit and Licence Management Category) “Installed Software Group by (Version check Status). Problem: I don’t know how to link the required fields between the separate Categories. Note: There are two items within the Audit and Licence Management Category “Installed Software Group by (Version check Status)”. Mainly “Is the product is an Outdated Version” and or “Is the management Agent is an Outdated Version”. I only need to know if either of them is an Outdated Version. But even if it means that there will be duplicate rows in the Computer side of the report, I can live with that. Is there any way to link “Fields” between Categories? Could you supply me with a link to a URL that may contain Advanced Report writer information that would cover this topic, please? Just in case ESET actually read these queries the ideal solution would be to have a “Field” available within the “Computer Category”, indicating the status of the Audit and Licence Management Category “Installed Software Group by (Version check Status)”. Binary - Either they are all up to date (Blank) or any of them are not up to date, (Outdated version). Reason: I press the button and immediately know where the problems are and can concentrate of curing the problems rather than Searching for Problems that may or may not exist in multiple reports. I totally accept that I am a new comer to this Cloud Administration but realise, that if this is going to be viable for my clients and I, then its administration has to be as efficient as possible. I have less than 100 computers in my stable but will not be expanding the heard until this problem is resolved. ----- OOOOO ----- In detail and screen shots: Unfortunately I could not Insert Images from URL despite my best efforts. I have tried from Dropbox and Flickr. i could just paste in the URL but i don't think that is what Eset had in mind. 210108 Image 01: 210108 Image 02 The above report tells me if I have any problems with the actual computers. If you cure the worst functionality problem, then that is not a bad place to start and I tend to only cure one problem at a time. The above report requires a link to the following field. Unfortunately I could not Insert Images from URL despite my best efforts. I have tried from Dropbox and Flickr. 210108 Image 03 210108 Image 04 210108 Image 03 Regards Heber