Help with Analyses and Reporting pls

Is it possible to create Analyses to pull all content from a CSV file stored locally on a target endpoint? Then report on it…
Similar to the relvance for ‘lines of file’.

Scenario
Our company looks after several external businesses. Monthly scheduled tasks run to create a report (csv) of all the privileged users that exist in their AD environments. This is then emailed outbound to a number of recipients. We want to find an alternative method as this is a little archaic plus insecure and a pain to keep having to open up SMTP etc

So, we tried using BigFix’s Upload Archive Manager to try and retrieve the CSV files from the customers Relay servers and bring them inbound to our central BigFix servers. This kinda worked although our app support guys didnt like these being stored on our root servers :frowning:

Thus, I was thinking, could it be possible to setup an Analyses for this and use relavance similar to ‘line of file’ that pulls data from the csv file so we can report on it. I am fairly new to BigFix and not familiar with writing relevance so would greatly appreciate any help.

Example of CSV contents below (sorry, couldn’t attach)
Group Name Display Name First Name Last Name Username Description Last logon date Enabled Password never expires Date created
Administrators NTAdmin NTAdmin Built-in account for administering the computer/domain 22/12/2021 8:05:01 a.m. TRUE TRUE 29/06/2003 11:22:24 a.m.
Administrators Translogix Translogix Translogix 16/06/2020 9:14:31 a.m. TRUE TRUE 8/08/2012 10:00:41 a.m.

A post was merged into an existing topic: Is it possible to create Analyses to pull all content from a CSV file on a target endpoint?