(Note: the columns are always the same in every worksheet. Macro 2: ARD_Convert2_Columns - Makes some minor adjustments to the columns, including adding columns to allow for the calculation of seconds into hours, along with removing the unnecessary columns in the report. This contains just the basic conversion from CSV to Excel. Macro 1: ARD_Convert1_Import - Import text file from predetermined location into a new sheet in an existing workbook. Here are the macros I've successfully built without issue: "Front Most in Seconds" is recorded as a standard number and is the focus of this project. "Front Most" is recorded in this format: "1h, 5m" making it impossible to use for any sort of total. In this row there are two kinds of time: "Front Most" and "Front Most in Seconds." The primary issue is the way ARD records Application Usage: every instance of an application starting and shutting down and the length of time it was running is in a separate row. I'm doing this in a series of small macros, primarily to make it easier to troubleshoot. This will be used among numerous teams, so the amount of data will always be changing in every report. To convert the CSV File from Apple Remote Desktop into an easy-to-read format using a series of Excel Macros (or other options as possible). Text File (CSV) from Apple Remote Desktop on Application Usage for a dynamic series of Macs.
0 Comments
Leave a Reply. |